Excel 365 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 use logical operators and work with logical functions such as IF, AND, OR, and NOT.
  • * 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.
  • * New Functions in Excel 365/2019 - Learn about the new IFS and SWITCH functions.
  • * Handling Errors with Functions - Learn how use the IFNA and IFERROR functions to circumvent errors.