Excel Dashboard - Plan vs Actual Variances - FREE Download

Download the Excel file for this video here: In this video you will learn how to create an interactive Excel dashboard from scratch using the built in Excel tools. No add-ins or VBA/Macros. Just plain Excel. Applies to Excel 2010 onward for Windows & Excel 2016 onward for Mac. Chapters: 0:00 Introduction, what to expect 0:54 The Data 2:26 Building the PivotTables & Charts 8:08 Using Symbols in Formulas 10:10 Conditional Formatting 11:53 Icons 12:47 Custom Slicer Format 25:00 Sparklines 27:27 Connecting Slicers to PivotTables 29:40 Formatting 33:08 Adding New Data 34:24 Keys to Automatic Updating View my comprehensive courses: Connect with me on LinkedIn: