Microsoft Excel Dashboard & Report Design

Use Dashboards to communicate more info, more accurately and faster.  Learn to build and distribute Dashboard reports from the ground up.  Display impressive content that will provide insight, analysis and alerts.  You will gain the knowledge you need to transform your raw data into readable screen objects that are clean, clear and easily understandable.

Group Bookings Only:
Our offices – minimum of 6 delegates per group
On Site – Minimum of 8 delegates per group

Duration: 1 Day
Who should attend? This course is aimed at managers and other professionals who need to create dashboards and other reports in order to analyse, interpret and present information.
Course Prerequisite: Microsoft Excel Intermediate. No previous experience in PivotTables required.

Course Outline

Module 1
What is a Dashboard?

Module 2
First Steps towards Building a Dashboard

Module 3
Dashboard Design Tips

Module 4
Camera Tool

Module 5
Excel Table

Module 6
PivotTables

Module 7
Number Formatting

Module 8
Using Symbols in Dashboards

Module 9
Conditional Formatting

Module 10
Sparklines

Module 11
Charts

  • Comprehensive Manual
  • Lunch & Refreshments (not applicable to on-site training)
  • Electronic Certificate (on successful completion of the course)
  • Electronic Trainer Feedback Report
  • Electronic Delegate Feedback Questionnaire

Download Information

Click on the button to download

Course Schedule

View the available course dates

Contact Us

Contact Us now to find out more…