Microsoft Excel - Pivot Tables Course Overview

Enroll for our 1-day Microsoft Excel - Pivot Tables from Koenig Solutions. In this course you will learn how pivot tables can be used to analyse, sort, filter and present data. This course is designed to give you a solid understanding of Pivot Tables, taking you from novice to expert. A pivot table is an incredibly powerful tool in Excel that can be used to analyse, explore and summarize your data.

The course is designed for Excel 2016, 2019 and Microsoft 365 (Office 365), so you can choose the version that works best for you.

Target Audience:

This course is intended for those with a basic working knowledge of Excel who want a greater understanding of the more sophisticated functions and features available in Pivot Tables.

Learning Objectives:

After completing this course, you will be able to:

  • At the end of this course you will have a greater understanding of the functionality and potential of Pivot Tables.
  • You will be able to construct and manipulate complex summaries and analyses of data using Pivot Table tools, control visual and data formatting, manage and add to the statistical analysis of your data, deal with varying data sources, automate, troubleshoot and utilise Pivoted data in many different contexts.

 

This is a Rare Course and it can be take up to 3 weeks to arrange the training.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Module 1: Basics of PivotTable
  • What is a PivotTable and why we use that?
  • The PivotTable Life Cycle
  • Creating Your First PivotTable
  • Field Well Options
  • Source Data Best Practices
  • Using Excel Ranges
  • Preparing Source Data
  • Using External Data
  • Managing Power Queries
  • Totals and Sub-Totals
  • Choosing PivotTable Layouts
  • Grouping
  • Aggregation
  • Running Totals
  • Percent of x Calculations
  • Difference From Calculations
  • Percentage Difference From Calculations
  • Top and Bottom x Items
  • Top and Bottom x Items
  • Calculated Items
  • Value Field Formats
  • Preserving Cell Formats on Update
  • PivotTable Styles
  • Custom PivotTable Styles
  • Conditional Formatting on PivotTables
  • Basic Sorting
  • Custom Sorting
  • Sorting Values
  • Report Filters
  • Built-in Filter Controls
  • Slicers
  • Timelines
  • Filtering Multiple PivotTables
  • Show Details
  • GETPIVOTDATA
  • Creating PivotCharts
Live Online Training (Duration : 8 Hours) Fee On Request
Group Training
30 May GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)
06 Jun GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 Jul GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Comfort Track

If you think 8 hours is too fast, we can offer Comfort Track for 16 hours

Course Prerequisites
  • Basic understanding of Excel.

Request More Information

Add Name and Email Address of participant (If different from you)