Virtual: Zoom (Learn more)
In-Class (Bring your own laptop)
You can also register by:
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.
Must read Things You Would Need to ensure you are properly equiped for this course.
With Microsoft Excel 2019 Pivot table you can analyse massive data by generating suitable and appropriate reports in meaningful ways that is needed in today's information age.
This intensive 7 hour Microsoft Excel 2019 Pivot Table course is designed to help you get up to speed in understanding and using Excel 2019 Pivot Table to get the most out of your data. Do note that this course is not an overview on Excel 2019 Pivot Table.
This Microsoft Excel 2019 Pivot Table will cover:
You will be shown various scenarios on how Excel 2019 Pivot Table can be used to generate useful and relevant reports to aid in decision making. You will be empowered to create formulas in a Excel 2019 Pivot Table to make your analysis and reports even more dynamic and meaningful. Go beyond working with data from one Microsoft Excel 2019 worksheet to data from multiple Excel worksheets in generating a summarised report.
This Microsoft Excel 2019 Pivot Table is filled with examples and comes with ample hands-on exercises to challenge your understanding and ability in using Excel 2019 Pivot Table for data analysis and reporting.
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.
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! 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 Excel 2019 Basic to Intermediate
Microsoft Excel 2019 Advanced
Microsoft Excel 2019 Data Cleaning for Data Analytics
Microsoft Excel 2019 Automating Data Extraction and Cleaning with Power Query
Microsoft Excel 2019 Pivot Table for Data Analysis and Analytics
Microsoft Excel 2019 Advanced Functions and Formulas
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.