The University of North Carolina at Chapel Hill


Excel: Intro to Formulas

An introduction to creating formulas and utilizing excel functions for calculations and reports. Functions will include, sum, sumif, Vlookup, and more.

What is the Excel Functions training?

This training is a very basic introduction to creating formulas and using Excel's built in functions. In addition, you will learn some tips and tricks that can save you time on the job.

What will you cover in this training?

We will cover the following topics:

  • The proper syntax for formulas and functions
  • How to use absolute and relative cell references
  • Specific Functions and their uses:
    • Sum and Sumif
    • Round
    • Average
    • and more!
  • How to use VLOOKUP (very basic intro)


Who should attend this training?

You should attend this training if you are unfamiliar with how to create formulas or how to identify useful functions in excel. In addition, you should have some foundational knowledge of Excel, specifically on how to navigate and work in excel. 

Date:  2/28/2023, 10:00 AM – 12:00 PM
Location: Zoom Video