Excel Dashboard Reports

Take Your Excel Skills To Next level and learn how to transform data to information that provides valuable insights.

Warning: Ensure you take my Advanced Excel course before subscribing for this course except you are an advanced Excel User

Why This Course?

It is not enough to learn how to solve problems with Microsoft Excel. The World is full of data and there is a high demand for individuals who can who can transform data into useful information that provide insights relevant for decision making.

This Course is the NEXT STEP that makes it easy for the Excel User to advance their learning experience further into BIG Data Analysis Programs such as Microsoft Power BI, etc.

Who Is This Course For?

Individuals who work with large amount of data and are required to prepare reports. They may include: Managers, accountant, HR Specialists, Production managers, marketing managers etc

General Contents

1. Overview of Dashboard Reports
2. Useful Excel Functions for Dashboard Reporting
3. Creating A Bar chart
4. Creating A Column chart
5. Creating A Line chart
6. Creating A Combo chart
7. Creating A Pie chart
8. Creating An Area chart
9. Creating A Scattered chart
10. Creating A Stock chart
11. Creating A Surface chart
12. Creating A Radar chart
13. Creating A Two-Axis Chart
14. Adding A Series To An Existing Chart
15. Handling Missing Data
16. Introduction To Chart Formatting
17. Formatting Chart Axes, Titles & Legends
18. Introduction To Pivot Table
19. Understanding Pivot Table Field List
20. Working Through The Pivot Table Contextual Tab
21. Working With Date Field
22. Grouping By Other Factors on A Pivot Table
23. Introduction To Slicers
24. Creating A Pivot Chart
25. Extracting Information From A Pivot Table/Pivot Chart
26. Starting With Excel Charts For Dashboard
27. Creating A Histogram From A Pivot Table
28. Charting A Survey Result From A Pivot Table
29. Creating Sparklines
30. Creating Dynamic Labels
31. Using Excel Camera Tool
32. Creating Formula Driven Labels
33. Using Fancy Fonts For Visualization
34. Introducing Macros For Dashboard
35. Creating Navigation Buttons With Macros
36. Changing Chart Types With Macros
37. Showing Trends On Our Dashboard
38. Grouping Data On Dashboard
39. Measuring Performance Against Target
40. Adding Interactive Controls – Checkbox, Combo box, List Box, Option Button 

Watch These Youtube Videos for sample tutorials

How To Create A Historgram From A Pivot Table

How To Chart A Survey Result From A Pivot Table

How To Use Fancy Fonts For Visualizations

How To Create A Dynamic Label In Excel

How To Use A Checkbox To Toggle (On/Off) A Chart Series