Course Name

Microsoft Excel 2016: Maximising Pivot Tables

  • Duration: 1 Day(s)
  • Date: 04 Nov, 2024
  • Price: R1, 643.00 (excl. VAT)
Call me back
Get Overview
Book now!

Course Introduction

This one-day course provides delegates with the knowledge and skills to use the features and functions of Microsoft Office Excel PivotTable to accomplish analysis tasks.

Course Objectives

You will:

  • Create a PivotTable.
  • Rearrange the layout.
  • Change the sort order & top10 auto show.
  • Group data manually.
  • Use a slicer Create a custom calculation.
  • Use GETPIVOTDATA function.

Course Content

  • Module 1 – Make Your Data Work for You
    • Maximize the Power of Pivot Table
    • Ask the Questions You Choose
    • Get the Answers You Want
  • Module 2 – Quick Tour
    • Determine What You Want to Know
    • The Source Is Important
    • Ready, Set, Go
    • The PivotTable Layout
    • What Goes Where
    • Our PivotTable Report
    • Viewing Our Data Differently
  • Module 3 – Manipulating the Pivot Table
    • Rearrange the Layout
    • A New Field
    • Remove A Field
    • Rename A Field
    • Format Numbers
    • Change the Sort Order & Top 10
    • Auto Show
    • Refresh Data
  • Module 4 – Digging Deeper
    • Create a Quarterly Group
    • Group Data Manually
    • Display Subtotals
    • Hide / Display Grand Total
    • Format A PivotTable Report
    • Use a Slicer
    • Format A Slicer
  • Module 5 – Beyond the Basics
    • Create a Second Data Field
    • Use Count to Summarise Data
    • Display Numerical Data as A Percentage of the Total
    • Create a Custom Calculation
    • Use More Functions in Custom Calculation
  • Module 6 – More Pivot Table Calculations
    • Using Formulas
    • Calculated Fields
    • Calculated Items
    • Use GETPIVOTDATA Function
    • Turn off GETPIVOTDATA Function
L❤ ve this. Share it now!

Need additional information?

We are here to support your growth every step of the way

Please call me

Get in touch

Contact the Impactful team if you need any assistance.
Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

Course Introduction

This one-day course provides delegates with the knowledge and skills to use the features and functions of Microsoft Office Excel PivotTable to accomplish analysis tasks.

Course Objectives

You will:

  • Create a PivotTable.
  • Rearrange the layout.
  • Change the sort order & top10 auto show.
  • Group data manually.
  • Use a slicer Create a custom calculation.
  • Use GETPIVOTDATA function.

Course Content

  • Module 1 – Make Your Data Work for You
    • Maximize the Power of Pivot Table
    • Ask the Questions You Choose
    • Get the Answers You Want
  • Module 2 – Quick Tour
    • Determine What You Want to Know
    • The Source Is Important
    • Ready, Set, Go
    • The PivotTable Layout
    • What Goes Where
    • Our PivotTable Report
    • Viewing Our Data Differently
  • Module 3 – Manipulating the Pivot Table
    • Rearrange the Layout
    • A New Field
    • Remove A Field
    • Rename A Field
    • Format Numbers
    • Change the Sort Order & Top 10
    • Auto Show
    • Refresh Data
  • Module 4 – Digging Deeper
    • Create a Quarterly Group
    • Group Data Manually
    • Display Subtotals
    • Hide / Display Grand Total
    • Format A PivotTable Report
    • Use a Slicer
    • Format A Slicer
  • Module 5 – Beyond the Basics
    • Create a Second Data Field
    • Use Count to Summarise Data
    • Display Numerical Data as A Percentage of the Total
    • Create a Custom Calculation
    • Use More Functions in Custom Calculation
  • Module 6 – More Pivot Table Calculations
    • Using Formulas
    • Calculated Fields
    • Calculated Items
    • Use GETPIVOTDATA Function
    • Turn off GETPIVOTDATA Function

Are you ready to start?

Sign Up
Download Overview

Certified global best practices in the new technologies…

Amazon Web Services Impactful Partner
PeopleCert Logo
Impactful is an Accredited Oracle University Partner
Impactful Partner Microsoft logo

Get ahead with your IT and Digital Talent development

Please complete the form with your information and one of our experts will get back to you soon.

Get in touch

Contact the Impactful team if you need any assistance.

Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

About LRMG

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

CONTACT US