Logical Functions in Excel Tutorial

Explore logical functions in Excel 2021 through this 45-minute tutorial designed for beginners and those refreshing their skills. Learn about IF, IFS, COUNTIF, and SUMIF functions, starting with simple logical tests and progressing to more complex operations. Discover how to add meaning using IF statements, perform logical calculations with SUM and IF, work with AND and OR operators, and create nested IF statements. Delve into the IFS function, COUNTIF(S), SUMIF(S), and AVERAGEIF(S) for advanced data analysis. Conclude with error-checking techniques using IFNA and IFERROR. Follow along with the provided exercise file to practice these essential Excel skills in a hands-on manner.

- What are Logical Functions?
- Simple Logical Tests
- Adding Meaning using IF Statements
- Using SUM and IF to Perform Logical Calculations
- Working with AND and OR
- Nested IF Statements
- The IFS Functions
- COUNTIFS, SUMIFS, and AVERAGEIFS
- Error Checking with IFNA and IFERROR