Below is a link to the file developed in the advanced excel class. It has been provided so you can review the work done in class.
- Summarizing data with Pivot Tables
- Group feature with Pivot Tables
- Formulas and nested functions
- Linking cells: name range/name box and hyperlinks
- Nested conditional functions