Myvideo

Guest

Login

Excel Dashboard - Plan vs Actual Variances - FREE Download

Uploaded By: Myvideo
1 view
0
0 votes
0

Download the Excel file for this video here: 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 2010 onward for Windows & Excel 2016 onward for Mac. Chapters: 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 View my comprehensive courses: Connect with me on LinkedIn:

Share with your friends

Link:

Embed:

Video Size:

Custom size:

x

Add to Playlist:

Favorites
My Playlist
Watch Later