The formulas and functions within Excel are essential tools for anyone wanting to get the most out of their data, but if you’re unfamiliar with how they work it can be frustrating trying to use them.
We show you how to write and use a wide range of formulas within Excel – from creating basic formulas to using VLOOKUP – enabling you to understand and implement these useful functions.
Is it right for me?
What will I get out of it?
By the end of the course you will be able to:
- Create different types of formula
- Use absolute references in formulas
- Use a range of Excel functions
- Use the auditing tools to see how formulas are constructed