Excel Dashboard
1 Day | Max 10 Participants
About This Course
“Dashboard” is the buzzword these days. Past, are the days of managers and clients, who want to see massive amounts of information to review the conclusion. Today a picture speaks a thousand words and the corporate sector has aimed for outputs in a visual format.
In this course, a learner will gain a strong understanding of manipulating MS Excel to develop chart and table dashboards for reporting purposes
Requirements
A good foundation in Excel would be required for this course. Each learner will have to have a computer with MS Excel.
The workshop will only run at a minimum of 5.
Duration
1 Day
Course Outline
-
Understanding of a Dashboard
-
Setting up the data
-
Basics of Pivot Tables
- Format as table tools
- Conditional Formats
- Using Sparklines
- Creating PivotTables
- Working with fields
- Grouping data
- Analysing different values
- Setting up different forms of PivotTables
- Creating PivotCharts
- Build that Dashboard
-
Using MS Excel to learn Advanced Pivoting to create the dashboard