Get to grips with Excel formulas so you can perform calculations quickly and easily.

You will learn how to:

  • Understand the principles and 'building blocks' of Excel formulas.
  • Use both mouse and keyboard commands to construct a formula.
  • Perform calculations by using both standard mathematical symbols and common built-in functions.
  • Copy formulas to different parts of your worksheet.
  • Make use of brackets to ensure calculations are carried out in the correct order.
  • Differentiate between relative and absolute cell references, and how to use each of these so your formulas always refer to the correct cells on your worksheet.
  • Refer to cells on different worksheets in your formulas, or to cells in completely separate files.
  • Pick up handy tips to save time and make life easier when you use Excel.

About the instructor

Director and Lead IT Trainer

Jane Hames

Coming from a creative background, I explain software use in a “non-techy” way. I very much focus on the big picture benefits of software use in order to save you time and get more value from the software.I have been a trainer since 1998 working mainly in the UK and occasionally in Europe. During that time, I have worked with clients from a wide range of industries including, finance, legal, creative, engineering, charities, schools, colleges, government, healthcare, police and more.I spend several days a week delivering face to face live training and regularly get feedback about how easy I am to learn from and how the training is actually really engaging and enjoyable! My courses are short because I appreciate that not everyone wants to learn everything that the software has to offer. You can pick what's most important to you at the time and select an appropriate course.Of course, there are lots of people who love Microsoft Office but there are many others who just want to make it work for them and make life easier for themselves. My aim in all of my training is help you to work more quickly, efficiently and with less frustration.Thanks for stopping by and enjoy your training!

Course Curriculum

  • 1

    Introduction

    • Welcome

    • Formulas reference sheet
  • 2

    Building an Excel formula - the basics

  • 3

    Adding more Functionality to Formulas

    • Common functions

    • Practice - common functions

    • Quiz - using common functions

    • Adding text to formulas

    • Practice - adding text to formulas

    • Quiz - adding text to formulas

    • Recap - adding functionality to formulas
  • 4

    Brackets, and how they affect Calculations

    • Why brackets are important in calculations

    • When to use brackets

    • Practice - working with brackets

    • Quiz - brackets and calculation order

    • Nested brackets

    • Practice - nested brackets

    • Quiz - nested brackets

    • Recap - brackets
  • 5

    Absolute and Relative Cell References

    • Absolute cell references

    • Practice - absolute cell references

    • Quiz - absolute and relative cell references

    • Partial absolute cell references

    • Practice - partial absolute cell references

    • Quiz - partial absolute cell references

    • Recap - absolute and relative cell references
  • 6

    Linking between Worksheets and Workbooks

    • Linking between worksheets

    • Practice - linking between worksheets

    • Quiz - linking between worksheets

    • Linking between Workbooks

    • Practice - linking between workbooks

    • Quiz - linking between workbooks

    • Recap - linking between worksheets and workbooks
  • 7

    Bonus Tips

    • Bonus tips

    • Congratulations!

You could be building your own Excel formulas today!

Sign up now