Maximizing Pivot Table (Microsoft Excel 2013/2016) (7.5 hrs)

Course Code: CRS-N-0040877

This in-depth course introduces ways to create and work with PivotTables to organise and summarise data in a variety of ways. Participants will discover how to perform a variety of calculations with the PivotTable and analyse data.

  • Organise, summarise and analyse data using PivotTable
  • Perform calculations using PivotTable

Making data work

  • Maximise the power of PivotTable
  • Ask the questions
  • Get the answer

A quick tour

  • Determine what one’s need to know
  • Identify the source
  • Creating the PivotTable
  • Working with PivotTable layout

Manipulating the PivotTable

  • Rearranging the layout
  • Adding new field
  • Renaming a field
  • Formatting numbers
  • Changing sorting order
  • Showing top 10
  • Refreshing data

Digging deeper

  • Grouping items
  • Displaying subtotals
  • Hiding / showing grand totals
  • Formatting PivotTable
  • Using slicer
  • Formatting slicer

Beyond the basics

  • Creating second data field
  • Changing the summary function
  • Displaying numerical value as a percentage of the total
  • Creating a custom calculation
  • More function in custom calculation

More PivotTable calculations

  • Using formulas
  • Creating a calculated field
  • Creating a calculated item
  • Using GetPivotData function
  • Turn off GetPivotData function

Optional topics

  • Creating PivotChart
  • Publishing PivotTable to the web
  • Timeline in PivotTable
  • Creating relationships between multiple tables
  • Multiple tables in data analysis
  • Drill into PivotTable
  • Using multiple source ranges

Participants will benefit from the hands-on practical sessions during the course.

This course is suitable for individuals with general proficiency in Microsoft Excel and looking to perform various calculations with PivotTable data.

Prerequisite

Participants must have knowledge of Microsoft Excel 2010/2013/2016.

Duration : 1 day (7.5 hrs)
Time : 9:00am – 5:30pm

Course Fee : $350.00
Nett Fee Incl. 7% GST : $374.50
SDF Support* : $15.00

* 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 COMAT)

Key Benefits
  • Organise, summarise and analyse data using PivotTable
  • Perform calculations using PivotTable
Course Contents

Making data work

  • Maximise the power of PivotTable
  • Ask the questions
  • Get the answer

A quick tour

  • Determine what one’s need to know
  • Identify the source
  • Creating the PivotTable
  • Working with PivotTable layout

Manipulating the PivotTable

  • Rearranging the layout
  • Adding new field
  • Renaming a field
  • Formatting numbers
  • Changing sorting order
  • Showing top 10
  • Refreshing data

Digging deeper

  • Grouping items
  • Displaying subtotals
  • Hiding / showing grand totals
  • Formatting PivotTable
  • Using slicer
  • Formatting slicer

Beyond the basics

  • Creating second data field
  • Changing the summary function
  • Displaying numerical value as a percentage of the total
  • Creating a custom calculation
  • More function in custom calculation

More PivotTable calculations

  • Using formulas
  • Creating a calculated field
  • Creating a calculated item
  • Using GetPivotData function
  • Turn off GetPivotData function

Optional topics

  • Creating PivotChart
  • Publishing PivotTable to the web
  • Timeline in PivotTable
  • Creating relationships between multiple tables
  • Multiple tables in data analysis
  • Drill into PivotTable
  • Using multiple source ranges
Learning Methodology

Participants will benefit from the hands-on practical sessions during the course.

Who Should Attend

This course is suitable for individuals with general proficiency in Microsoft Excel and looking to perform various calculations with PivotTable data.

Prerequisite

Participants must have knowledge of Microsoft Excel 2010/2013/2016.

Course Details

Duration : 1 day (7.5 hrs)
Time : 9:00am – 5:30pm

Course Fee : $350.00
Nett Fee Incl. 7% GST : $374.50
SDF Support* : $15.00

* 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 COMAT)

Course Application

Details Registration
January 10, 2020 - January 10, 2020 (9:00 am - 5:30 pm) Closed
February 6, 2020 - February 6, 2020 (9:00 am - 5:30 pm) Closed
March 30, 2020 - March 30, 2020 (9:00 am - 5:30 pm) Closed
August 4, 2020 - August 4, 2020 (9:00 am - 5:30 pm) Closed
September 11, 2020 - September 11, 2020 (9:00 am - 5:30 pm) Closed
October 7, 2020 - October 7, 2020 (9:00 am - 5:30 pm) Register Now
November 12, 2020 - November 12, 2020 (9:00 am - 5:30 pm) Register Now
December 2, 2020 - December 2, 2020 (9:00 am - 5:30 pm) Register Now