🔻 DOWNLOAD the Excel file for this video here: [ Ссылка ]

In this video you will learn how to create an interactive Excel budget vs actuals 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.

🎓 LEARN MORE: view my comprehensive courses: [ Ссылка ]

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

💬 Please leave me a COMMENT. I read them all!

🧟‍♀️ CONNECT with Mynda on LinkedIn: [ Ссылка ]

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

💬 EXCEL QUESTIONS: Get help on our Excel Forum: [ Ссылка ]

⏲ TIMESTAMPS
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

свернуть