Excel 2013/2016 Pivot Tables
The class will also include an overview of creating standard tables and charts from an Excel worksheet; however, participants need to have a good understanding of and experience with Excel prior to this class.
Performance Objectives: Upon completion of this course you should be able to:
- Creating and customizing Pivot Tables
- Nesting fields
- Grouping data
- Calculating and customizing statistics
- Filtering data
- Utilizing Slicers
- Creating and customizing Pivot Charts
Competencies covered in this course: Manage large amounts of data to extract meaningful information.
Intended Audience: Anyone who works with large amounts of data in Excel.
Recommended Pre-requisites: Users with a good understanding of Excel and familiarity with tables, charts and formulas.