DOWNLOAD the Excel file for this video here: https://www.myonlinetraininghub.com/p...
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 addins or VBA/Macros. Just plain Excel. Applies to Excel 2010 onward for Windows & Excel 2016 onward for Mac.
LEARN MORE: view my comprehensive courses: https://www.myonlinetraininghub.com/
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: / myndatreacy
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: https://www.myonlinetraininghub.com/e...
⏲ 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