Excel 2019 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 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.

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
11/13/2020 1:00PM - 2:00PM Online LIVE LNL
12/15/2020 10:00AM - 11:00AM Online LIVE LNL
12/16/2020 10:00AM - 11:00AM Online LIVE LNL

Class times are listed Central time

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