Prior knowledge: A good knowledge of common Excel features
Format: One hour hands on
Pivot tables can be used to summarise large tables of data in Excel. They are simpler to use than they first may appear and are a really useful tool to have an understanding of.
This course includes:
- Formatting data for Pivot tables
- Creating Pivot tables
- Basic Pivot controls
- Adding calculated fields
- Sorting and sifting
- Highlighting cells using conditional formatting
- Pivot charts
- Printing a Pivot table
If you can’t see the course you want scheduled or you want to request a different date/time then please contact digitaltraining@yorksj.ac.uk
