When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Development
SkillShare logo

Excel Formulas & Functions Part 3: Conditional Statements

Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.

     0 |
  • Reviews ( 0 )
Free
Excel Formulas & Functions Part 3: Conditional Statements

Related Courses

This Course Includes

  • iconskillshare
  • icon0 (0 reviews )
  • icon31 minutes
  • iconenglish
  • iconOnline - Self Paced
  • iconcourse
  • iconSkillShare

About Excel Formulas & Functions Part 3: Conditional Statements

Introduction To Logical Operators

Anatomy of the IF Statement

Nested IF Statements

AND/OR Operators

NOT vs. "<>"

Fixing Errors with IFERROR

Common IS Statements

Logical Operators Homework

What You Will Learn?

  • This course is part 3 of a 9-part series on Excel Formulas & Functions: from basic to advanced..
  • Conditional functions and logical operators allow you to design complex formulas built on IF/THEN logic. In this section we’ll introduce each of the key conditional functions (IF, AND, OR, and NOT) and practice combining them with logical operators to help organize and categorize raw data..
  • About the Excel Formulas & Functions Series:.
  • In this series, you will develop tools to transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. Courses cover 75+ formulas, and feature hands-on, contextual demos and practice exercises designed to help you not only memorize formula syntax, but to think like Excel..
  • You'll learn how to write complex, powerful functions from scratch, allowing you to:.
  • If you're looking for the ONE series covering all of the advanced formulas and functions that you need to become an absolute Excel rock star, you've found it!.