All Finance Training courses

This is a classroom course held at Greenwich House - All delegates will need to bring a laptop. There are 8 docking stations with monitors, external keyboard and mice available in the room. These will be allocated on a first come first served basis, anybody else accepted will need to work solely on their laptop

This course provides an overview of the use of Microsoft SharePoint in the Finance Division to store and manage documents.

This is an in person classroom 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.

Booking onto this course can only be done through your department Key Contact

• They will confirm the level of access which you will require
• The course booking request will be made by them via the UFS responsibility access form

Once this request has been submitted by your Key Contact, you should receive an email within 1-2 working days with links to the course/(s) that you need to complete.

iProcurement Courses Available

• Introduction to iProcurement (New for R12.2)
• iProcurement: Buyers Work Centre (New for R12.2)
• iProcurement: Approving (New for R12.2)
• iProcurement: Autocreating (New for R12.2)

This in-person session will help attendees gain a better understanding of the Finance transformation project: “Enhanced Financial Transparency (EFT)”, including how it relates to other Finance transformation projects, and what it will mean for the University and staff.

This in-person session will help attendees gain a better understanding of the Finance transformation project: “Finance Systems Replacement (FSR)”, including how it relates to other Finance transformation projects, and what it will mean for the University and staff.

The University and all its staff have a responsibility to ensure that their dealings, and the supply chains of those who we trade with are free from any sort of modern slavery in compliance with the Modern Slavery Act 2015.

This online course guides you through some facts and figures relating to Modern Slavery and Human Trafficking and highlights warning signs you need to be aware of.

On-demand package - Chart of Accounts and Account Enquiry

This package covers the following areas:

• Account code structure
• Running an account enquiry
• Using summary templates
• Running a budget enquiry
• 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/mod/scorm/view.php?id=18767511

On-demand package - Cognos

This package covers the following areas:

• Setting up Cognos
• Setting up a report view
• Scheduling a report
• 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=202191

On-demand package - Journals

This package includes how to:

• Enter a journal
• Post a journal
• Find and reserve a journal
• Self-test knowledge check (completion of this will enable Finance Training to add the package to your training record)

Click here to log into the course https://www.vle.cam.ac.uk/course/view.php?id=202131

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 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.

It is run as two webinars with some pre-course reading

Webinar 1: For everyone

Webinar 2: Optional, if you are not going to be using journals it is not compulsory but may be of interest

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 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