Microsoft Excel | Basics of formulas
This module introduces basic formulas used in Microsoft Excel, which are important for completing mathematical equations and analysing data.
What you'll learn
By the end of this module, you should:
- Know how to create and use simple formulas like SUM, AVERAGE, MIN, and MAX
- Understand how to use cell references in formulas
- Be able to do basic mathematical operations like adding, subtracting, multiplying, and dividing in Microsoft Excel
- Use formulas to analyse and calculate data
- Feel confident using Microsoft Excel for simple calculations.
Time required - 10 - 15 mins
Gain the knowledge
You'll learn how to get started with formulas, understand some commonly used functions and have them do some basic maths for you.
Unlock new skills
After completing this module, you'll feel confident using the formulas SUM, AVERAGE, MAX and MIN and cell referencing.
Earn your badge
We'll check your knowledge at the end of the module. When you pass you'll earn your 'Basics of formulas' course 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.