Before attending this course you are strongly recommended to attend the Microsoft Excel Functions and Formulas course  which will give you the core foundations necessary to attend and fully participate in this course. 

In this course you will learn how to work with and create more advanced functions and features that will enable you to search, match and pre-populate your data.  Using these functions will allow analysis, manipulation and comparison of your data for a variety of purposes.

Learning Outcomes:
At the completion of this course you should be able to:

• Understand formula theory
• Use functions from the statistics options such as Count If, Count A, Median, Mode, Standard Deviation, etc.
• Work with date and time functions
• Operate a range of logical functions e.g. , If, And, OR, NOT, IfError
• Create and use labels and names in a workbook
• Apply lookup functions

Pre-Requisites:
The course is designed for participants who have attended the “Microsoft Excel Functions and Formulas” course or have a good working knowledge of Microsoft Excel.

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

Pre-Requisites The class manuals are for REFERENCE ONLY and must not be removed or defaced. If you wish to download or print the manual please click this link.

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.