MS Excel Data Visualization & Analytics Using Dashboards
- Live virtual
- Half day
- Instructor-led
Live virtual · Half day · Instructor-led
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
Your facilitator
Who teaches this course
Ken Worthy
Facilitator
See the full team of Catapult HR Advisors.
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.
Learners also liked
Courses learners usually take next
MS Excel Data Cleaning Essentials
Next: Oct 29 · 3 upcoming datesView dates & register →MS Excel Level 3
Next: Oct 27 · 9 upcoming datesView dates & register →Pulling Data using Excel VLOOKUPs and More
Next: Nov 10 · 2 upcoming datesView dates & register →Number Crunching with Excel Pivot Tables
Next: Dec 10 · 3 upcoming datesView dates & register →Register for this course today
Live online, open to your whole team. Or bring it in-house with private delivery.