Reporting with Pivot Table and Pivot Chart

COURSE details

Course Duration

8 HRS

Course Reference Number

TGS-2018500059

Funding Validity Period

02 Jul 2019 To
31 Dec 2023

Mode of Training

Classroom

COURSE OVERVIEW

This course equips participants with the skills to use Excel tools effectively for creating spreadsheet solutions and performing statistical analysis. It is ideal for individuals who need to manage and analyse data using Microsoft Excel.

Participants will learn to effectively manage and analyse data using PivotTables and PivotCharts in Microsoft Excel. They will gain skills in creating, modifying, and summarising data in PivotTables, using custom calculations and formulas, grouping data, and comparing values. Additionally, they will learn to create and enhance PivotCharts, and efficiently print both PivotTables and PivotCharts.

  • Managing the Underlying Data
  • Creating, modifying a Pivot Table
  • Summarizing 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

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

• 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 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)
$300 $27 $16 $311

Self-Sponsored

Full Fee GST Nett Fee Payable (incl. GST)
$300 $27 $327

Date & REGISTRATION

Select a date below

Looking at in-house training or have an enquiry? Contact us!

Related Courses

IT

8 HRS

Non-Certifiable

IT

8 HRS

Non-Certifiable

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