Microsoft Excel 2019 Pivot Table for Data Analysis and Analytics

---

Prerequisites

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.

---

Getting more out of your Data Analysis in Microsoft Excel

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:

• Importing your source data
• Preparing the data
• Creating the tables
• Establishing the Relationship
• Performing the Analysis and Analytics

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.

---

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.

---

Reviews

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