Build an Excel Dashboard That Updates Itself — Free, Right in Your Browser (2026)

📥 FREE DOWNLOAD — the finished workbook from this video (the exact Maple & Ember dashboard, yours to pull apart): https://drive.google.com/file/d/1wOKu... This Excel dashboard updates itself. Click one slicer and every number and chart rebuilds around your choice. Paste in new sales and hit Refresh All, and the whole dashboard — KPIs, pivots, charts — recalculates itself. No macros. No paid software. No desktop app. Just the completely free Excel in your browser. We build it from a messy sales export most people would delete: duplicates, junk rows, inconsistent capitals, and an invisible trailing-space bug that splits products in two (caught live, on camera). This is Part 2 of the Dashboard Build series — Part 1 built the same dashboard in Google Sheets (link below). WHAT YOU BUILD • A cleaned, structured Excel Table (the engine of everything) • Four PivotTables in an "engine room": revenue by month, by product, by region, and order count • A KPI band powered by GETPIVOTDATA with IFERROR protection • Two PivotCharts recoloured to a real palette, with data labels • Month + Region slicers connected to every pivot at once • The payoff: paste 6 new sales, one Refresh All, watch $54,809 become $56,664 CHAPTERS 00:00 The dashboard that updates itself 00:23 The plan 00:58 Get the file into free Excel 01:36 Clean 1: Remove Duplicates 02:16 Clean 2: junk rows (TEST ROW, Carrier Pigeon) 02:49 Clean 3: west → West, freeze panes 03:31 Convert to a Table (the engine) 04:09 Helper columns: Revenue + Month 04:50 Pivot 1: monthly revenue 05:31 Pivot 2 + the invisible-space bug (TRIM fix) 06:21 Pivots 3 + 4: regions + order count 06:58 The KPI band (GETPIVOTDATA + IFERROR) 07:45 Charts, recoloured 08:25 The styling pass 09:01 Slicers + the #DIV/0! fix, live 09:55 Honesty break: what free Excel can't do 10:31 THE PAYOFF: new data + Refresh All 11:24 Recap + the system EVERY FORMULA IN THIS VIDEO Revenue (calculated column): =[@Units]*[@[Unit Price]] Month (calculated column): =TEXT([@Date],"YYYY-MM") Orders helper: =1 Trailing-space fix: =TRIM(C2) → copy → Paste Values over the Product column → Refresh Total Revenue KPI: =IFERROR(GETPIVOTDATA("Revenue",$A$34),0) Orders KPI: =IFERROR(GETPIVOTDATA("Sum of Orders",$G$42),0) Average Order Value KPI: =IFERROR(B5/D5,0) Best Month KPI: =INDEX(A35:A46,MATCH(MAX(B35:B46),B35:B46,0)) ($A$34 and $G$42 are the top-left cells of the monthly and order-count pivots in this workbook — use your own pivots' anchor cells.) HONEST NOTES (as shown in the video) • Everything was built in the free Excel for the web, in a free Microsoft account, with the file stored in free OneDrive (5 GB plan). No licence, no trial. • There are no macros in web Excel, at any price. • In this free web version, the Insert Timeline button sat on the ribbon but produced nothing for our pivot when clicked during filming. Slicers are the interactive tool that genuinely works here — which is why this dashboard is built on them. • The data is fictional (Maple & Ember, a coffee-goods shop). The mess is, sadly, realistic. PART 1 (GOOGLE SHEETS VERSION):    • Turn Ugly Data Into a Dashboard in Google ...   #Excel #Dashboard #PivotTable The follow-up dashboard build is on our sister channel, Sheets by OptiVal: 3 Upgrades That Make Any Excel Dashboard Feel Pro:    • 3 Upgrades That Make Any Excel Dashboard F...