All Finance Training courses

When waste producers need to dispose their end product, they need to complete the pre-acceptance form, identifying as much as waste possible for SAFE transit & disposal. This session will look at how to complete the form correctly.

Cognos is a reporting tool that utilises data from CUFS to provide users with additional reports and options. This introductory course is designed for new reporters - covering everything from running a report successfully as well as a number of useful tips and shortcuts.

Note: This course is mandatory in order to attend either of the following two courses below.

• GL Part 2: Reporting in the General Ledger
• Grants Part 2: Grant reports in Cognos

What this introductory course does not do is go through in detail the outputs of each individual report. Report outputs are explained in further detail in the courses above.

Cannot make any dates? See the on-demand online version of the course. Completion of this course will count as Cognos attendance for the purpose of acceptance onto the above courses. You should ask your Key Contact to request Cognos access for you, prior to working through the on-demand material.

This is a classroom version of the General Ledger 1 course held at Greenwich House - All delegates will need to bring a laptop (docking stations, monitors, external keyboard and mice will be available in the room)

Please note - there is no parking available at Greenwich House. The Madingley Park and Ride is a 15-minute walk and the Universal Bus stops on Madingley Road.

This course enables users to learn the basics of how the General Ledger module works, how to run online account enquiries and how to process journals.

If none of the dates are suitable then there are two on-demand packages which can be completed instead.

Chart of Accounts and Account Enquiry https://www.training.cam.ac.uk/fin/event/4716069

Journals https://www.training.cam.ac.uk/fin/event/4716067

This is a classroom version of the General Ledger 2 Course held at Greenwich House - All delegates will need to bring a laptop (docking stations, monitors, external keyboard and mice will be available in the room)

Please note - there is no parking available at Greenwich House. The Madingley Park and Ride is a 15-minute walk and the Universal Bus stops on Madingley Road.

Tea and coffee will be provided during the course, lunch is not provided. There is a café at Greenwich House where you can purchase lunch. You are also welcome to bring lunch with you. You can eat your own food in the café where there are also some microwaves available for your use. We can make fridge space available if required.

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

This course will concentrate on how to use the Cognos reporting tool to help manage departmental research grants. These reports can be divided into three main categories:

• Summary financial information for Projects
• Detailed expenditure analysis
• Management reports for Grants due to close

In this course we will not access the Grants module in CUFS.

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

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