Course Length
Three hours
Prerequisites
Excel 2016 Introduction or equivalent experience
Course Description
Participants will learn how to create and use PivotTables to quickly summarize and manipulate large amounts of data. After creating PivotTables, we will explore PivotCharts ‑ a flexible chart based on the data in a PivotTable.
Course Topics
- Create a blank PivotTable from an Excel list or table
- Work with the PivotTable Field List
- Change the view of the PivotTable Field List
- Add, remove, and rearrange fields in the PivotTable
- Create a PivotTable using recommended PivotTables
- Sort data
- Refresh a PivotTable and change the data source
- Move, clear, and delete a PivotTable
- Change the number format of a data field
- Change the calculation for a value field
- Insert, edit, and delete a calculated field and calculated item
- Display or hide subtotals and grand totals
- Change the PivotTable style and style options
- Show or hide the expand and collapse buttons
- Expand or collapse levels of detail
- Display details for a value field on a new worksheet
- Use report filters and show report filter pages
- Filter rows, columns, and by selection
- Create, use, format, clear, and delete Slicers
- Create, customize, clear, and delete a Timeline
- Combine Slicers with a Timeline
- Group and ungroup numeric items, dates, or times
- Manually group selected items
- Create, modify, and move a PivotChart
- Select data & change the layout
- Merge and center cells with labels
- Insert or remove blank lines
- Show or hide field headers
- Repeat item labels in rows or columns
- Print sections on separate pages
- Set Print Titles
- Print expand/collapse buttons
- List formulas
- Create a PivotTable based on an Access database
- Create relationships between tables in Excel
- Create a PivotTable using tables in a Data Model
- View specifications and limits
What Participants Receive
Each participant receives a guide containing step-by-step instructions and practice exercises.
