Advanced Excel 6-22-2013


Below are links to the three files developed in the advanced excel class:

  1. Advanced Excel 6-22-2013 vehicle, shoes, grade book
  2. Advanced Excel 6-22-2013 scuba ratings in pivot table
  3. Advanced Excel 6-22-2013 links

They have been provided to review the work done in class.

Recording a Macro
Review vlookup
Summarizing data with Pivot Tables
Links using hyperlinks and name ranges