 # Master Class on Logical Formulas

Course Fee - INR 999 /- only

## Why it's important!

Logical Functions are some of the most popular and useful tools in Excel as they help us to automate tasks in our spreadsheets. Logical formulas can test values in other cells and perform actions depending upon the result of the test. A small topping of logical formula can give lot of power to any formula. Be it VLOOKUP, TEXT formulas, Date formulas etc. Let's explore these functions and enhance our excel skills.

## COURSE CURRICULUM

Master Class on Logical Formulas
• Master Class on Logical Formulas

## Salient Features of the Course

👉 Let's understand concept behind it - Why should we learn

👉 Let's understand most used logical formula *IF*

👉 How to Create NESTED IF formulas, where we need it

👉 Creating IF condition when we have multiple conditions and want all conditions TRUE (*AND* Condition)

👉 Creating IF condition when we have multiple conditions and want Either of the condition as TRUE (*OR* Condition)

👉 Let's understand IFERROR and IFNA, what is the difference between both.

👉 How to reverse the logic of function (*NOT*) when to use it

👉 Avoid Nested IF and let's understa new easy function *IFS*

👉 Lets explore new function *SWITCH* - when to use it

👉 Some interesting Business Cases using logical functions:

1. Payment Due Date reminders to Customers
2. Student result based on marks - Excellent, Good, Average, Fail
3. An interesting business case based on multiple logical formulas
4. Creation of Income Tax Dashboard based on different income slabs/Age/Gender with single formula
5. Let's create a game *"Roll the Dice"* with the help of logical formula
6. Use of COUNTIFS, SUMIFS, AVERAGEIFS, MAXIFS, MINIFS

👉 Q&A

## MORE PERKS

CERTIFICATION
Obtain a digital certificate for completing this course

WORKING FILES