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.

Learning Outcomes:

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

Pre-Requisites:

The course is designed for participants who have attended the “Microsoft Excel Foundation of Spreadsheet Creation” course or have a good working knowledge of this software.

Process:

Course Leader input, demonstrations and hands-on practical sessions.

Pre-Requisites The class training manuals are for REFERENCE ONLY and must not be removed or defaced. You can download or print this manual and bring it with you to the training course.

If you are not already familiar with these policies, you are strongly advised to read them:
Click here to view the University Data Handling Policy
Click here to view the University Data Protection Policy

If you have any questions about the content of these policies then please contact infosec@nottingham.ac.uk or see https://workspace.nottingham.ac.uk/display/GDPR/Information+Compliance+Team+Home for more information.