All Finance Training courses

This course provides users the opportunity to run General Ledger reports and how to interpret them when managing departmental funds.

This course provides an overview of the Grants module in CUFS. The course will cover how you can view your projects and awards, check budgets, perform on-line queries and run some CUFS reports.

The course material will be split over 2 webinars on consecutive days

This course looks at the tasks required at month end to manage your grants and at transactions that need to be completed using a variety of tools in CUFS. It also looks at preparing grants for closing.

This course will enable the participants to practice existing spreadsheet skills and develop more advanced skills within the context of UFS data. There will be the opportunity to extract data from the system and learn to manipulate, analyse and use it for reporting purposes. The course runs over two sessions and participants will need to attend both of these sessions.

The session will look at more advanced formulas and macros using the recorder and VBA tools.

The formulas covered in this course include SUMIF and COUNTIF which will allow the user to quickly summarise data.

Macros will enable the user to automate tasks within excel. During this session, we will use the example of needing to analyse, sort, split and send data to specific email contacts. Users will be introduced to a series of macros to reduce this process to a few simple steps.

The session will run on Teams and delegates must be able to access Excel during the session