141 free Excel templates
Every one has working formulas, realistic sample data and a Start here sheet that explains the method — not just which cells to fill in. Open any page below to see a real slice of the sheet before you decide.
Free account · 3 templates free and yours forever · unlimited on Pro
Finance 21
12-Month Cash Flow Forecast TemplateProject inflows and outflows month by month with best/base/worst scenarios and a running balance.2 sheets · 69 formulas · 11 KB
3-Statement Financial Model TemplateA lightweight linked P&L, balance sheet and cash flow for quick scenario work.5 sheets · 337 formulas · 14 KB
Accounts Receivable Aging TemplateBucket unpaid invoices by age (30/60/90+) and flag overdue accounts to chase.3 sheets · 135 formulas · 14 KB
Annual Budget Builder TemplateTwelve-month budget from department inputs, with four phasing shapes.4 sheets · 202 formulas · 13 KB
Break-Even Analysis TemplateFind the units and revenue where you cover costs, with a contribution-margin breakdown.3 sheets · 117 formulas · 12 KB
Budget vs Actual TemplateVariance by line with the favourable/adverse rule applied and material gaps flagged.5 sheets · 398 formulas · 17 KB
Business Expense Tracker TemplateLog spend, auto-categorise it, and see totals by category and month.3 sheets · 363 formulas · 16 KB
Discount & Margin Calculator TemplateWhat a discount costs in margin, and the volume needed to stand still.2 sheets · 60 formulas · 9 KB
Fixed Asset & Depreciation TemplateStraight-line and reducing-balance side by side, with net book value.3 sheets · 71 formulas · 10 KB
Holt-Winters Forecasting TemplateTriple exponential smoothing with trend and seasonality, plus 95% confidence bands.3 sheets · 231 formulas · 13 KB
Invoice Tracker TemplateInvoices from raised to paid, with each customer's real days-to-pay.3 sheets · 174 formulas · 12 KB
Loan & Amortisation Schedule TemplateEvery payment split into interest and principal, with overpayment modelling.2 sheets · 604 formulas · 16 KB
Monte Carlo Simulation TemplateGive each assumption a worst/likely/best range and see P10–P90 outcomes across thousands of trials.5 sheets · 5,025 formulas · 51 KB
NPV & IRR Appraisal TemplateNPV, IRR, payback and a rate sensitivity table — with Excel's year-zero trap shown.2 sheets · 39 formulas · 9 KB
Payroll Cost Model TemplateTurns salaries into the fully-loaded cost that actually leaves the bank.4 sheets · 139 formulas · 13 KB
Profit & Loss TemplateA month-by-month income statement with gross, operating and net margin on every line.4 sheets · 319 formulas · 16 KB
Quote & Estimate Builder TemplatePriced quote with VAT and contingency, showing job margin before you send.2 sheets · 30 formulas · 9 KB
SaaS P&L Statement TemplateSaaS P&L with gross margin, Rule of 40 and the magic number.3 sheets · 70 formulas · 12 KB
Sales Commission Calculator TemplateTiered commission on every deal without nested IF formulas.4 sheets · 136 formulas · 12 KB
Startup Runway and Burn Rate TemplateTrack monthly burn and cash balance to see exactly how many months of runway remain.3 sheets · 78 formulas · 12 KB
Unit Economics (CAC, LTV, Payback) TemplateCAC, LTV and payback — with LTV on gross profit, not revenue.3 sheets · 40 formulas · 9 KB
Data 14
Anomaly Detection TemplateFlags values sitting outside the normal range using IQR and standard-deviation rules.2 sheets · 153 formulas · 12 KB
Correlation Matrix TemplateSee which columns move together in a colour-coded matrix.3 sheets · 29 formulas · 12 KB
Data Cleaning Checklist TemplateEleven checks over a column, including the non-breaking space TRIM cannot remove.4 sheets · 115 formulas · 11 KB
Descriptive Statistics TemplateSixteen summary statistics and a histogram, with mean-vs-median guidance.3 sheets · 39 formulas · 13 KB
Heat Map TemplateA colour-scaled grid for spotting concentration in any two-dimensional table.5 sheets · 46 formulas · 14 KB
Linear Regression TemplateFit a line to two columns and read the slope, intercept and R².3 sheets · 189 formulas · 13 KB
Pareto (80/20) Analysis TemplateRanks categories and overlays the cumulative percentage to find the vital few.3 sheets · 80 formulas · 11 KB
Pivot Table Starter TemplatePivot-ready data plus the same summary built with SUMIFS, so you can check the pivot.3 sheets · 20 formulas · 15 KB
Remove Duplicates and Clean Data TemplateStrip duplicates, fix casing and trim whitespace in one pass.3 sheets · 45 formulas · 10 KB
Running Total TemplateAdd a cumulative column with an optional reset per group.2 sheets · 150 formulas · 11 KB
Scenario Planner TemplateBest, base and worst run together, with the lowest cash point in each.4 sheets · 165 formulas · 13 KB
Sensitivity Analysis TemplateFlex one or two inputs and watch the output move in a data table.5 sheets · 88 formulas · 13 KB
Two-Way Lookup (INDEX/MATCH) TemplateFinds the value where a row and a column meet — the lookup VLOOKUP cannot do.3 sheets · 4 formulas · 9 KB
VLOOKUP to XLOOKUP TemplateThe same five lookups written both ways, so you can see exactly what XLOOKUP fixes.3 sheets · 25 formulas · 10 KB
Sales 13
A/B Test Significance Templatez-test p-value plus the sample size to fix before you start.3 sheets · 19 formulas · 10 KB
Campaign Tracking Template with UTMRoll up clicks, spend and conversions by campaign and channel.3 sheets · 157 formulas · 12 KB
Cohort Retention TemplateA retention triangle by joining month, with a conditional-format heatmap.5 sheets · 3,419 formulas · 42 KB
Content Calendar TemplatePlan posts by date, channel and status in one editable grid.3 sheets · 72 formulas · 11 KB
Customer Churn Analysis TemplateChurn rate by month and segment, with the revenue attached to each churned account.3 sheets · 221 formulas · 15 KB
Funnel Chart TemplateStep-by-step drop-off from first touch to purchase, with conversion at every stage.2 sheets · 26 formulas · 10 KB
Lead Scoring TemplateScore inbound leads on fit and intent so sales works the best ones first.4 sheets · 57 formulas · 11 KB
MRR Movements Bridge TemplateNew, expansion, contraction, churn and reactivation as a bridge.3 sheets · 81 formulas · 12 KB
Marketing Budget TemplatePlan vs spend by channel with pacing and remaining budget.4 sheets · 53 formulas · 13 KB
Merge Two Spreadsheets TemplateJoins two lists on a shared key and counts the rows that did not match.5 sheets · 78 formulas · 11 KB
RFM Segmentation TemplateScores every customer on recency, frequency and monetary value into named segments.5 sheets · 1,122 formulas · 36 KB
Sales Forecast TemplateWeighted pipeline, run-rate and committed forecasts side by side.3 sheets · 10 formulas · 11 KB
Sales Pipeline TemplateWeight deals by stage to a forecast and see where the quarter lands.4 sheets · 111 formulas · 14 KB
Projects 13
Attendance & Absence TemplateDaily attendance codes with holiday totals and the Bradford Factor.3 sheets · 48 formulas · 10 KB
Capacity Planning TemplateHours available against hours demanded, flagging who is over-committed.4 sheets · 40 formulas · 13 KB
Gantt Chart TemplateTurn a task list with start, due and %-complete into a live timeline that colours by schedule health.3 sheets · 127 formulas · 12 KB
Inventory Management TemplateReorder points, safety stock and ABC classification from a stock-and-sales file.2 sheets · 61 formulas · 11 KB
Meeting Actions & Decisions TemplateActions and decisions logged separately, with overdue by owner.4 sheets · 40 formulas · 11 KB
OKR Tracker TemplateObjectives and key results with progress bars that roll up to a score.3 sheets · 37 formulas · 10 KB
Product Launch Checklist TemplateEvery pre-launch task with owner, due date and done state in one view.3 sheets · 84 formulas · 11 KB
Product Roadmap TemplatePlot initiatives across quarters with owners and status in one shareable timeline.3 sheets · 40 formulas · 10 KB
Project Tracker TemplateTasks with owner, status and percent complete, rolled up to project health.4 sheets · 209 formulas · 16 KB
Purchase Order Tracker TemplatePOs from raised to invoiced, with committed spend and a three-way match.3 sheets · 123 formulas · 12 KB
Risk Register TemplateLog risks with likelihood, impact and a RAG status, sorted by exposure.3 sheets · 48 formulas · 11 KB
Supplier Scorecard TemplateWeighted scoring on price, quality, delivery and responsiveness.3 sheets · 17 formulas · 10 KB
Timesheet & Utilisation TemplateBillable utilisation and effective hourly rate by person and client.4 sheets · 130 formulas · 15 KB
Reporting 9
Board Report TemplateThe charts and tables a board expects, ready to drop into slides.3 sheets · 40 formulas · 13 KB
Client Report TemplateThe monthly agency report — results against target, hours against retainer.2 sheets · 13 formulas · 9 KB
Goal Tracker TemplateTrack progress to a target with pace and projected finish.2 sheets · 30 formulas · 9 KB
KPI Dashboard TemplateA one-page board of headline metrics with sparklines and period-on-period deltas.4 sheets · 175 formulas · 16 KB
Month-Over-Month Growth TemplateMonth-over-month and year-over-year growth with a clean trend line.3 sheets · 110 formulas · 11 KB
Sales Dashboard TemplateRevenue, pipeline and rep performance on a single sheet.4 sheets · 280 formulas · 20 KB
Variance Analysis TemplateVariance by line with written commentary explaining why each moved.2 sheets · 43 formulas · 11 KB
Waterfall Chart TemplateShow how you get from last period to this one, step by step.3 sheets · 62 formulas · 12 KB
Weekly Business Report TemplateA one-page summary of the week’s numbers, written from your data.3 sheets · 36 formulas · 10 KB
Advanced techniques 29
ABC / XYZ Inventory ClassificationValue concentration crossed with demand predictability into a nine-box, each cell with its own stocking policy.5 sheets · 588 formulas · 20 KB
Bank Reconciliation with Auto-MatchTwo matching passes — exact key, then amount within a date window — with the reconciliation identity proved to the penny.5 sheets · 461 formulas · 19 KB
Cap Table & Exit WaterfallA liquidation preference stack resolved across ten exit values, including where each preferred class converts to ordinary.3 sheets · 125 formulas · 11 KB
Capital Appraisal: NPV, IRR, MIRR, PaybackAll six appraisal measures from dated cash flows, including MIRR and discounted payback, with a warning when IRR has multiple answers.3 sheets · 47 formulas · 10 KB
Contribution Margin & Operating LeverageContribution by line, fixed cost kept as a period cost, and the degree of operating leverage that turns a 10% revenue miss into a 40% profit miss.3 sheets · 72 formulas · 12 KB
Critical Path Method (CPM)Forward and backward pass, total and free float, the critical path listed, and which task is actually worth crashing.4 sheets · 360 formulas · 16 KB
Customer LTV from a Retention CurveLTV built from a fitted survival curve and discounted, and how far the ARPU-over-churn shortcut is out.3 sheets · 216 formulas · 13 KB
Data Validation Rulebook & Quality ScoreTwelve explicit rules, severity-weighted, scored per row and per field, with a fix-first ranking by damage rather than by count.5 sheets · 978 formulas · 25 KB
Driver Tree Rolling ForecastRevenue decomposed into traffic, conversion, order value and repeat rate, each forecast separately — plus what compounding optimism does to the total.5 sheets · 125 formulas · 15 KB
Dynamic Array Reporting (no pivot table)A whole pivot rebuilt with FILTER, UNIQUE, SORT, LET and BYROW, so it can never be stale — plus a cookbook of the ten patterns.4 sheets · 247 formulas · 18 KB
EOQ, Safety Stock & Reorder PointOrder quantity, buffer and reorder point including lead-time variability — the term almost every spreadsheet leaves out.5 sheets · 325 formulas · 18 KB
Earned Value ManagementPV, EV, AC, CPI, SPI, three estimates at completion, and the TCPI that says whether the recovery plan is arithmetically possible.5 sheets · 249 formulas · 17 KB
Erlang C Contact-Centre StaffingThe Erlang B recursion in a column, so a real staffing model runs in plain Excel — service level, ASA, occupancy and shrinkage.5 sheets · 685 formulas · 22 KB
Fuzzy Name Matching Between Two ListsMatches misspelt company names with a letter-frequency cosine computed in formulas, and a runner-up gap that says when not to trust it.5 sheets · 4,165 formulas · 40 KB
Lease vs BuyAfter-tax present-value comparison including capital allowances and residual value, with a sensitivity on the residual that usually decides it.5 sheets · 107 formulas · 12 KB
Loan Overpayment & Offset ComparisonTwo amortisation schedules side by side. Interest saved, months removed from the term, and why an offset beats an overpayment.4 sheets · 2,711 formulas · 36 KB
Monte Carlo Cash Runway500 simulated cash paths over 18 months. Runway as a P5/P50/P95 distribution, and the probability of running out inside 12 months.4 sheets · 10,544 formulas · 104 KB
Pocket Price Waterfall — Discount LeakageEvery deduction between list price and the money that reaches the bank, including the off-invoice leaks nobody manages.4 sheets · 251 formulas · 17 KB
Portfolio Efficient FrontierTwo-asset mean-variance with the correlation term, 21 portfolios, and the minimum-variance and maximum-Sharpe points marked.3 sheets · 111 formulas · 12 KB
Price Elasticity & Profit-Optimal PriceElasticity estimated by log-log regression from your own price history, then the price that maximises profit rather than revenue.3 sheets · 169 formulas · 15 KB
Resource Levelling & Over-AllocationEvery assignment against real capacity week by week, so over-allocation is visible before the plan is committed rather than after it fails.5 sheets · 815 formulas · 21 KB
Rolling 13-Week Cash FlowThe treasury standard. Receipts and payments by week, the low point, facility and covenant headroom, and a forecast-accuracy score.3 sheets · 163 formulas · 14 KB
Rolling Z-Score & MAD Outlier DetectionA robust MAD score that finds the outliers an ordinary z-score hides inside its own standard deviation, and separates level shifts from errors.5 sheets · 1,424 formulas · 27 KB
SPC Control Chart (X-bar & R)Real statistical process control: subgroup means and ranges, the standard constants, Cp/Cpk, and all four Western Electric run rules.4 sheets · 406 formulas · 18 KB
Shift Rota Coverage & FairnessDemand hour by hour against who is rostered, plus the distribution of unsociable hours that predicts who resigns.5 sheets · 353 formulas · 17 KB
Tornado Sensitivity AnalysisSeven drivers flexed one at a time by their own plausible range, ranked by swing. The widest bar is the assumption worth arguing about.3 sheets · 92 formulas · 12 KB
Variance Bridge: Price, Volume, MixBudget to actual decomposed three ways per product, reconciling to the penny. Mix is the effect everyone omits and the one that explains margin.4 sheets · 111 formulas · 13 KB
Weighted Decision Matrix (AHP)Criteria weights derived from pairwise comparisons, with the consistency ratio that tells you when your judgements contradict each other.4 sheets · 99 formulas · 12 KB
Win-Rate AttributionA change in win rate decomposed into the stage conversions that caused it, multiplicatively, reconciling exactly to the total.4 sheets · 57 formulas · 13 KB
Agency 3
Retainer ProfitabilityWhat each retainer earns once hours are costed, ranked by effective hourly rate rather than by fee — which reverses the list.4 sheets · 137 formulas · 14 KB
Scope Creep & Change ControlEvery change request priced whether or not it was charged, and the absorbed total that turns a 45% project into a 12% one.4 sheets · 83 formulas · 15 KB
Utilisation & Rate CardDerives a defensible day rate from salary, utilisation and target margin, then prices every point of the utilisation gap.4 sheets · 85 formulas · 12 KB
Construction 4
Cost Value Reconciliation (CVR) TemplateEarned value against cost to complete, with retention shown separately.3 sheets · 58 formulas · 12 KB
Plant & Equipment Utilisation TemplateUtilisation per machine and the break-even days that decide own or hire.3 sheets · 67 formulas · 10 KB
Subcontractor Payment & Retention TemplateApplied vs certified per trade, with retention release dates.3 sheets · 110 formulas · 11 KB
Tender & Bid Tracker TemplateWin rate, cost per win, and the gap to the winning price.3 sheets · 68 formulas · 11 KB
E-commerce 3
Marketplace Fee ReconciliationRebuilds what the marketplace should have paid you, line by line, and flags every settlement line that does not match.4 sheets · 459 formulas · 15 KB
Returns & Refund AnalysisCosts returns properly by SKU, reason and channel — postage both ways, handling, and the units that come back unsellable.5 sheets · 428 formulas · 20 KB
Stock Cover & Sell-ThroughWeeks of cover on recent rate of sale crossed with sell-through, so the buy list separates a stockout from dead money.4 sheets · 381 formulas · 18 KB
Education 3
Attainment & Progress Gap TemplateProgress against baseline by group, with small cohorts flagged.3 sheets · 196 formulas · 16 KB
Attendance & Persistent Absence TemplatePersistent and severe absence, and the authorised/unauthorised split.3 sheets · 383 formulas · 16 KB
Budget per Pupil TemplateCost per pupil by category, with staffing % and a falling-roll model.3 sheets · 58 formulas · 12 KB
Fitness 2
Class Schedule & Utilisation TemplateAttendance against capacity and contribution per class, not just how full it looks.3 sheets · 244 formulas · 13 KB
Membership Churn & Retention TemplateChurn, average member life, and what one point of churn is worth.3 sheets · 155 formulas · 13 KB
HR & People 5
Absence & Bradford FactorAbsence rate for reporting and the Bradford factor for managing, with trigger points that fire automatically.4 sheets · 187 formulas · 15 KB
Headcount Plan & Attrition ForecastTwelve months of headcount from today's team, expected leavers and planned hires — including the replacement hiring nobody budgets.4 sheets · 108 formulas · 13 KB
Onboarding & Time to ProductivityTracks new starters to productive, not just to onboarded, and prices the ramp — which usually exceeds the agency fee.4 sheets · 89 formulas · 15 KB
Salary Benchmarking & Pay Gap AnalysisCompa-ratios against grade benchmarks, mean and median gaps, and the split between a pay gap and a structure gap.4 sheets · 234 formulas · 15 KB
Skills Matrix & Training GapScores the team against the skills the work needs and names every capability with a bus factor of one.5 sheets · 101 formulas · 15 KB
Healthcare 2
Clinic Utilisation & DNA TemplateAttended against offered, DNA rate, and the value of empty chairs.3 sheets · 128 formulas · 13 KB
Payer Mix & Treatment Profitability TemplateContribution per clinical hour by treatment and payer.3 sheets · 138 formulas · 13 KB
Hospitality 3
Food & Beverage Cost Control TemplateTheoretical against actual food cost, and the gap wastage cannot explain.4 sheets · 147 formulas · 14 KB
Labour Scheduling vs Covers TemplateCovers per labour hour and labour % by shift, not by week.3 sheets · 203 formulas · 14 KB
Menu Engineering TemplateStars, plough-horses, puzzles and dogs — ranked on cash, not GP%.3 sheets · 145 formulas · 13 KB
Logistics 3
Fleet Cost per Mile TemplateStanding and running costs split — why an idle vehicle costs so much per mile.3 sheets · 83 formulas · 12 KB
Route & Job Profitability TemplateProfit per hour and per mile, with the return leg counted.3 sheets · 164 formulas · 12 KB
Warehouse Pick Productivity TemplatePicks per hour scored against accuracy, not speed alone.3 sheets · 282 formulas · 14 KB
Nonprofit 3
Donor Retention & Lapse TemplateRetention, lapse and donor lifetime value against cost to recruit.3 sheets · 315 formulas · 16 KB
Fund Accounting TemplateRestricted, unrestricted and designated kept apart, with a breach check.3 sheets · 35 formulas · 12 KB
Grant Tracker & Conditions TemplateGrants from application to final report, with the deadlines that end relationships.3 sheets · 123 formulas · 12 KB
Professional services 2
Engagement Profitability TemplateEffective rate and grade mix against the fee that was quoted.3 sheets · 134 formulas · 12 KB
WIP & Lock-Up Days TemplateWIP days plus debtor days — the cash a profitable firm cannot spend.3 sheets · 102 formulas · 11 KB
Property 4
Development Appraisal TemplateResidual land value, with the sensitivity grid that is the real appraisal.2 sheets · 36 formulas · 9 KB
Rent Roll & Arrears TemplateRent due against collected, arrears aged, and the lease events nobody diarises.4 sheets · 359 formulas · 14 KB
Service Charge Apportionment TemplateCosts apportioned per tenant, with a check that the schedule totals 100%.3 sheets · 63 formulas · 10 KB
Void & Letting Performance TemplateWhat each empty unit costs, split into refurb, marketing and legal days.3 sheets · 112 formulas · 13 KB
Recruitment 2
Placement Margin & Consultant TemplateContract margin after employer on-costs, annualised against permanent fees.3 sheets · 126 formulas · 13 KB
Time to Fill & Candidate Funnel TemplateTime to fill versus time to hire, and which stage is the bottleneck.3 sheets · 108 formulas · 13 KB
Retail 3
Basket & Transaction Analysis TemplateRevenue split into transactions, units per transaction and price.3 sheets · 308 formulas · 15 KB
Markdown Planner TemplateWhat each markdown step costs, and the one with the best net outcome.2 sheets · 65 formulas · 11 KB
Sell-Through & Open-to-Buy TemplateSell-through, weeks cover, and an open-to-buy that stops over-committing.4 sheets · 112 formulas · 12 KB
Or bring your own spreadsheet
Upload a file and DataHub Pro runs 50+ analyses on your own numbers, free and unlimited.
Analyse your own file free →