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

Microsoft Office 365 Excel Table and Advanced Pivot Table Techniques for Faster Results

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

Course Code
7 Hours (1 Day)
Course Fee
$392.40 inclusive of GST
UTAP for NTUC Members
This Course is For
Anyone who needs to use Office 365 Excel Table and Pivot Table more efficiently.

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 Office 365 Excel Basic to Intermediate and Advanced modules or have been using Excel Tables and Pivot Table at work.

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

Get the most out of Excel Tables and Pivot Tables to Save Time, improve Accuracy and Efficiency

Have you ever wondered why it is such a hassle to update and view data in a form or Pivot Table? Things just does not seem to update properly or otherwise tedious to update them or list them causing inaccuracies and errors.

How can reading data from a Pivot Table be made easier? Having to screen through the massive volume of data values can be tiring and confusing. There is a much easier why to represent data that is easy to comprehend and digest.

Discover quick ways of creating useable and friendly Dashboards from Excel Tables and Pivot Tables that is easy to understand and analyse in making informed decisions.

This 1 day Excel Table and Advanced Pivot Table Techniques for faster results course comes with examples and ample hands-on exercises designed to help you harness the power of Tables and Pivot Tables in Excel.

Our Friendly Trainer

Ms Daphne Wong
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
  • ITE 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.


Coming Soon

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 is what we are committed to equiping our learners. We understand the challenges and expectations faced in their daily work. To help learners bridge the gap is what drives us. We believe in the common person and their will to succeed.

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