Excel Reporting Tools
Tools that turn raw data into summaries, pivots, dashboards, and shareable reports.
Add Running Total Column
Write a cumulative running total to the column next to your numeric column, in one pass
Add Totals Row to Numeric Columns
Drop a SUM formula at the bottom of every numeric column in your selection, plus a 'Total' label and a top border
Auto Pivot Summary
One-click summary of any data: group by one column and sum another, output to a new Summary sheet
Compare Two Columns
Highlight every cell in two columns whose value does not appear in the other column, in one click.
Count and Sum Cells by Color
Count how many cells share a background color, and sum them when they're numeric, with one click
Highlight Top and Bottom Values
Color the top N values green and the bottom N values red in your selection in one click
Insert Blank Row On Change
Insert a blank row above every cell where a chosen column's value changes from the row above.
Quick Statistics Summary
One-click count, mean, median, mode, standard deviation, min, max, and range for any column of numbers