Carnegie Mellon University

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]