Non-Certifiable

01 day – Data Visualisation with Excel Dashboards

course details

Duration and Time

Training Time

9am-6pm

Course Duration

8 HRS

Course Information

Course Reference Number

Funding Validity Period

Mode of Training

Classroom

COURSE OVERVIEW

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.

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

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

  • Learners must be able to read, write, speak and listen to English at secondary school level
  • Learner should have working knowledge of Microsoft Excel
Course Outline

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

COURSE FEES

Company Sponsored

Funding Type Full Fee 9% GST (on full course fee) Funding Amount Nett Fee Payable (incl. GST)
Small Medium Enterprises (SMEs) $320.00 $28.80 $224.00 (70% off course fee) $124.80
Non Small Medium Enterprises $320.00 $28.80 $160.00 (50% off course fee) $188.80
Singaporean Employees aged 40 years and above $320.00 $28.80 $224.00 (70% off course fee) $124.80

Course Fee Funding:
SME: 70% of course fee
Non-SME: 50% of course fee
Non-SME(MCES): 70% of course fee

$4.50 per training hour capped at $100,000 per enterprise per calendar year

Self-Sponsored

Funding Type Full Fee 9% GST (on full course fee) Funding Amount Nett Fee Payable (incl. GST)
Singapore Citizens (40 years and above) $320.00 $28.80 $224.00 (70% off course fee) $124.80
Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above) $320.00 $28.80 $160.00 (50% off course fee) $188.80

Course Fee Funding:
MCES: 70% of course fee
Normal: 50% of course fee

REGISTER TODAY

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

Related Courses

IT

24 HRS

WSQ

IT

24 HRS

WSQ

IT

8 HRS

Non-Certifiable

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
Main Category
IT COURSES
Generative AI Series
SOFT SKILLS COURSES
COURSE MONTH
Certification
COURSE LEVEL
Course Duration