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
- Webinar - Logical Formulas
- Working Files - (Download)
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:
- Payment Due Date reminders to Customers
- Student result based on marks - Excellent, Good, Average, Fail
- An interesting business case based on multiple logical formulas
- Creation of Income Tax Dashboard based on different income slabs/Age/Gender with single formula
- Let's create a game *"Roll the Dice"* with the help of logical formula
- Use of COUNTIFS, SUMIFS, AVERAGEIFS, MAXIFS, MINIFS
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
