Below are links to the files 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
- Creating macros and buttons
- Creating a macro for a specific purpose