Taking Actions Based on Conditions | Courses for Working Professionals

Taking Actions Based on Conditions in Excel

IF, Nested IF, IFERROR, SUMIFS, COUNTIFS, MAXIFS & More. TRANSPOSE, UNIQUE & Evaluate Formulas

What will you learn in this course?

You will learn functions that help you take decisions based on fulfilment of conditions or criteria.

IF & nested IF

You'll be able to write simple IF statements and instruct actions Excel needs to take based on values, criteria or conditions.

In addition, you'll be able to evaluate multiple conditions or work through ranges using nested IF statements.

Aggregate functions

You'll learn the foundation formulas for analysis. These include variants of COUNTIFS, SUMIFS, and AVERAGEIFS.

In addition, you can also learn the functions UNIQUE, TRANSPOSE, MAXIFS and MINIFS, introduced in Excel 365.

Removing errors

Errors can come in due to incorrect formulas or inconsistent, missing data.

You'll learn how to handle errors using the IFERROR function and eliminating errors using the Evaluate Formulas functionality.

How will this course help you?

In this course, we will go through a series of business scenarios and strengthen our understanding in the areas of decisions and making choices in Excel.

Decisions & choices

You'll be able to write simple IF statements and instruct actions Excel needs to take based on values, criteria or conditions.

Aggregates on decisions

You'll be able to sift through large sets of data and perform aggregate functions like addition, average, counting based on conditions.

Managing errors

Sometimes we see errors in Excel while writing formulas. These could be due to missing or incorrect data. Or, these could be because of erroneous formulas.

You'll learn a simple method to fool-proof your spreadsheets and manage these errors elegantly.

Validate formulas

Sometimes, while writing complex formulas, we face errors or we receive incorrect answers.

You'll learn how to use the EVALUATE function in Excel to go through the formula step-by-step and identify the source of error.

A young man wearing headphones and looking at a laptop with focus

What all does this course include?

You'll have access to all these benefits once you enroll in this course

Short lessons for a quick understanding

Personalized feedback on assignment

Course Certificate on approval of assignment

Earn a Skill Badge on approval of assignment

Link to add certificate to your LinkedIn profile

Invitations to upcoming webinars

Discussion forum for clarifying doubts

Downloadable worksheets for practice

Course Curriculum

Taking Actions Based on Fulfilment of Conditions
7 Lessons
- Download the resource file
  Start
- Evaluate Conditions using IF statements
  Start
- Evaluate Multiple Conditions Using Nested IF Statements + Bonus: Learn How to Evaluate Formulas?
  Start
- Manage calculation errors and present data without errors
  Start
- Add values on fulfilment of condition using the SUMIF formula
  Start
- Add values on fulfilment of multiple conditions using the SUMIFS formula Bonus: UNIQUE and TRANSPOSE
  Start
- Actions based on fulfilment of conditions using formulas such as COUNTIF, COUNTIFS, AVERAGEIFS, MAXIFS
  Start
Wrap-up
3 Lessons
- Quiz - Taking Actions Based on Fulfilment of Conditions
  Start
- Final Words
  Start
- Assignment
  Start

Get access to the course

Master the ability to use IF statements, work on aggregate functions and manage errors in your spreadsheets.

These are essential skills in Excel which are required whether you want to perform basic operations or use Excel for complex computation.