In this course, you will learn how to create Formulas (manually created) and Functions (pre-defined formula that performs calculations using specific vales in a particular order).
By utilising these principles you will then be able to analyse data within your spreadsheets. By attending this course, you will then be able to build on these foundations to be able to use the more advanced functions of Microsoft Excel, in preparation for the Microsoft Excel More Functions course.
At the completion of this course you should be able to:
Creating formulas to add, subtract, divide and multiply
Writing formulas that reference cells in different worksheets and workbooks
Using the Function Wizard to find the sum, average, highest value and lowest value
Recognise when and how to use the two types of cell referencing, e.g. absolute and relative
Understanding error messages
Checking for and understanding errors using the Formula Auditing feature