01 day - Data Visualisation with Excel Dashboards

01 day – Data Visualisation with Excel Dashboards (8 hrs)

Course Code: TGS-2017501009 | Broad-based Funding

*Classroom-based Learning*

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

  • Create comprehensive management reports using Excel
  • Understand how to generate PivotTable and PivotChart

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

The course will be conducted through interactive training methods.

This course is suitable for those who have attended the basic Microsoft Excel course or have some working knowledge of Microsoft Excel.

Duration : 1 day (8 hrs)
Time : 9:00am to 6:00pm

With effect from 1 Jan 2024

TypeIndividuals
Employer-sponsored Singapore Citizens and Permanent Residents
Type of Funding
SkillsFuture Funding (Broad-Based Funding for Non-certifiable courses)
Course Fee$320.00
Less: SkillsFuture Funding $16.00
Total Nett Fee$304.00
Add: GST @ 9% of Course Fee$28.80
Total Fee Payable$332.80

Funding valid till 31 Dec 2024

* Please click HERE for detailed information on general terms and conditions.

* Please click HERE for detailed information on course fee funding schemes, SkillsFuture credit, and complete listing of funded courses. This course is eligible for use of SkillsFuture credit.

(A course in partnership with James Cook Institute Pte. Ltd. [formerly known as Eagle Infotech] UEN198802365N)

Key Benefits
  • Create comprehensive management reports using Excel
  • Understand how to generate PivotTable and PivotChart
Course Contents

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
Learning Methodology

The course will be conducted through interactive training methods.

Who Should Attend

This course is suitable for those who have attended the basic Microsoft Excel course or have some working knowledge of Microsoft Excel.

Course Details

Duration : 1 day (8 hrs)
Time : 9:00am to 6:00pm

With effect from 1 Jan 2024

TypeIndividuals
Employer-sponsored Singapore Citizens and Permanent Residents
Type of Funding
SkillsFuture Funding (Broad-Based Funding for Non-certifiable courses)
Course Fee$320.00
Less: SkillsFuture Funding $16.00
Total Nett Fee$304.00
Add: GST @ 9% of Course Fee$28.80
Total Fee Payable$332.80

Funding valid till 31 Dec 2024

* Please click HERE for detailed information on general terms and conditions.

* Please click HERE for detailed information on course fee funding schemes, SkillsFuture credit, and complete listing of funded courses. This course is eligible for use of SkillsFuture credit.

(A course in partnership with James Cook Institute Pte. Ltd. [formerly known as Eagle Infotech] UEN198802365N)

Course Application

Details Registration
June 5, 2024 - June 5, 2024 (9:00 am - 6:00 pm)
[Classroom]
Closed
July 12, 2024 - July 12, 2024 (9:00 am - 6:00 pm)
[Classroom]
Closed
August 21, 2024 - August 21, 2024 (9:00 am - 6:00 pm)
[Classroom]
Closed
September 25, 2024 - September 25, 2024 (9:00 am - 6:00 pm)
[Classroom]
Closed
October 10, 2024 - October 10, 2024 (9:00 am - 6:00 pm)
[Classroom]
Register Now
November 1, 2024 - November 1, 2024 (9:00 am - 6:00 pm)
[Classroom]
Register Now
December 13, 2024 - December 13, 2024 (9:00 am - 6:00 pm)
[Classroom]
Register Now