How to build Interactive Excel Dashboards
Download file used in the video with step by step instructions and links to more tutorials: https://www.myonlinetraininghub.com/workbook-downloads
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/
Видео How to build Interactive Excel Dashboards канала MyOnlineTrainingHub
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/
Видео How to build Interactive Excel Dashboards канала MyOnlineTrainingHub
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel 2016 AdvancedIntroduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)Speak like a Manager: Verbs 1Secrets to Building Excel Dashboards in Under 15 Minutes!MS Excel - Import Live Data From Web to ExcelHow to Create Impressive Interactive Excel Dashboard | Ultimate Excel Dashboard Ep. 1Top 25 Excel 2016 Tips and TricksSearchable Drop Down List in Excel (Very Easy with FILTER Function)50 Ultimate Excel Tips and Tricks for 2020How to Create a Data Entry Form in Excel With Add, Modify, Delete and Reset (Step-by-step Guide)Pivot Table with Progress Chart and DashboardLearn Macros in 7 Minutes (Microsoft Excel)Excel Dashboard - Plan vs Actual Variances - FREE DownloadVLOOKUP Tutorial for Excel - Everything You Need To KnowHow to easily automate boring Excel tasks with Power Query!Interactive Excel Project Management Dashboard - FREE DownloadTop 10 Most Important Excel Formulas - Made Easy!Top 15 Advanced Excel 2016 Tips and TricksExcel for Accounting: Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards