Microsoft Excel: Functions and Formulas
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:
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.
To participate in this session you will need to have the latest version of Microsoft Office installed on your device before the session starts. If you are unsure if you have the latest version please see the Install Office Updates web page. This session will focus on the Windows version of Microsoft Office.
If you require support please see the IT Service Desk web page for more help as technical support cannot be offered by the course leader.
Course Leader input, demonstrations, and hands-on practical sessions.
You are required to attend the whole of the course, this is not a "drop in" session.
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 firstname.lastname@example.org or see https://workspace.nottingham.ac.uk/display/GDPR/Information+Compliance+Team+Home for more information.