Pivot Tables allow you to generate new views of your (sometimes overwhelming) data so you can generate reports that help you summarize, analyze, explore and present your data in a more organized manner. This class is intended for users who have Intermediate or advanced Excel skills.
- Simplicity – PivotTables use a graphical approach to create summaries.
- Multiple dimensions – You can summarize data using both row and column headings, including using multiple fields in each area and you can also use a series of criteria fields that filter all the data in the table.
- Excel 2010 introduced ‘Slicers’: interactive criteria controls that are linked to each other and can be linked to multiple PivotTables.
- Interactive analysis – Once you’ve arranged your data in the PivotTable, if you think of other useful information the data could provide, you can rearrange the data simply by dragging fields to different areas.
- Data can easily be displayed graphically – A PivotChart can be created from a PivotTable with a single click.
- When linked directly to external data, PivotTables can be automatically refreshed to include new and amended data.
Prerequisite: MS Excel Intermediate or Instructor permission.
- March 17 1:00 – 4:00 pm
- May 12 5:30 – 8:30 pm