Advanced Excel 3-15-2014

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:

1. Creating a customized drop down list menu
2. Using normal view, page layout view, page break view
3. Saving as PDF
4. Recording a Macro to automate repetitive tasks
5. Summarizing data with Pivot Tables
6. Linking with cell references:  absolute, relative, name range
7. Applying nested conditional functions

File developed in the advanced excel class:  Advanced Excel 3-15-2014.