UEN No.: 198802365N

01 day – Data Visualisation with Excel Dashboards

COURSE synopsis

Course Details

Course Duration

8 HRS

Course Reference Number

TGS-2017501009

Funding Validity Period

04 Jul 2019 To
31 Dec 2023

Mode of Training

Classroom

Course Objectives

This course aims to equip learners with the necessary skills and knowledge to create insightful and impressive management reports using the various tools in Microsoft Excel.

Target Audience

This course is aimed at participants who have attended the basic Microsoft Excel course or have some working knowledge of Microsoft Excel.

Course Outline

Dashboard Fundamentals
  • What is a dashboard
  • Key characteristics of a dashboard
Planning Considerations
  • Define information needs
  • Acquire and arrange data
Dashboard Design Consideration
  • Dashboard Dos and Don’ts
  • Selecting appropriate tools
  • Determine chart elements and colour selection
  • Histogram
Reporting With PivotTable And PivotChart
  • Insert and populate a PivotTable and PivotChart
  • Update PivotTable data
  • Using Slicer
Advanced Excel Tools
  • Conditional formatting
  • Using Range Names
  • Create Drop-down list with data validation
Obtain Data With Excel Functions
  • Use Lookup and Reference functions
  • Use INDEX and MATCH functions
  • Database functions
Create Excel Chart
  • Create standard charts
  • Combination chart
  • Sparkline
Customising Chart Elements
  • Format axis
  • Display/format Data Labels
Advanced Chart Types
  • Pareto chart
  • Box & whisker chart
  • Gauge or Speedometer chart
Course Outline

Download the PDF below for a summary of the course outline.

COURSE FEES

Company Sponsored

Full Fee GST Broad-based Funding
($2 per training hour)
Nett Fee Payable (incl. GST)
$320 $25.60 $16 $329.60

Self-Sponsored

Full Fee GST Nett Fee Payable (incl. GST)
$320 $25.60 $345.60

REGISTER TODAY

Looking at in-house training or have an enquiry? Contact us!

Related Courses

IT

24 HRS

WSQ

IT

16 HRS

WSQ

IT

16 HRS

WSQ

GET IN TOUCH WITH US

Have an enquiry? Feel free to connect via any of the channels below.

enquiry form

Leave a message

WhatSAPP

Chat on WhatsApp at
+65 8767 0614

Training hotline

Give us a call at
+65 6737 5761

SHARE THIS COURSE