Summarise, Analyse, Explore and Present Your Data in Microsoft Excel
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 2016 Pivot Table Proficiency course is an intensive 7 hour programme that is designed to help you apply and get the most out of your data. It will focus on the capability of using the Pivot Table command to give you summarised reports based on your data source. Through the course, you will be shown various scenarios on how a pivot table can be used to enable you go beyond the basic usage. You will also learn how to create formulas in a pivot table as well as creating pivot charts. Also, you can now insert Data Models (related data from multiple worksheets) to generate a summarised report.
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 2016 to create better reports and perform better data analysis.
Who is this course for?
Learners who have attended our Microsoft Excel 2016 Basic to Intermediate module or must be well versed in those topics covered in that module.
Public Sector - Div. 1, 2 & 3
Private Sector - Applicable to All
Course Outline for MS Excel 2016 Pivot Table Proficiency
- Pivot Table Keyboard Shortcuts
- Introduction to Pivot Table
- Creating Range Name to define Data Source
- 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
- Inserting Data Slicer & Timeline
- Creating Formula in a Pivot Table Report
- Import Text File & Access Table(s)
- Consolidating Multiple Worksheets in a Pivot Table Report
- Adding Data Model
Questions to Ask Yourself
I am a very experienced user of an earlier version of Microsoft Excel; can I take up 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.
After completing this course do I still need to take up your Microsoft Excel 2016 Advanced module?
Yes, this is not a replacement course of our Advanced Excel module which covers other essential Excel skills that you would need.
