Master Class on Logical Formulas 

Course Fee - INR 500

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
Downloadable Working File
  • Downloadable Working File

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
Get access to the working and business solution files

90 DAYS ACCESS
Get access to the webinar recording for 3 months

INTERACTIVE Q/A
Get answers to all your queries

SUBSCRIBE

CONNECT WITH US