Microsoft Excel | Logical functions
Learn the basics of logical functions in Microsoft Excel, including IF, AND and OR functions. This module will guide you through automating decisions and simplifying data management.
What you'll learn
By the end of this module, you should:
- Efficiently use IF, AND, OR functions
- Correctly apply syntax for error-free formulas
- Create advanced, condition-based formulas
- Analyse real-world data through practical challenges.
Time required - 10 - 15 mins
Gain the knowledge
You'll learn how to use logical functions for smarter decision-making in Microsoft Excel.
Unlock new skills
After completing this module, you'll feel confident using the formulas IF, AND and OR to enhance your data analysis.
Earn your badge
We'll check your knowledge at the end of the module. When you pass you'll earn your 'Logical formulas' module badge that will show off what you've learned.
How to get started
You'll need to register for your free account. Once you have, you can start your digital learning journey.
We'll help you set learning goals each week that allow you to gain new skills. As you do, you'll earn badges to show off what you know.
The more you do, the more you'll earn. Let's get started!
Already registered?
If you've already got an account with us, the learning is ready for you to begin.
This training is specifically designed for Windows devices.
If you're using an Apple (macOS) device, please refer to the appropriate shortcuts and instructions for your system. Click here for Apple device shortcuts and guidance.
