This course is conducted in PC/Windows operating system. There will be no laptop provided. Learners are required to bring along their own laptops.

1-Day Excel Pivot Table In-Depth
Course In Singapore

Learn how to navigate the complexity of Excel Pivot Tables, build Pivot Tables and leverage Pivot Tables

All our courses are not subsidised and non-claimable using SkillsFuture credit

Excel Pivot Table In-Depth Course Overview

Course Description

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.

Course Objectives

At the end of the course, learners are 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 PivotCharts

Who Should Attend?

This course is for anyone:

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. Our trainer will walk through each of the topics step-by-step. Learners will also be provided with exercise files on each topic to practise application of what has been taught. A short Q & A session will be available after each topic.

Pre-requisites

Completed Excel Basic or active Excel user
Must be familiar in using Excel basic functions
Basic knowledge on Excel chart
Software Requirement: Microsoft Excel version 2010 or higher or Office 365 installed

Things To Bring

PC/Windows operating system laptop with Microsoft Excel version 2010 or higher or Office 365 installed (personal laptop is preferred as some company laptops may have security restriction)
Laptop power adaptor
USB mouse

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 and 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

Calculated field
Calculated Item
Calculations in Show Value As

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 Trainer

Mr Alaster Leong

Having trained adult learners specialising in IT from both public and private sectors since 1986, Alaster has a wealth of experience in training. Before moving into the training sector, Alaster worked in IT for over 12 years – boasting a wide range of roles held within software development. Prior to being approved by People’s Association (PA), Alaster was an Associate Trainer with the Civil Service College. He also holds Microsoft Office Specialist (MOS) certification and specialises in training Microsoft Office Applications and Adobe Photoshop.

With his vast experience and commitment to keeping abreast with emerging trends, tools and technologies within the IT and software industry, Alaster is extensively involved in developing course outlines and materials that equip learners with up-and-coming skills in demand for the future of work.

In constantly exploring innovative and effective methods of imparting knowledge, Alaster is able to engage his learners in the courses he conducts. A large part of his trainings are committed to providing practical solutions to real-life problems, especially in the Excel courses he conducts. An approachable and engaging trainer, Alaster is always willing to aid his learners in overcoming various problems using the skills acquired even after courses. Well-known and liked for his dedication, commitment and passion for training, Alaster is appreciated by his learners.

Our PowerPoint Tips and Techniques course, conducted in Singapore is created and delivered by Mr Alaster Leong with Ms Ow Yeong Yin Leng as co-trainer. His vast background gives him reliability as a trainer.

Ms Ow Yeong Yin Leng

Graduated with a degree in Computer Science with Management and a former programmer, Yin Leng has been conducting IT training for the public and private sectors since 1995.

Yin Leng is not only a Microsoft Certified Trainer since 2009 and an approved trainer by the People’s Association (PA), she was also an Associate Trainer at Civil Service College. Her experience with and knowledge of IT software speak for themselves.

Additionally, she is well-liked for being amicable and approachable. Her passion for training drives her to impart knowledge, sharing her expertise in computer programming and application software with her learners.

Her patient approach to teaching has garnered praises from a variety of learners, ranging from children, adults, disabled, special needs, the general public and even staff of the Grassroot Leader Profile System.

Course Registration

All our courses are not subsidised and non claimable using SkillsFuture credit.

For organisations applying with more than 2 learners, please click here to download the registration form.

All registration forms should be submitted at least 2 weeks before course commencement. Many courses have pre-requisites, which are intended to foster a learner’s success in the course. Be sure to check the necessary pre-requisites before registering.

This course is not subsidised and non claimable using SkillsFuture credit.

COURSE INFORMATION

Course Sponsorship

Company-Sponsored

Self-Sponsored

Number of learners to be registered

One (1)

Two (2)

Select Course*

*Course Date – ALSIT-EDB

*Course Date – ALSIT-PQP

*Course Date – ALSIT-DWF

*Course Date – ALSIT- EPQ1

*Course Date – ALSIT-ETT

*Course Date – ALSIT-EDA1

*Course Date – ALSIT-EFF

*Course Date – ALSIT-VBA1

*Course Date – ALSIT-DCB

*Course Date – ALSIT-PTD

*Course Date – ALSIT-PPT

*Course Date – ALSIT-ERW

*Course Date – ALSIT-WTT

*Course Date – ALSIT-PBI1

*Course Date – ALSIT-PBI2

*Course Date – ALSSS-BGB

*Course Date – ALSSS-EPR

*Course Date – ALSSS-EWE

*Course Date – ALSSS-WBE

*Course Date – ALSSS-WMM

*Course Date – ALSSS-HTA

*Course Date – ALSSS-PLL

*Course Date – ALSSS-POS

*Course Date – ALSSS-UCP

*Course Date – ALSSS-MEW

*Course Date – ALSSS-NCB

*Course Date – ALSSS-DDP

*Course Date – ALSSS-CTS

*Course Date – ALSSS-AEC

*Course Date – ALSSS-MCC

*Course Date – ALSSS-RSO

*Course Date – ALSSS-SSE

*Course Date – ALSSS-WMG

*Course Date – ALSSS-ACS

*Course Date – ALSSS-SEW

*Course Date – ALSSS-ATW

CONTACT & BILLING INFORMATION

Company Name*

Company Address*

Postal Code*

TC/HR First Name*

TC/HR Last Name*

Contact Number*

Email*

Designation*

Department*

Department* (for govt using e-invoice system)

Sub-BU Code* (for govt using e-invoice system)

Billing Information Same as above

Yes

Billing Person First Name* (optional)

Billing Person Last Name* (optional)

Designation* (optional)

Department* (optional)

Contact Number*

Email* (optional)

LEARNER(S) INFORMATION

Learner 1 First Name*

Learner 1 Last Name*

Mobile Number*

Work Email*

Designation*

Dietary Restrictions*

Please specify your food allergies*

Learner First Name*

Learner Last Name*

Block / House No.*

Unit No.*

Street*

Building*

Postal Code*

Mobile Number*

Email*

Citizenship*

Dietary Restrictions*

Learner 2 First Name* (optional)

Learner 2 Last Name* (optional)

Mobile Number* (optional)

Work Email* (optional)

Designation* (optional)

Dietary Restrictions*

Dietary Restrictions* (optional)

Food allergies, please specify*

OTHERS

How did you hear about us?*

Others, please specify*

Name of referral

How did you hear about us?*

Others, please specify*

Terms and Conditions

I have read, understood, and agree to the Terms and Conditions and Privacy Policy.

Terms and Conditions

I have read, understood, and agree to the Terms and Conditions and Privacy Policy.

To learn more, be sure to read our Terms and Conditions and Privacy Policy.

Course Information

Course Code:

ALSIT-PTD

No laptop will be provided. Bring Your Own Laptop Course.

Course Fee:

S$420.00 (Nett)

Inclusive of lunch and 02 coffee breaks with snack items.

Call us for a group rebate when you register in a group of 8 or more.

Absentees will be charged the full course fee.

Course Dates:

1 day, 9:00am – 5:00pm
(7 hrs, exclude lunch break)

A closed class can be requested if you have a group of at least 6 or more registered for the same course and at a preferred month, subject to trainer availability.

Closed class is not customised class.

Training Venue:

To be confirmed one (1) week prior to the course start date.

Registration:

For Company-Sponsored learners: Click here to download registration form.

For Self-Sponsored learners: Click here to download registration form.

You can also register online here.

Note:

ALS reserves the right to reschedule, postpone or cancel any course, change the trainer and venue at short notice and at its absolute discretion, due to insufficient enrolment, class size, availability and circumstances outside our control.