Infinite Skills - Microsoft Excel - Creating Dynamic Dashboards

1. 01. Course Introduction/01_01-About This Series.mp48.93MB
2. 01. Course Introduction/01_02-What You Will Learn.mp45.54MB
3. 01. Course Introduction/01_03-About The Author.mp45.43MB
4. 01. Course Introduction/01_04-How To Access Your Working Files.mp413.16MB
5. 02. Deciding On Dashboards/02_02-Reports, Dashboards And Scorecards.mp49.28MB
6. 02. Deciding On Dashboards/02_03-Pondering The Plan.mp43.24MB
7. 02. Deciding On Dashboards/02_04-Selecting Measures And Metrics.mp49.15MB
8. 03. Preparing The Data/03_01-Preparing The Data.mp44.11MB
9. 03. Preparing The Data/03_02-Data Modeling Basics.mp47.38MB
10. 03. Preparing The Data/03_03-Structuring The Workbook.mp47.94MB
11. 03. Preparing The Data/03_04-Connecting To Data Part 1.mp45.05MB
12. 03. Preparing The Data/03_05-Connecting To Data Part 2.mp419.83MB
13. 03. Preparing The Data/03_06-Simplifying Data With Named Ranges.mp412MB
14. 03. Preparing The Data/03_07-Leveraging The Efficiency Of Tables.mp419.12MB
15. 03. Preparing The Data/03_08-Harnessing The Power Of Pivot Tables.mp419.28MB
16. 03. Preparing The Data/03_09-Managing Connected Data.mp411.31MB
17. 03. Preparing The Data/03_10-Simplifying With Custom Number Formats.mp417.29MB
18. 04. Building Dashboards/04_01-Building Dashboards.mp44.16MB
19. 04. Building Dashboards/04_02-Dashboard Design Rules.mp46.23MB
20. 04. Building Dashboards/04_03-Managing Branding With Custom Themes.mp415.37MB
21. 04. Building Dashboards/04_04-Creating The Navigation Bar Part 1.mp410.74MB
22. 04. Building Dashboards/04_05-Creating The Navigation Bar Part 2.mp411.55MB
23. 04. Building Dashboards/04_06-Creating The Navigation Bar Part 3.mp49.14MB
24. 04. Building Dashboards/04_07-What Is In A Word.mp410.21MB
25. 04. Building Dashboards/04_08-Building Out Worksheets And Navigation.mp42.43MB
26. 04. Building Dashboards/04_09-Summarizing Data Using Groups.mp44.43MB
27. 04. Building Dashboards/04_10-Configuring Show Values As For Pivot Tables.mp410.96MB
28. 04. Building Dashboards/04_11-Assigning Categories Using Nested If.mp48.14MB
29. 04. Building Dashboards/04_12-Identifying Top Ten Values.mp46.55MB
30. 04. Building Dashboards/04_13-Finding The Last Value In A Series.mp49.89MB
31. 05. Getting Visual/05_01-Getting Visual.mp46.12MB
32. 05. Getting Visual/05_02-Customizing Display With TextBased Elements.mp410.03MB
33. 05. Getting Visual/05_03-Alerting With Conditional Formatting.mp410.66MB
34. 05. Getting Visual/05_04-Chart And Sparkline Review.mp412.7MB
35. 05. Getting Visual/05_05-Creating Sparklines For Dashboards.mp47.89MB
36. 05. Getting Visual/05_06-Creating Charts For Dashboards.mp419.84MB
37. 05. Getting Visual/05_07-Using A Waffle Chart To Show Progress.mp415.65MB
38. 05. Getting Visual/05_08-Using The Excel Camera.mp49.35MB
39. 05. Getting Visual/05_09-Creating A Distribution Histogram.mp416.19MB
40. 05. Getting Visual/05_10-Hitting The Mark With Bullet Graphs.mp46.73MB
41. 06. Adding Interactivity/06_01-Adding Interactivity.mp44.52MB
42. 06. Adding Interactivity/06_02-Displaying The Developer Tab.mp43.74MB
43. 06. Adding Interactivity/06_03-Understanding Interactive Dashboard Controls.mp411.5MB
44. 06. Adding Interactivity/06_04-Adding Actions To Buttons.mp418.13MB
45. 06. Adding Interactivity/06_05-Creating Custom Content With Combo Boxes.mp414.52MB
46. 06. Adding Interactivity/06_06-Simplifying With Check Boxes.mp49.41MB
47. 06. Adding Interactivity/06_07-Facilitating Filtering With Slicers And Timelines.mp418.86MB
48. 06. Adding Interactivity/06_08-Finalizing By ColorCoding, Hiding And Protecting Worksheets.mp410.08MB
49. 07. Generating Dashboards As Output/07_01-Generating Dashboards As Output.mp42.99MB
50. 07. Generating Dashboards As Output/07_02-Producing Dashboards As PDF.mp48.08MB
51. 07. Generating Dashboards As Output/07_03-Presenting Dashboards With Powerpoint.mp44.59MB
52. 07. Generating Dashboards As Output/07_04-Sharing Dashboards Via OneDrive.mp48.32MB
53. 08. Conclusion/08_01-What You Now Know.mp48.33MB