Trusted Training Partners

Quick Look Course Summary:Microsoft Excel Pivot Tables Course
  • Next Public Course Date:

  • Length: 1 day(s)

  • Price (at your venue): 1 Person R 3,982.50 EX VAT 3 Person R 2,729.81 EX VAT 10 Person R 1,885.40 EX VAT

  • Certification Type:Accredited

  • Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.

Get Free & personalised
Training Advice

Knowing your course will help us prepare for our consultation and phone call.

The more people you send on our courses, the cheaper the unit cost.


Input this code: captcha

Microsoft Excel Pivot Tables Course: Introduction

A critical component of Microsoft Excel are the chart and table graphics which can be applied to worksheets and workbooks to make the presentation of data easier to understand and more visually appealing and professional. The Business Optimisation Training Institute presents a workshop solely focused on Excel Pivot Tables. This is an essential workshop for anyone using Excel or any other spreadsheet program. We invite participants to this one day workshop at the end of which participants will receive a certificate of attendance. All materials required by students will be provided.

Microsoft Excel Pivot Tables Course :Course Outline

1. Making data work more efficiently
Maximising the options of the Pivot Table
Questions that need answering.

2. A Short Tour
Contents of the Pivot table.
Define what you need to know
Different views of data.
Layout of the Pivot Table
Pivot table results.
Set to go
The importance of the source.

3. Adjusting the Pivot table
Adding a new field
Formatting numbers
Rearranging the layout
Removing a field
Renaming fields
Sorting, and re-arranging Auto show

4. A comprehensive lesson
Creating a quarterly Group
Displaying subtotals
Formatting a report.
Formatting a slicer.
Grouping data manually
Hide or display totals
Using a slicer.

5. Intermediate and advanced options
Create customised calculations.
Create a Second Data Field.
Displaying Numerical Data as a Percentage
Functions in Custom Calculation
Summarising Data

6. Advanced Pivot Table Calculations
Creating a Calculated Field.
Creating a Calculated Item
Using Formulas
Using the Get Pivot Table function
Using Pivot Table Data outside the report.
Turn off the Get Pivot Data function

7. Other advanced topics
Create a Pivot Chart Report.
Publishing Pivot Table Reports to the Web
Using multiple ranges as Source Data

Microsoft Excel Pivot Tables Course: Course Duration

1 day/s

Who should attend: Microsoft Excel Pivot Tables Course

This course is intended for anyone who already has a working knowledge of Excel and would like to broaden their knowledge regarding Pivot Tables.

**Quote does not include Any Exam Fees (if applicable)

IMPORTANT ACTION: Do Not Wait To Improve Your Skills.  

Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal

Realize incredible savings by sending more delegates

Do you want to save costs by doing training at your premises?

Save costs by providing own laptop

Region *

Accredited Courses

Additional Courses

Software & IT Courses

Top Rated