Microsoft Excel - Pivot Tables Certification Training 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.

 

Microsoft Excel - Pivot Tables (8 Hours) Download Course Contents

Live Virtual Classroom 650
Group Training
01 Nov GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 Dec GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Request More Information

Course Prerequisites
  • Basic understanding of Excel.