Master the Use of Microsoft Excel Pivot
Course Code: VTLOKEPT3
Duration: 1 Day (7 Hours)
Pivot table is an efficient Excel tool for handling massive data and when used correctly it can summarize, analyse, explore and present your data in meaningful ways.
This 1-day Excel 2013 Pivot Table Proficiency course is an intensive 7 hour programme design to help you apply and get the most out of your data. It is not just a breeze through which you normally get from an Excel course which also covers many other topics. This course will show you various scenarios on how a pivot table can be used to enable you go beyond the basic usage. In this course you will also learn how to create formulas in a pivot table as well as creating pivot charts.
A full day filled with pivot table examples and ample hands-on exercises to challenge your understanding and ability in using pivot table in Excel 2013 to create better reports and perform better data analysis.
This Course is Suitable For
Learners who have attended our Microsoft Excel 2013 Basic to Intermediate module or must be well versed in those topics covered in the module.
Public Sector – Division 1, 2 & 3
Private Sector – Applicable to All
- Introduction to Pivot Table
- Creating a Pivot Table
- Editing/Updating a Pivot Table
- Filtering Data by Creating a Page Field
- Creating a Chart from Pivot Table
- Customize a Pivot Table
- Creating a Formula in a Pivot Table Report
- Printing Pivot Table and Pivot Chart
- Import Text File
- Data Slicer
- Consolidate Multiple Worksheets in a Pivot Table Report
- Pivot Table Keyboard Shortcuts
Questions to Ask Yourself
I am a very experienced user of Microsoft Excel; do I need to attend the Excel 2013 Basic to Intermediate course before taking this course?
Do note that this course is a focused course on pivot table, time will not be spent teaching or on the revision of Excel features outside of this pivot table course syllabus. You are expected to be familiar with the features covered in our Basic to Intermediate module.
Do I need to attend the Excel 2013 Advanced module before attending this course?
No, it is not necessary.
After completing this course do I still need to attend the Excel 2013 Advanced module?
Yes, we recommend it as there are other topics covered in the Advanced module which would be useful to you.
For Your DelightRefreshments are provided for morning and afternoon tea breaks.
A Certificate of Attendance will be given subject to 90% attendance.
We can tailor this course to suit your needs in terms of course dates, times and location. If you are an organisation, we can further customise the course to meet your training needs and requirements.