Learners who have attended our Microsoft Excel 2016 Basic to Intermediate module or must be well versed in those topics covered in that module.Ĭourse Outline for MS Excel 2016 Pivot Table Proficiency Also, you can now insert Data Models (related data from multiple worksheets) to generate a summarised report.Ī 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. You will also learn how to create formulas in a pivot table as well as creating pivot charts.
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. It will focus on the capability of using the Pivot Table command to give you summarised reports based on your data source. 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. 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. Microsoft Excel 2016 Pivot Table Proficiency Summarise, Analyse, Explore and Present Your Data in Microsoft Excel