This 2 days Excel Dashboard class will train skills to a whole new level by learning how to build dynamic Excel dashboards to show off your data.
OBJECTIVE
• This course will teach you the data visualization skills you need to design any dashboard in Excel exactly the way you want.
• A comfort level of building if functions at a minimum, and knowledge of Pivot Tables is an asset, but not a requirement.
• Will have gained the practical skills you need to create beautiful, functional and interactive Excel dashboards.
COURSE METHODOLOGY
• Instructor led
• group-paced
• classroom-delivery learning model with structured hands-on activities.
COURSE CONTENT
1) What Is A Dashboard?
2) Pivottables And Pivotcharts
3) Useful Functions
4) Conditional Formatting
5) Form Controls
6) Working With Charts
7) Working With Sparkline
