WhatsApp Us9:00am to 5:30pm (Mon-Fri) Stay Safe!

Microsoft Excel 2019 Pivot Table for Data Analysis and Analytics

Training Modes
 Virtual: Zoom (Learn more)
 In-Class (Bring your own laptop)

Course Code
7 Hours (1 Day)
Course Fee
$348.80 inclusive of GST
UTAP for NTUC Members
This Course is For
Anyone who needs to use Pivot Table for data analysis and report generation.

Preferred Date

You can also register by:

  1. Form: Click here to download. Email back to us.
  2. Ministries on HRP / ACE: Inform your Training Coordinator the Course Code, Course Date and the Training Provider is Oaks Training c/o GIL Consultancy.
    IMPORTANT NOTE: OAKS TRAINING begins with the letter O and not the symbol @ in HRP
  3. PHONE: Call +65 6423 1183.


Learners should ideally have completed our Excel 2019 Basic to Intermediate module or must be well versed in those topics covered in that module. This course is suitable for users of Microsoft Office 2016.

Important Note
Must read Things You Would Need to ensure you are properly equiped for this course.

Unlock the Power of Microsoft Excel 2019 Pivot Table!

Are you ready to take your data analysis skills to the next level? Microsoft Excel 2019 Pivot Table is your gateway to analyzing massive data sets and generating meaningful reports that drive success in today's information age.

Join our intensive 7-hour Microsoft Excel 2019 Pivot Table course designed exclusively for beginners like you! This course is not a mere overview; it's a deep dive into the world of Excel Pivot Table, ensuring you get the most out of your data analysis.

Throughout the course, you'll conquer the entire workflow, from importing and preparing data to creating tables and establishing essential relationships. With real-life scenarios and hands-on exercises, you'll become a pro at using Excel 2019 Pivot Table for data analysis and analytics.

Course Highlights:

  • Analyze massive data sets with ease using Excel 2019 Pivot Table.
  • Generate suitable and meaningful reports for informed decision-making.
  • Elevate your skills by working with data from multiple Excel worksheets.
  • Empower yourself with hands-on exercises and numerous examples.

Become a data analysis whiz and uncover hidden insights that lead to smarter decisions. Excel 2019 Pivot Table opens up a world of possibilities, and this course is your roadmap to mastering its capabilities.

Don't miss this opportunity to revolutionize your data analysis skills! Enroll now and embark on an exciting journey of discovery with Microsoft Excel 2019 Pivot Table. Let's unleash the potential of your data together!

Take charge of your data analysis journey and make your mark in the information age. Sign up today!

Our Friendly Trainer

Ms Daphne Wong
Ms Kendra Ong
Ms Pauline Lee
Ms Ow Yeong Yin Leng

Qualified and Experienced to facilitate this course

  • More than 20 years of training experience
  • Native speaking Trainers
  • Microsoft Certified

Special Request

Additional Dates: If the dates listed are not suitable for you and you have a group interested in the same course, you can contact us to arrange a date of your choice, subject to our trainer availability.

Evening classes or Classes in Mandarin are also available on request. Contact us for arrangements.

Group discounts are also available. Request a quote from us.


Very friendly teaching.
- Sheik Osman (HTX)

Ms Dapnhe delivers a very clear, precise and easy to understand lesson. I have enjoyed and benefited from her class.
- Maslinda (MHA)

Trainer is friendly and presentation is clear.
- An Individual

No Exam
No Exam! Ample hands on practice to master lessons taught.

Certificate of Attendance will be given subject to 90% attendance.

Local native speaking Trainers with more than 20 years of experience.

Empowering the Enduser
Our dedication lies in equipping our learners with the tools to empower themselves. Recognizing the constant evolution of technology in the workplace, we understand the challenges and expectations they face. Bridging this gap for our learners is our motivation. We have faith in the potential of every individual and their determination to achieve success.

Classes in Mandarin

Select courses can be delivered in Mandarin on request basis via Zoom.

  • Microsoft Office
  • Video Editing
  • Essential Digital Skills

Contact Us

Mon-Fri, 8:30am-5:30pm
Phone: 6423-1183
Online Enquiry: Click here
Locate Us: Click here