Advanced Learning Singapore

Download Year 2024 Training Calendar

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.

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

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

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.

  • Completed Excel Basic or active Excel user
  • Must be familiar in using Excel basic functions
  • Basic knowledge on Excel chart
  • 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


SGD 420.00 (Nett)

Absentees will be charged the full course fees


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


Classroom @ Hotel

(Venue may be subject to changes)


15 May 2024
19 Jun 2024
14 Aug 2024
18 Sep 2024
23 Oct 2024
18 Dec 2024

Why Learn With Us?

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.

Share This Course

Scroll to Top