By the end of this course, you will be able to
The professional skills in using the Excel program specifically related to the management of mathematical and statistical operations that require addressing a set of conditions to extract results
The SIMPLE IF and how it is used to run a logical test and returns a specified value if the logical test is TRUE and another if the condition is not met for a result of FALSE.
The NESTED IF function and how it is used to test more than one condition, in addition to the Complex IF function which tests two or more conditions between which the plural link AND, or the selection link OR.
Course details
- 2 h 38 m/28 lessons
- Last updated: 31/12/2022
- 22 learning resources
- Course completion certificate
Course Content
Preparing Sheet Before Typing
SIMPLE IF - Numbers Conditions
Formulas and Basic Functions
Preparing Sheet Before Typing
Formulas and Basic Functions
SIMPLE IF - Numbers Conditions
SIMPLE IF - Text Conditions
SIMPLE IF - Formula Conditions
SIMPLE IF - Text Logical Test
SIMPLE IF - Using Function Wizard
Case Study 1
Case Study 2
Case Study 3
Nested If - Number Conditions
Nested If - Formula Conditions
Nested If - Text Conditions
Ifs Function
Ifs Function Using Wizard
IfNA Function To Resolve #N/A! Error
Complex If - Operation And1
Complex If - Operation And2
Complex If - Operation Or
Complex If with Nested If 2in1
#### Error
#Value Error
#Name Error
#Div/0 Error
#Ref Error
If Error Function
If Error with If Function
Conclusion
About this course
Logical Operations in Excel could act as an additional brain for you, it enables you to organize different types of information using only one formula. In this course, we will learn the skills of managing mathematical and statistical operations that require processing a set of conditions to extract results, through a group of conditional functions such as (simple if – nested if – complex if – ifs – ifna – iferror), and we will also learn about the different forms of errors that appears while working on the Excel file and knowing its causes and how to resolve it.
Course requirements and prerequisites
There are no requirements for this course. Your interest in the topic and your commitment to learning are all you need to achieve the utmost benefit from this course.
Mentor
Abdelrahman Hashem
Organizational Skills Trainer
15,278 Learners
8 Courses