Data Visualisation with Excel Dashboards

Funding Validity Period

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.

Skills Acquired

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.

Learning Modules

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

What is a dashboard
Key characteristics of a dashboard

Define information needs
Acquire and arrange data

Dashboard Dos and Don’ts
Selecting appropriate tools
Determine chart elements and colour selection
Histogram

Insert and populate a PivotTable and PivotChart
Update PivotTable data
Using Slicer

Conditional formatting
Using Range Names
Create Drop-down list with data validation

Use Lookup and Reference functions
Use INDEX and MATCH functions
Database functions

Create standard charts
Combination chart
Sparkline

Format axis
Display/format Data Labels

Pareto chart
Box & whisker chart
Gauge or Speedometer chart

Who is this course is for

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

Academic prerequisites

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 Fees

Fees	Company / Self Sponsored
Full Fee	$320
GST	$28.80
Nett Fee Payable (incl. GST)	$348.80