Title | : | How to build Interactive Excel Dashboards |
Duration | : | 52:26 |
Viewed | : | 5,635,108 |
Published | : | 18-12-2017 |
Source | : | Youtube |
Download file used in the video with step by step instructions and links to more tutorials:
https://www.myonlinetraininghub.com/w...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:
https://www.myonlinetraininghub.com/Connect with me on LinkedIn:
https://www.linkedin.com/in/myndatreacy/
SHARE TO YOUR FRIENDS
Scan me