Advanced Excel 5-5-2013


Below are two files developed in the second class.

advanced excel 5-5-2013 macro and what if analysis

advanced excel 5-5-2013 various examples

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

  • Recording a Macro
  • Review vlookup
  • What if analysis
  • pmt(   ) function