Reporting with Pivot Table and Pivot Chart

Reporting with Pivot Table and Pivot Chart (8 hrs)

Course Code: TGS-2018500059 | Broad-based Funding

*Classroom-based Learning*

This course aims to equip participants with the necessary skills and knowledge to use the various commands in Excel’s PivotTable and PivotChart to summarise, analyse and create reports.

  • Able to use Excel to transform transactional data into summary reports
  • Managing the underlying data
  • Creating, modifying a Pivot Table
  • Summarising data by using summary functions other than SUM, such as COUNT or MAX
  • Showing data as a percentage of the total by using a custom calculation
  • Creating your own formula inside a PivotTable report by using a calculated field
  • Modifying the data source and refresh the Pivot Table
  • Filtering, sorting data in a Pivot Table
  • Automatically group data to view a quarterly summary instead of a daily summary in a Pivot Table
  • Manually group data and rename groups
  • Comparing values inPivot Table to show Year-Over-Year Percentage Change
  • Creating Pivot Table using MS Query
  • Creating Pivot Chart
  • Improving the Pivot Chart presentation
  • Creating multiple Pivot Chart quickly
  • Printing Pivot Table and Pivot Chart

The course will be conducted through interactive training methods.

This course is suitable for those who need to master the various commands available in Microsoft Excel’s PivotTable and PivotChart in order to summarise, analyse and create reports.

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$300.00
Less: SkillsFuture Funding $16.00
Total Nett Fee$284.00
Add: GST @ 9% of Course Fee$27.00
Total Fee Payable$311.00

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
  • Able to use Excel to transform transactional data into summary reports
Course Contents
  • Managing the underlying data
  • Creating, modifying a Pivot Table
  • Summarising data by using summary functions other than SUM, such as COUNT or MAX
  • Showing data as a percentage of the total by using a custom calculation
  • Creating your own formula inside a PivotTable report by using a calculated field
  • Modifying the data source and refresh the Pivot Table
  • Filtering, sorting data in a Pivot Table
  • Automatically group data to view a quarterly summary instead of a daily summary in a Pivot Table
  • Manually group data and rename groups
  • Comparing values inPivot Table to show Year-Over-Year Percentage Change
  • Creating Pivot Table using MS Query
  • Creating Pivot Chart
  • Improving the Pivot Chart presentation
  • Creating multiple Pivot Chart quickly
  • Printing Pivot Table and Pivot Chart
Learning Methodology

The course will be conducted through interactive training methods.

Who Should Attend

This course is suitable for those who need to master the various commands available in Microsoft Excel’s PivotTable and PivotChart in order to summarise, analyse and create reports.

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$300.00
Less: SkillsFuture Funding $16.00
Total Nett Fee$284.00
Add: GST @ 9% of Course Fee$27.00
Total Fee Payable$311.00

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
January 8, 2024 - January 8, 2024 (9:00 am - 6:00 pm)
[Classroom]
Closed
February 9, 2024 - February 9, 2024 (9:00 am - 6:00 pm)
[Classroom]
Closed
March 1, 2024 - March 1, 2024 (9:00 am - 6:00 pm)
[Classroom]
Closed
April 29, 2024 - April 29, 2024 (9:00 am - 6:00 pm)
[Classroom]
Register Now
May 17, 2024 - May 17, 2024 (9:00 am - 6:00 pm)
[Classroom]
Register Now
June 14, 2024 - June 14, 2024 (9:00 am - 6:00 pm)
[Classroom]
Register Now