HR training course
MS Excel Data Visualization & Analytics Using Dashboards
Build a working business dashboard in Excel: one page that tracks the metrics leaders actually decide on, backed by real data rather than a static report.
Upcoming sessions
Pick a date and register
What you will learn
Skills you will walk away with
- Work confidently in the dashboard environment
- Build a dashboard from raw data
- Choose the right chart type for the question being asked
- Insert charts, pivot tables and pivot charts into a dashboard
- Sort and filter pivot tables so the view stays current
About this course
What this course covers
An Excel dashboard is a single page that helps managers and business leaders track the KPIs and metrics they make decisions on. It holds charts, tables and views backed by raw data. In this course learners build a business dashboard to visualise and analyse sets of data, so core metrics are available on demand rather than rebuilt each month.
Prerequisites: you should have completed Excel Level 1 and Level 2, or have more than six months of regular Excel use. Taught in the Windows environment.
Who should attend
Who this course is for
- Managers and analysts who report on metrics regularly
- HR and finance professionals building recurring reports
- Anyone rebuilding the same report by hand every month
Good to know
Course questions
Excel Level 1 and Level 2, or more than six months using Excel regularly.
The course is taught in the Windows operating system environment.
Yes. You build a working dashboard during the session.
Register for this course today
Live online, open to your whole team. Or bring it in-house with private delivery.