Excel - Functional Logic

Price
$49.00
Duration
 One Hour
Delivery Methods
 VILT

In this class you will learn how to apply conditional logic to data using formulas, which allows for in-depth data analysis. Check a range of data meet certain criteria, apply functions to specific data categories, functions and learn when and why to execute functions.

 

Upcoming Class Dates and Times

Aug 30, 2022
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Sep 22, 2022
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Oct 14, 2022
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR
Nov 10, 2022
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR
Nov 30, 2022
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR
Dec 27, 2022
10:00AM - 11:00AM Central
One Hour
Virtual Instructor Led
 GTR

Agenda

1 - Outline
  • Summarize data with SUMIF, COUNTIF, and AVERAGEIF
  • Answer specific questions about specific categories of data using conditional summary functions.
  • Analyze with logical functions and use logical operators and work with logical functions such as if, and, or, and not.
  • Use nested if functions inside other if functions and combine them with other functions to create advanced logical tests.
  • New functions and learn about ifs and switch functions.
  • Handle errors with functions and use the IFNA and IFERROR functions to circumvent errors.