Virtual: Zoom (Learn more)
In-Class (Bring your own laptop)
You can also register by:
Learners should ideally have completed our Office 365 Excel Basic to Intermediate moduleor must be well versed in those topics covered in that module
This course is suitable for users of Microsoft Office 2019 or 2021.
Must read Things You Would Need to ensure you are properly equiped for this course.
Feeling unsure how to begin with data given to you to analyse and produce reports and charts? Facing a hard time managing your huge volume of data from multiple Excel worksheets, relating them and formulating reports in Excel? If that is how you are feeling, this Office 365 Excel Pivot Table for Data Analysis and Analytics course is for you.
With Office 653 Excel Pivot Table you can organise and manage your data to generate meaningful and accurate reports easily with much less time. What’s more the Excel Reports and Charts produced from Office 365 Excel Pivot Table can also be modified and updated with ease.
This 1 day Microsoft Office 365 Excel Pivot Table course is designed to help you get up to speed in understanding the entire work process from receiving the data to the production of reports and charts in meaningful ways.
This Microsoft Office 365 Excel Pivot Table course will cover the entire work flow from:
Various scenarios will be shown on how Office 365 Excel Pivot Table can be used to generate useful and relevant reports to aid in better decision making. You will learn how to create formulas in Office 365 Excel Pivot Table making your analysis and reports dynamic and meaningful. You will be able to go further with confidence working with data from multiple Excel worksheets when generating a summarised report.
This Microsoft Office 365 Excel Pivot Table course comes with examples and ample hands-on exercises to challenge your understanding in using Office 365 Excel Pivot Table for data analysis and reporting to better meet the demands of this data-driven era.
Ms Daphne Wong
Ms Kendra Ong
Ms Pauline Lee
Ms Ow Yeong Yin Leng
Qualified and Experienced to facilitate this course
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.
Trainer is very knowledgable and give detailed explanation to participants.
- Mohd Faizal (MHA)
Thanks for the very good and useful tips.
- Leong Wing Mun (SPS)
Thanks for your patience and guidance.
- Seet Chay Huang (ARES)
Thank you for imparting the knowledge of pivot table to us, it will be very helpful for my job!
- Ong (MHA)
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.
Microsoft Office 365 Excel Basic to Intermediate
Microsoft Office 365 Excel Advanced
Microsoft Office 365 Excel Data Cleaning for Data Analytics
Microsoft Office 365 Excel Automating Data Extraction and Cleaning with Power Query
Microsoft Office 365 Excel Pivot Table for Data Analysis and Analytics
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.
Select courses can be delivered in Mandarin on request basis via Zoom.