01 day – Data Visualisation with Excel Dashboards

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 Timing

9am-6pm

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.

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 $28.80 $16 $332.80

Self-Sponsored

Full Fee GST Nett Fee Payable (incl. GST)
$320 $28.80 $348.80

Date & REGISTRATION

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