Data Analysis Excel Templates

Target against actual with on/off-target status, direction-aware so lower can be better.

For: A manager reporting monthly numbers

Scores options against weighted criteria so the choice is calculated, not argued.

For: Anyone choosing between options on more than price

Twelve checks to run before any analysis, with progress tracked as you work.

For: An analyst inheriting somebody else’s data

Turns 1–5 responses into averages, top-box scores and a distribution per question.

For: Whoever ran the survey

Compare vendors or products feature by feature, with a must-have check that fails loudly.

For: A buyer evaluating software or suppliers

Where the hours actually went, split billable against non-billable by client and activity.

For: A consultant or agency reviewing where hours went

Whether a conversion difference is real or noise — z-score, p-value and a plain verdict.

For: A marketer checking a result is real

Mean, median, quartiles, spread and z-scores for a column of numbers, with outliers flagged.

For: A student, researcher or analyst

A three-month moving average, a fitted trend line and the next three periods, with the error measured.

For: Anyone forecasting from past figures