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
Type | Individuals | |||
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)
- 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
Type | Individuals | |||
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 |