This course is designed to provide University/Agresso specific context to existing Excel knowledge for Finance Staff.
Event Aims By the end of the session, we hope that you will understand/be able to do the following activities, in an applied context.
• Best practice for validating formulae • Statements including SUMIF/COUNTIF • Formulae including concatenate, MID, LEFT, RIGHT, ROUND • Getting data to form a string • Keyboard Shortcuts • Agresso specific tips/watch outs
Event audience This course is aimed at all finance staff who have a working knowledge of Excel and want to learn how to apply this to University/Agresso specific scenarios. The class sizes are kept very small to enable 1:1 interaction with the tutors. If you are unable to attend the course, please ensure that you cancel so that spaces can be freed up for other colleagues.
Prerequisites You will need to have the knowledge from the following Excel courses:
• Module 1 – Create a spreadsheet using simple formula • Module 2 – Formatting, autofill and functions • Module 3 – Simple IF functions and managing monster spreadsheets.