Excel Dashboard Masterclass -From Zero to Hero
- Description
- Curriculum
- FAQ
- Reviews
This course is for all Excel users who wish to learn how to create powerful interactive dashboards right from the Basics to putting everything together. This course will teach you to turn your Excel data into powerful tables, graphs, visuals and dashboards.
Highlights:
• Learn from Practical Video tutorials and ample of downloadable resources.
• Understand the goals of data visualization and dashboard building.
• Learn the basics of conditional formatting and the key aspects of it for dashboard building.
• Review the Excel logic functions like IF, AND, OR and using them in your dashboards,
• Start by building bar charts, column charts, pie charts and line charts to display your data.
• Learn more complex charts like scatter plots, combination charts for data visualization and decision making.
• Make your dashboards more interactive with the MATCH () and INDEX () functions.
• Leverage pivot tables within your dashboard to add even more interactivity.
• All in all learn the art of dashboard creation right from scratch to show off your large cumbersome data in a more meaningful form.
So What are you waiting for ? Jump right into the course and Take your Excel Skills to a whole new level.
-
3Conditional Formatting - Highlighting CellsVideo lesson
-
4Conditional Formatting - Data BarsVideo lesson
-
5Conditional Formatting - Icon SetsVideo lesson
-
6Conditional Formatting - Colour ScalesVideo lesson
-
7Using Logical FunctionsVideo lesson
-
8Conditional Formatting Using Logical FunctionsVideo lesson
-
9Bar and Column ChartVideo lesson
-
10Line and MarkersVideo lesson
-
11Pie ChartsVideo lesson
-
12Area ChartVideo lesson
-
13Sunburst and Tree Map Charts (MS Excel 2016)Video lesson
-
14Combo ChartsVideo lesson
-
15ScatterplotsVideo lesson
-
16SparklinesVideo lesson
-
17Bullet ChartsVideo lesson
-
18Waterfall Charts (MS Excel 2016)Video lesson
External Links May Contain Affiliate Links read more