All Finance Training courses

In order for the University to carry out financial transactions involving the acceptance of payment cards from customers we have to comply with standards as laid down by the Payment Card Industry (PCI) Security Council.

This short, online course will provide users with the information they need to process card receipts securely and in accordance with the PCI Security Standards.

This short online course will provide you with an overview of the way petty cash operates. This includes:

• An overview of petty cash
• Getting started with petty cash
• Day-to-day use and accounting for petty cash
• How to deal with any problems

Setting up a new supplier

This brief course, intended for key contacts, will explain the process of setting up a supplier, especially the documents that are required before the supplier can be set up by the supplier database team.

• Self-test knowledge check (successful completion of this knowledge check will enable Finance Training to add this to your training record)

Click on this link to access the course https://www.vle.cam.ac.uk/course/view.php?id=233591

This is an opportunity for the members of the University to go one-on-one with Tableau experts across the Business Information and Strategic Insights Team, who can help you solve challenges.

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.

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