Microsoft Excel Dashboard & Report Design

Microsoft Excel Dashboard & Report Design

Overview and Objectives

  • 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.

Course Outline

This course consists of 11 modules
Module 1What is a Dashboard?
Module 2First Steps towards Building a Dashboard
Module 3Dashboard Design Tips
Module 4Camera Tool
Module 5Excel Table
Module 6PivotTables
Module 7Number Formatting
Module 8Using Symbols in Dashboards
Module 9Conditional Formatting
Module 10Sparklines
Module 11Charts

Excel Dashboard & Report Design

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.

Duration

1 day

Cost

R1 270,00 (excl. VAT)

Includes

  • 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 Course Information

Microsoft Excel: Dashboard & Report Design

Course Schedule

View the available course dates