How to build Interactive Excel Dashboards that Update with ONE CLICK!

Download file used in the video with step by step instructions and links to more tutorials: s

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 2007 onward for Windows & Excel 2016 onward for Mac.

Chapters:
0: 00 Introduction, what to expect and keys to building dashboards fast – don’t skip this if it’s your first time watching 😉
4: 45 The Data
5: 07 Building the PivotTables & Charts
28: 00 Inserting Slicers
29: 50 Manual Legend
33: 54 Dynamic Labels
39: 11 Link Slicers to Charts
42: 26 Adding New Data
44: 43 Color Formatting with Themes
45: 45 Formatting Objects
48: 16 Make it look less like Excel
49: 26 Worksheet Protection
50: 47 What’s Next

View my comprehensive courses: /

Connect with me on LinkedIn: /

You May Also Like