Course Description

This course is designed with a practical, easy-to-learn approach towards unleashing the power of Microsoft
Excel to build interactive management dashboard reports. It aims to equip participants with adequate knowledge and skills to understand how to create dashboards that facilitate the reporting of key performance indicators (KPI).
It allows managers to step back from the details and see the key trends and relationships that drive the organisation.

Course Objective

At the end of this course, you should be able to:

Enhance your work environment and generate new ideas

Design a dashboard for high level overview of the business.

Clarify the roles and responsibilities of your supervisory role and adjust to the new role with confidence

Use Excel’s data visualization features for KPI reporting.

Learn how to listen effectively so that you can understand and manage others

Create a functionally interactive dashboard.

Enhance your work environment and generate new ideas

Design a dashboard for high level overview of the business.

Clarify the roles and responsibilities of your supervisory role and adjust to the new role with confidence

Use Excel’s data visualization features for KPI reporting.

Learn how to listen effectively so that you can understand and manage others

Create a functionally interactive dashboard.

Course Outline

You will be learning the following:

  • Defining a Dashboard
  • Understanding Dashboard Design Principles
  • Designing a Dashboard 
  • Organizing Data
  • Performing Calculations
  • Creating Range Names 
  • Using Conditional Formatting
  • Creating Sparklines 
  • Creating Pivot Tables
  • Inserting Slicers
  • Creating Pivot Charts
  • Using Advanced Charting Techniques
  • Working with Worksheet Form Controls
  • Creating Dynamic Dashboards
  • Creating Automatic Commentaries 
  • Protecting a Dashboard
  • Exporting a Dashboard

Course Fees And Grants

$280 ($302.40 Inc. 8% GST) per participant
SDF grant entitled, $2/hr x 7hrs = $14
Only applicable to Singaporean and PR employees
Skillsfuture Credit Claimable for Individual
UTAP Claimable ; sign up https://ntuc.co/ask-edm

Absentees will be charged the full course fee.

Course Schedule

Registration

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

Our Corporate Partners

What Our Students Say

COURSE FEES AND GRANTS

$280 ($302.40 Inc. 8% GST) per participant
SDF grant entitled, $2/hr x 7hrs = $14
Only applicable to Singaporean and PR employees
Skillsfuture Credit Claimable for Individual
UTAP Claimable ; sign up https://ntuc.co/ask-edm

Absentees will be charged the full course fee.

REGISTRATION

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

ASK Training