This session focuses on the power of pivot tables within Microsoft Excel. We initially discuss the creation of pivot tables and various ways to summarize information. Then we explore ways to utilize summarized pivot table data. The course uses several practical examples that should inspire participants to find their own creative uses for pivot tables.
DESIGNED FOR
Excel users at all levels who want to enhance efficiency when analyzing and reporting data
BENEFITS
- Create a pivot table in Excel
- Customize a pivot table
- Utilize output from a pivot table
HIGHLIGHTS
- Data preparation and cleansing
- Pivot table creation
- Pivot table customization
- Navigating Excel’s PivotTable Analyze tab
PREREQUISITES
A basic understanding of Microsoft Excel
ADVANCE PREPARATION
None