8 Excel Dashboard Templates You Can Steal in 2026 — With Layouts & Formulas
Home› 8 Excel Dashboard Templates 2026
📊 Top List · Dashboard Templates

8 Excel dashboard templates you can steal in 2026

Every serious analyst eventually builds the same 8 dashboards. Sales performance for the sales team. Financial KPIs for the CFO. HR analytics for the people team. Instead of reinventing each one from scratch, this is the reference library of proven dashboard layouts — with the KPIs each tracks, the charts each uses, and the Excel formulas that power each one. Steal these designs, adapt to your data, ship in an hour.

📊 How to read each dashboard entry

Every dashboard on this list includes: audience (who it's for), build time (realistic to ship), layout blueprint (visual grid showing where sections go), KPIs it tracks (the 4-6 headline numbers), the formulas needed, and a Steal This shortcut with the fastest build path. Bookmark this page as your dashboard reference library.

The 3 rules of a good dashboard

Before we get into the specific dashboards, three universal rules that separate professional dashboards from cluttered noise:

One screen, one message. If your dashboard requires scrolling, it's not a dashboard — it's a report. A dashboard fits on one screen (roughly 1400×900 pixels) and answers one primary question. If you have two questions, build two dashboards.

4-8 KPIs maximum. Human working memory can hold 4-7 items at once. Dashboards with 20 metrics fail because users can't process them. The discipline is to cut, cut, cut until only the essential remains.

Automatic updates. Every formula on the dashboard should reference source data via structured references or dynamic arrays. Adding new rows to source data should update every KPI, chart, and table without manual intervention. Manual dashboards die within weeks.


1
For Sales Teams Intermediate 45-60 min
The Classic Sales Dashboard

Sales Performance Dashboard

The most-built dashboard in the world. Tracks revenue against targets, breaks down by region/product/rep, and surfaces the top performers and biggest deals. Every sales team needs one. Every sales leader looks at it multiple times per day.

Suggested Layout
Revenue MTD
Target % Attain
Deals Won
Pipeline $
Monthly Revenue Trend (Line Chart, 12mo)
Revenue by Region (Column)
Top 10 Sales Reps Leaderboard Table
Revenue MTD
Target Attainment %
New Deals Won
Pipeline Value
Avg Deal Size
Sales Cycle Days

The formulas that power it: SUMIFS for revenue by any criteria combination, COUNTIFS for deal counts, SORT + FILTER for the leaderboard, and simple arithmetic for attainment percentages.

=SUMIFS(Revenue, Date, ">="&EOMONTH(TODAY(),-1)+1, Date, "<="&TODAY())
Steal this template: Convert your CRM export to a Table (Ctrl+T). Add 4 SUMIFS formulas at the top for KPIs. Insert a line chart for the trend + column chart for regional breakdown. Use SORT(FILTER(...)) for the leaderboard. Ship in 45 minutes.
2
For CFOs & Finance Advanced 2-4 hours
The Executive Finance View

Financial KPI Dashboard

The dashboard the CFO or founder checks every morning. Revenue, gross margin, operating expenses, and cash flow at a glance. Usually includes month-over-month and year-over-year comparisons plus variance-to-budget metrics.

Suggested Layout
Revenue vs Budget
Gross Margin %
OpEx vs Plan
Cash Runway
Revenue Trend (YoY Overlay)
Cash Flow Waterfall
P&L Summary by Line Item (Actual vs Budget)
Revenue vs Budget
Gross Margin %
Operating Margin %
Cash Runway (months)
Burn Rate
Days Sales Outstanding

The trickier calculations here are variance-to-budget and the P&L structure. Use IFS for tier-based classifications and structured references throughout so the model survives structural changes.

=IFS(ABS(Variance/Budget)>=0.1,"🔴 Off Track", ABS(Variance/Budget)>=0.05,"🟡 Watch", TRUE,"🟢 On Track")
Steal this template: Start with the P&L summary table (actual vs budget by line item). Build KPI cards from row-level totals. Add YoY revenue chart using SUMIFS with prior-year date ranges. Cash runway = current cash / average monthly burn.
3
For People Ops & HR Intermediate 1-2 hours
The People Metrics View

HR Analytics Dashboard

Headcount, turnover, hiring pipeline, and compensation distribution — the dashboard HR leaders bring to every leadership meeting. Often segmented by department, tenure band, or level.

Suggested Layout
Total Headcount
Annual Turnover %
Open Reqs
Avg Tenure (yrs)
Headcount by Department (Bar)
Turnover Trend (12mo Line)
Open Roles Pipeline (Requisition Status Table)
Total Headcount
Annual Turnover %
New Hires (MTD)
Open Requisitions
Avg Tenure
Diversity Metrics

The turnover calculation requires understanding DATEDIF for tenure. Use UNIQUE to build the department dropdown automatically as new departments appear.

=COUNTIFS(EndDate,">="&A2,EndDate,"<="&EOMONTH(A2,0))/COUNTIFS(StartDate,"<="&A2)
Steal this template: Employee master data as a Table with Start Date, End Date (blank if active), Department, Level. Headcount = COUNTIFS active employees. Turnover = departures / average headcount. Chart trend using SUMPRODUCT to count active headcount at each month-end.
4
For Marketing Teams Intermediate 1-2 hours
The Full-Funnel View

Marketing Campaign Dashboard

Traffic sources, conversion rates, cost per acquisition, and ROI by channel — the dashboard that answers "where should we spend more?" Every marketing leader lives in this dashboard.

Suggested Layout
Total Traffic
Conversion %
Cost per Lead
Campaign ROI
Funnel Chart (Awareness → Purchase)
Channel ROI Comparison (Bar)
Campaign Performance Detail (Ranked by ROI)
Total Visitors
Conversion Rate %
Cost per Lead
Cost per Acquisition
Campaign ROI
Lifetime Value

ROI calculation requires clean cost data per campaign paired with attributed revenue. Use XLOOKUP to join campaign costs to campaign conversions from separate data sources.

=IFERROR((Revenue - Cost) / Cost, "No cost data")
Steal this template: Two source Tables — Campaign_Costs (name, channel, spend) and Campaign_Conversions (name, revenue, leads). Use XLOOKUP to combine. KPI cards for total spend, total revenue, blended CAC. Sort the detail table by ROI descending.
5
For PMs & Team Leads Intermediate 1-2 hours
The Delivery Tracker

Project Management Dashboard

Task status distribution, timeline vs plan, budget burn, and risk indicators — everything a PM needs to run a weekly project review. Also known as the "why are we behind" dashboard.

Suggested Layout
Tasks Complete
On Schedule %
Budget Burn
Risks Open
Status Breakdown (Doughnut)
Actual vs Planned Progress (Line)
Overdue Tasks Table (with Owner & Due Date)
Tasks Complete
% On Schedule
Budget Spent
Budget Remaining
Open Risks
Days to Deadline

Use FILTER to extract overdue tasks: =FILTER(Tasks, (Status<>"Done") * (DueDate<TODAY())). Combined with SORT, it produces an auto-updating "overdue" table.

=SORT(FILTER(TaskTable, (Status<>"Done") * (DueDate<TODAY()), "No overdue tasks"), 3)
Steal this template: Tasks Table with Status, Due Date, Owner, Estimated Hours, Actual Hours. KPIs from COUNTIFS. Overdue table from FILTER. Add a doughnut chart for status distribution and a line chart tracking cumulative "% complete" over time vs planned line.
6
For Operations Teams Advanced 2-3 hours
The Stock Health View

Inventory Management Dashboard

Current stock levels, reorder alerts, inventory turnover, and aging analysis. Operations dashboard for anyone managing physical inventory — retail, warehouses, restaurants, manufacturing.

Suggested Layout
Total SKUs
Below Reorder
Turnover Rate
Aging Stock $
Stock Value by Category (Column)
Aging Analysis (Stacked Bar)
Reorder Alerts Table (SKUs Below Threshold)
Total SKU Count
Items Below Reorder
Inventory Turnover
Aging Stock Value
Stockout Count
Days of Supply

The reorder alerts use FILTER to auto-surface at-risk SKUs. Turnover rate = COGS / Average Inventory. Aging analysis buckets stock into 0-30, 31-60, 61-90, and 90+ days using IFS.

=FILTER(Inventory, CurrentStock <= ReorderPoint, "All SKUs healthy")
Steal this template: Inventory Table with SKU, Category, Current Stock, Reorder Point, Cost per Unit, Last Movement Date. Reorder alerts from FILTER where CurrentStock ≤ ReorderPoint. Aging bucket using IFS on days since last movement.
7
For CS & Account Teams Intermediate 1-2 hours
The Retention Health View

Customer Success Dashboard

NPS scores, churn rate, MRR trends, and at-risk accounts — the dashboard SaaS customer success teams live in. Retention is more valuable than acquisition, and this dashboard tracks retention health.

Suggested Layout
MRR Total
Monthly Churn %
NPS Score
Net Retention
MRR Trend (Line with Expansion)
Health Score Distribution (Column)
At-Risk Accounts Table (Score < Threshold)
MRR Total
Monthly Churn %
Net Revenue Retention
Average NPS
At-Risk Accounts
Expansion MRR

Health score calculation combines multiple signals (usage, support tickets, contract length remaining) into a single 0-100 number using weighted averages or IFS for tier assignment.

=IFS(HealthScore>=80,"🟢 Healthy", HealthScore>=60,"🟡 Watch", HealthScore>=40,"🟠 At Risk", TRUE,"🔴 Critical")
Steal this template: Accounts Table with MRR, Contract Start/End, Last Login Date, Support Ticket Count, NPS Score. Compute Health Score as a weighted average. FILTER for at-risk. Chart MRR trend by summing all active accounts each month using SUMIFS.
8
For Personal Use Beginner 30-45 min
The Money Awareness View

Personal Finance Dashboard

Income and expenses tracked monthly, savings rate over time, budget vs actual by category, and net worth trend. The dashboard that turns financial anxiety into financial control. Every professional benefits from having one.

Suggested Layout
Net Worth
Savings Rate %
MTD Spending
Budget Remaining
Spending by Category (Pie or Bar)
Net Worth Trend (12mo Line)
Recent Transactions (Sorted by Date Desc)
Net Worth
Monthly Savings Rate
Total MTD Spending
Budget Remaining
Monthly Income
Emergency Fund Months

The simplest dashboard on this list — but arguably the most valuable personally. Just needs a transactions Table with Date, Category, Amount and a budget Table with Category, MonthlyBudget. SUMIFS handles everything.

=Budget - SUMIFS(Transactions[Amount], Transactions[Category], Category, Transactions[Date], ">="&EOMONTH(TODAY(),-1)+1)
Steal this template: One Transactions Table (Date, Category, Amount, Notes). One Budget Table (Category, MonthlyBudget). KPIs from SUMIFS totals. Chart spending by category with a pie or bar. Update transactions weekly and the entire dashboard rebuilds automatically.

KPI cards Charts Data tables Filters/slicers

The building blocks — what every dashboard needs

Across all 8 dashboards, the same handful of formulas and features do most of the work. Master these building blocks and you can build any dashboard on this list — plus dozens you'll design yourself.

Building blockWhat it doesUsed in
SUMIFSTotal values matching criteriaEvery dashboard's KPI cards
COUNTIFSCount rows matching criteriaVolume metrics, funnel counts
FILTERExtract rows matching criteriaAlert tables, at-risk lists
SORTOrder results by any columnLeaderboards, ranked tables
XLOOKUPJoin data across sourcesCost + revenue combinations, campaign attribution
IFSMulti-tier classificationsHealth scores, status indicators, budget alerts
Excel Tables (Ctrl+T)Structured references, auto-expansionEvery dashboard's source data
SlicersInteractive filteringAny dashboard that needs "slice by X"
SparklinesInline mini-trendsAnywhere a table needs trend indicators

The 5-step dashboard build process

Regardless of which dashboard you're building, the process is the same:

Step 1 — Define the one question. Every dashboard answers one primary question ("How is sales performing this quarter?"). Write it at the top. Every KPI, chart, and table must serve that question. If something doesn't serve it, cut it.

Step 2 — List the KPIs. What are the 4-6 numbers that answer the question? These become your top KPI cards. Common pattern: 1 volume metric, 1 quality metric, 1 trend metric, 1 target/variance metric.

Step 3 — Prepare the source data as Tables. Convert every source range to an Excel Table (Ctrl+T). This is the #1 dashboard resilience upgrade — tables auto-expand and use structured references.

Step 4 — Build the calculations. KPI formulas first, then chart data ranges, then supporting tables. Use SUMIFS, COUNTIFS, FILTER, and XLOOKUP as building blocks. Reference cells for filter criteria (so users can change them).

Step 5 — Design the layout. KPIs at top. Main chart in the middle. Supporting charts and tables below. Consistent formatting throughout. Use conditional formatting for at-a-glance status indicators.

The "hallway test" for dashboards

Print your dashboard and pin it in a hallway. Ask a colleague who's never seen it: "What's the main story?" If they can't tell you the primary takeaway in 30 seconds, the dashboard is failing at its job. Simplify until they can. The best dashboards communicate their key insight almost instantly.

Common dashboard mistakes to avoid

Too many KPIs. The most common mistake. Users can't process 20 numbers at once. Cut to 6-8 maximum, even if it feels like you're leaving important things out. The full detail belongs in supporting reports, not the dashboard.

Chart types that require legends. Pie charts with 8 slices, stacked bar charts with 12 series, line charts with 15 lines. If understanding your chart requires memorizing a legend, use a different chart type or split into multiple charts.

Hardcoded data ranges. Formulas that reference A2:A1000 break when data hits row 1001 or shrinks to row 200. Always use structured references (Excel Tables) or dynamic array output ranges.

No target or comparison. A KPI of "Revenue: $145,000" is meaningless without context. Add "vs $150,000 target (-3%)" or "up 12% YoY". Every metric needs a benchmark.

Manual refresh workflow. If someone has to click "Refresh Data" or copy-paste new numbers weekly, the dashboard will die. Every calculation should update automatically from source data. If it doesn't, the design is wrong.

Related resources

Frequently asked questions

How long does it take to build an Excel dashboard?

A basic KPI dashboard with 4-6 metrics and 2-3 charts takes 30-60 minutes if you have your data prepared and use modern functions like FILTER, SUMIFS, and dynamic arrays. A comprehensive dashboard with slicers, interactive filtering, and multiple views typically takes 3-8 hours to build well. Once built, dashboards should update automatically as source data changes.

What makes a good Excel dashboard?

A good Excel dashboard shows the most important information on one screen without scrolling, updates automatically from source data, uses consistent visual style, has 4-8 KPIs (not 20), uses appropriate chart types for each metric type, includes context like targets or period comparisons, and answers a specific question for a specific audience. Cluttered dashboards with too many metrics fail because users cannot process them.

What Excel functions are essential for building dashboards?

The essential dashboard functions are XLOOKUP for lookups, SUMIFS and COUNTIFS for conditional aggregation, FILTER for extracting matching data, UNIQUE for building dropdown lists, IFS for tier logic, and TEXTJOIN for building dynamic report headers. Excel Tables (Ctrl+T) are essential for data ranges that grow, and named ranges keep formulas readable. Slicers add interactive filtering to PivotTables.

Should I use PivotTables or formulas for dashboards?

It depends on the audience and update frequency. PivotTables are faster to build initially and better for exploratory analysis. Formula-based dashboards give more control over layout, formatting, and calculations but take longer to build. For dashboards that need pixel-perfect formatting or non-standard calculations, formulas win. For quick views over well-structured data, PivotTables win. Many production dashboards combine both. See PivotTables vs Formulas for the full decision framework.

Can I make Excel dashboards interactive?

Yes, using several Excel features. Slicers add clickable filter buttons that update PivotTables and charts. Data validation dropdowns let users pick values that feed into FILTER or XLOOKUP formulas. Form controls like buttons and dropdowns can trigger changes. Combined, these turn a static report into an interactive tool where users pick criteria and the entire dashboard updates instantly.

What chart types work best in dashboards?

The most useful dashboard chart types are line charts for trends over time, column charts for comparing categories, bar charts for ranked lists, sparklines for inline trends within tables, gauge charts (built from doughnuts) for progress against targets, and heat maps (via conditional formatting) for density visualization. Avoid pie charts with more than 4 slices, 3D charts, and any chart type that requires legend interpretation to understand.

How do I make my Excel dashboard update automatically?

Convert your source data to Excel Tables (Ctrl+T) which auto-expand as rows are added. Use structured references in formulas instead of hardcoded ranges. Build charts based on the Table references or dynamic array formulas — these expand automatically. Use FILTER and UNIQUE to create output ranges that resize with source data. If pulling from external sources, use Power Query with scheduled refresh.

What's the difference between a dashboard and a report?

A dashboard fits on one screen, shows the most important metrics at a glance, and is designed to be viewed regularly for quick status checks. A report is longer, more detailed, may span multiple pages, and is designed for periodic in-depth analysis. Dashboards answer "how are things right now?" Reports answer "what happened and why?" You need both — but confusing them by making a dashboard too long or a report too shallow serves nobody.

Can I share Excel dashboards with people who don't have Excel?

Several options. Export the dashboard as PDF for read-only distribution. Save as an image (right-click chart → Save as Picture) for embedding in emails or slides. Upload to OneDrive or SharePoint and share with view-only links — recipients can view in browser without Excel. For truly interactive sharing without Excel, consider rebuilding in Power BI or Google Sheets which have web-native sharing.

· · ·

Bottom line: Great dashboards aren't invented — they follow proven patterns. These 8 templates cover 90% of what analysts build. Steal the layouts, adapt to your data, ship your dashboard in an afternoon.