The University of North Carolina at Chapel Hill

 

Excel: IF Statements

An Introduction to using IF, IFS, and SumIF in excel.

What is the Excel IF Statement training?

This training is a basic introduction to IF Statements in Excel. 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:

  • How to create a simple IF Statement
  • Other types of IF functions: SUMIF, COUNTIF, and IFERROR
  • How to create nested IF Statements
  • Using IFERROR


Who should attend this training?

You should attend this training if you have never used IF Statements or have very limited experience with IF Statements. In addition, you should have some foundational knowledge of Excel, including how to write basic formulas (such as SUM).

Date:  1/17/2023, 1:00 PM – 3:00 PM
Location: Zoom Video