Taking Actions Based on Conditions | Courses for Working Professionals

Taking Actions Based on Conditions in Excel

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.

An icon showing the number 1

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.
An icon showing the number 2

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.

An icon showing the number 3

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.

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

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

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.

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

An icon of a laptop

Short lessons for a quick understanding

An icon of a clipboard

Personalized feedback on assignment

An icon of a certificate

Course Certificate on approval of assignment

An icon of a badge

Earn a Skill Badge on approval of assignment

An icon of LinkedIn

Link to add certificate to your LinkedIn profile

An icon of a calendar

Invitations to upcoming webinars

An icon of chat sign

Discussion forum for clarifying doubts

An icon of downloading a file

Downloadable worksheets for practice

Course Curriculum

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.

Thumbnail for the course Taking Actions based on Conditions showing a women writing with a pen, while the other watches her

Taking Actions based on Conditions

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


  • Lifetime access
  • Workbook to practice along
  • Support available through discussion forums
  • Assignment & quiz included
  • Earn certificate & badge on assignment approval

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.

Thumbnail for the course Taking Actions based on Conditions showing a women writing with a pen, while the other watches her

Taking Actions based on Conditions

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


  • Lifetime access
  • Workbook to practice along
  • Support available through discussion forums
  • Assignment & quiz included
  • Earn certificate & badge on assignment approval

Music Credit: bensound.com