I’m pleased to announce below is the link to the worksheet developed during the Saturday workshop on 3-15-2014. You can use it to review the activities covered in class:
- Creating a customized drop down list menu
- Using normal view, page layout view, page break view
- Saving as PDF
- Recording a Macro to automate repetitive tasks
- Summarizing data with Pivot Tables
- Linking with cell references: absolute, relative, name range
- Applying nested conditional functions
File developed in the advanced excel class: Advanced Excel 3-15-2014.