On course for success

Introduction to MS Excel Dashboard

Programme Overview

Excel Dashboard is a page that allows managers and business leaders to track key KPIs or indicators and to decide appropriately.
It includes diagrams / tables / views supported by facts. Nevertheless, not all reports are dashboards. Dashboard reports provide administrators with a high-level company summary. Excel is an excellent tool for producing powerful dashboards which allow managers to evaluate, inspect and alert on time.

Programme Objectives

  • Understand the Dashboard and its specifications;
  • Use data and formatting to present data accurately so that the report easily understood;
  • Show the advanced formula to make the report interactive; and
  • Create sophisticated chart such as Speedometer chart & Thermometer Chart.

Pre-Requisite

  • Basic knowledge and functionality of Microsoft Excel
  • Participants are required to bring their own laptop with Ms Excel 2016 software installed.

Who Is This Programme For?

Any personnel that uses Microsoft Excel to analyse and prepare management reports, especially administrative, operational and middle management staff

Methodology

  • Lecture
  • Skill-practices
  • Face-to-face

Programme Outline

Content
Module 1: Introduction to Dashboard Module 5: Charts
Module 2: Dashboard Ingredients Module 6: Tables
Module 3: Building Dashboards from summarized data Module 7: Working with images
Module 4: Building Dashboards from raw data Module 8: Pivot Table & Pivot Charts

Programme Delivery

Date Time
21 – 22 August 2023

8:30 AM – 12:00 PM
1:30 PM – 5:00 PM

Your Investment

Package Stakeholder Non Stakeholder
Fee $550.00 $650.00

 

Download Brochure Here
▲ Top