Carnegie Mellon University
Finance Division  ›  Finance Training  ›  Training Catalog  ›  Instructor Led  ›  Excel VLookups and Pivot Tables with Financial Data

FIN – Excel VLookups and Pivot Tables with Financial Data

This hands-on computer class provides detailed instruction on how to create an Excel VLookup and Pivot Table. Participants will also learn navigation, and common terminology and techniques used with these functions within Excel.

Course Materials

Advanced Excel - VLOOKUP, HLOOKUP and Pivot Tables [.pdf]

Registration

  1. Access FocusU
  2. Log into the system with your Andrew ID and Password
  3. Use the search bar to search for the desired course name
  4. Select the course you would like to take
  5. Locate the session you would like to attend and click “Register”
  6. Optional: to add to your calendar click “Add to Calendar” and choose Google (online)