1-Day Excel Pivot Table In-Depth Course

Course Overview

This course is created, owned, and trained by its original creator, Mr. Alaster Leong, and co-trained by Ms. Ow Yeong Yin Leng. Learn from the original creator.

Pivot Table is a highly sought-after must-have skills at work, regardless of position.

Pivot Table is one of the most powerful and useful features in Excel. A Pivot Table allows the extraction of significance from large, detailed data sets. Our Excel Pivot Table In-Depth training course will prepare you to use them to your advantage.

Our trainer will demonstrate the mechanics of leveraging Pivot Tables to summarize, sort, count and chart data in Microsoft Excel. You will also learn to navigate the complexity of Pivot Tables that will be useful in helping you build Pivot Tables from single or multiple data sources, add calculated fields, filter your results and format your layout for readability.

Objectives

Upon completion of the course, learners will be able to:

Prepare data source to use in Pivot Table
Create a PivotTable
Get data from external source
Summarize multiple data fields
Manage subtotals and grand totals
Group Pivot Table fields
Filter with selections, rules, search filters, slicers, and timeline
Apply Pivot Table styles
Format cells with conditional formatting
Show different calculations in PivotTable value fields
Create calculated fields using formulas
Create calculated items with combine fields
Create Pivot Charts

Who Should Attend

This course is for anyone:

Who wants to learn how to auto-refresh the Pivot Table when opening the file
Who is keen to learn the proper way of creating Pivot Table
Who wants to go beyond the basic Pivot Table e.g. using formula to create calculated fields
Who wants to summarize their data in different ways
Who wants to generate more reports which is hard to achieve in normal spreadsheet
Who wants to generate chart that is easily changeable using Pivot Table

Methodology

This is a hands-on practical course. Trainer will walk through the topic step-by-step. Learners will be provided with exercise files on every topic to effectively apply what have been taught. A short Q & A session will be available after each topic.

Prerequisites

Completed Excel Basic or active Excel user
Must be familiar in using Excel basic functions
Basic knowledge on Excel chart

Things To Bring

A Windows operating system laptop with Microsoft Excel version 2010 or higher or Office 365 installed.
Laptop power adaptor and a USB mouse.

Course Information

Fee

SGD 420.00 (Nett)

Absentees will be charged the full course fee

Includes lunch and two coffee breaks with light snacks, unless otherwise stated

Time

9:00am to 5:00pm (7 hours)

Mode

Classroom @ Hotel

Dates

5 Mar 2025
19 May 2025
23 Jul 2025
22 Sep 2025
12 Nov 2025

Important Note

Closed Class

Important Note

Closed Class

Why Learn With Us?

Course Outline

1. Introduction to Pivot Table

2. Preparing Data Source to be used in Pivot Table

3. Creating Pivot Table

4. Using External Data Source in Pivot Table

5. About Pivot Table Fields Pane

6. About Pivot Table Structure

7. Building Up Pivot Table

8. Pivoting the Pivot Table

9. Show Report Filter Pages

10. Removing Field from Pivot Table

11. Managing Pivot Table

12. Grouping Fields

13. Sorting & Filtering Pivot Table Data

14. Refreshing Pivot Table

15. Formatting Pivot Table

16. Summarizing Pivot Table Data

17. Working with Pivot Chart

18. Printing Pivot Tables & Pivot Chart

19. Calculation in Pivot Table

20. Solution for Multiple Pivot Tables using the Same Source Data

21. Converting a Cross Tab Data into Normal Data List (Optional)

22. Using Multiple Source Data (Optional)

Our Dedicated Lead IT Trainer - Mr. Alaster Leong

This course is created, owned and trained by Mr. Alaster Leong. Learn from the original creator of this course.

Alaster has been training adult learners in IT in both the private and public sectors since 1986. Alaster’s career before training centred around IT for over 12 years, as he held various roles within software development. He has earned himself a Microsoft Office Specialist (MOS) certification and he is an existing Trainer approved by People’s Association (PA). He was also a former Associate Trainer with the Civil Service College.

He specialises on training Microsoft Applications and Adobe Photoshop. Based on his vast experience and keeping abreast with the emerging trends, tools and technologies with the IT industry, especially software, he has extensively involved in developing several course outlines and course materials and conducting training to equip learners with skills in-demand or likely to be most important in the jobs of the future work.

Alaster constantly explore innovative and effective ways in imparting knowledge and engaging his learners at the same time. He also focuses his training on providing practical solutions to real-life problems, especially Excel. He is more than willing to help overcome various problems faced by his learners that arise in their workplace in applying their newly-acquired knowledge and skills any time after the course. He is well-known for his dedication, commitment and passion to training that makes him well-liked and appreciated by his learners.