Excel 2016 Calculating and Analyzing Data with IF Statements

 One Hour
Delivery Methods

In this course, students will learn how to apply conditional logic to data using formulas, which allows for in-depth data analysis. This can mean anything from checking whether ranges of data meet certain criteria, to applying functions to specific categories of the data, to executing functions only under particular circumstances.


Upcoming Class Dates and Times

Oh Snap!
There are no dates listed.
Please contact us to get something scheduled.

Who Should Attend

This course is intended for intermediate users, assuming a fair amount of fluency is navigating the interface and writing formulas. The lessons in this course can be difficult for beginners both conceptually and technically, but all students can benefit from knowing how to work with conditional logic, so this course is encouraged for anyone up to the challenge.

Course Objectives

    This course aims to help students perform more in-depth, nuanced analysis of their data. Students will learn about a few different types of logical functions and when to use them as well as how to combine logical functions with other functions. By the end of this course, you will be experienced in both applying conditional logic and in writing formulas.


1 - Lessons
  • Summarize Data with SUMIF, COUNTIF, and AVERAGEIF - Learn how to answer specific questions about specific categories of data using conditional summary functions.
  • Analyzing with Logical Functions - Learn how to answer questions about specific entries in a dataset by checking whether they meet specified criteria.
  • Using Nested IF Functions - Learn how to nest IF functions inside other IF functions and combine them with other functions to create advanced logical tests.
  • Handling Errors with the IFERROR Function - Learn how to cover your bases by creating conditional logic to circumvent errors.