Carnegie Mellon University

Excel Program

The Office of Human Resources partners with the Community College of Allegheny County to offer an Excel training program. Developed in collaboration with the Finance Division, this program equips employees with the essential Excel skills needed to thrive in CMU's business environment. The program consists of two concise courses designed for practical application. By focusing on key concepts, participants gain the confidence to tackle real-world tasks within their roles.

Excel Foundations Course Topics

  • Getting started:
    • Selection shortcuts
    • Auto-fill
    • Named ranges
    • Number formatting
  • Data formatting:
    • Basic tables
    • Conditional formatting
    • Charts
    • Pivot tables

Advanced Excel Course Topics

  • Functions and formulas:
    • Relative vs. absolute references
    • Basic function syntax (writing functions)
    • Finance functions
    • Logical functions
    • IF and nested IF statements
    • Macros/VBA
  • Reference functions:
    • VLookup/HLookup functions
    • Index-match functions
    • Reference Functions
    • VLookup/HLookup functions
    • Index-match functions