Excel 2016 Calculating and Analyzing Data with IF Statements

Course Overview

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.

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.

Course Outline

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.

Price: $49.95

Class times are listed Central time.

To sort by location or date, click the ‘When’ and ‘Where’ column headings.

Cart When Time Where How
12/01/2020 8:00AM - 9:00AM Online LIVE LNL

Class times are listed Central time

This class is part of our LearnNow Pass. Click here for more details.