This 1 day course provides students with the knowledge and skills to use the features and functions of Microsoft Office Excel PivotTable 2016 to accomplish analysis tasks.
After completing this course, candidates will be able to:
This course is intended for users of Microsoft Office Excel who want to learn about the features of Microsoft Office Excel PivotTable 2016.
Delegates should have an understanding of the Windows operating system Before attending this course, candidates must have:
This module explains how to use determine the source needed to create its PivotTable report.
This module explains how to rearrange the layout of the PivotTable.
This module explains how to group item, display subtotals and grand totals within the PivotTable. It also introduce the feature of Slicer to display item in PivotTable.
This module explains how to create a second data field and changing the summary function with the PivotTable.
This module explains how to insert formula within the PivotTable.
This module explains how to create a PivotChart, Publishing PivotTable to the Web and using multiple source range for the PivotTable.
If you need further information about this course, please contact: