Below is the file developed in class.
It has been provided so you can practice the exercises done in class:
- Working with a pivot table
- Showing details
- Using name ranges
- Grouping
- Filtering pivot table results
- Interpreting pivot table results
- Nested functions
- Shortcuts
- Linking worksheets
- Pasting name range
- Refreshing pivot table and chart