Excel: Formulae and functions
Learn how to navigate Microsoft Excel and utilitise the various formulae and functions.
About the workshop
This course introduces formulae and functions in Excel. Participants should be confident with using the Windows environment and already have some experience of using Microsoft Office. They should have a basic understanding of Microsoft Excel including how to navigate in Excel and use the Ribbon, use Backstage View and Options, select cells, rows, columns and ranges, and format and align text and numbers in cells.
After completing this course, you will be able to:
- create and edit formulae
- use AutoSum
- understand relative and absolute referencing
- use the Formulas tab
- create Range Names and use them in formulae
- insert functions in Excel