🔻 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
![](https://s2.save4k.ru/pic/_PlBRWc0RlI/maxresdefault.jpg)