Course Description

Synopsis:

This course provides an introduction to dashboards in Excel and will equip you with techniques on creating your own Excel dashboard.

In the following lessons, you will find out more about basic functions and techniques that you can use in your day-to-day work and how to create strong visualisations of the datasets you use. You will also get a glimpse into setting up basic dashboards before learning how to incorporate those techniques in creating your own dashboard.

Topics covered in this course include:

Introduction to Dashboards

• What are Dashboards?
• Uses of Dashboards
• Skills Needed to Create Dashboards
• Tips to Create Dashboards
• Live Examples of Dashboards

Formulas and Techniques

• Simple cell linking
• VLOOKUP
• HLOOKUP
• Hyperlinks
• SUMIFS
• COUNTA

Advanced Formatting of Charts

• Visual elements of Dashboards
• Presenting Data
• Graph, Charts and Visual Instructions
• Customisation

Dashboard Designing Examples

• Developing a Dashboard
• Using Pivot Tables

Intended For:

• Audit Professionals/ PAIP
• Finance Professionals/ PAIB
• Public Sector Finance
• C-suite & Directors

Competency Mapping: 

• CPE Category 5 = 1.0 CPE Hour