skip to navigation skip to content

Finance Training 2019-20

Programme of events provided by Finance Training
(Fri 9 Aug 2019 - Tue 21 Jul 2020)

Show:

Wed 3 Jun 2020 – Tue 21 Jul 2020

Now Today

[ Back to start of the programme ]


Wednesday 3 June 2020

09:30
How to Excel - Part 3 (For Finance Staff) CANCELLED 09:30 - 13:00 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

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

The formulas covered in this course include SUMIF, COUNTIF and INDEX MATCH which will enable 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.

10:00
Welcome to Key Travel CANCELLED 10:00 - 11:00

Key Travel is the University’s preferred supplier for travel services and has recently linked up with Booking.com. This webinar is a great opportunity to find out more about how Key Travel can support you with your travel booking needs, how you can get the best out of their Online Booking Tool and the savings you could achieve.

14:00
Cognos Introduction CANCELLED 14:00 - 16:00 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

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.

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.

Thursday 4 June 2020

10:30
VAT & the University CANCELLED 10:30 - 12:30 8 Mill Lane, Lecture Room 10

This session provides you with a simple overview of the basics and how VAT applies to the University.

Tuesday 9 June 2020

09:30
iProcurement Part 1: Getting Started in iProcurement (1 of 2) CANCELLED 09:30 - 13:00 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

We are not currently able to offer classroom courses however our suite of online courses remain available

This course teaches users how to request goods/services required for their role using the UFS iProcurement module.

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

Speak to your key contact if you need access to iProcurement in UFS

  • They will discuss whether online or classroom course is most appropriate for you
  • 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 either:

  • your allocated training username and passphrase (for online courses) or
  • your joining instructions (classroom courses).
Budgeting part 1: Introduction to budgeting in the University CANCELLED 09:30 - 12:30 Greenwich House, Heidelberg Room

This session covers the theory and practice of budgeting in the University, how to interpret department budget reports and understand the causes of overspends (and underspends) against budgets. The course refers closely to Chapter 3 of the Financial Procedures Manual

Note: This session does not cover the detailed budgeting and rules relating to individual research grants.

13:45
iProcurement Part 1: Getting Started in iProcurement (2 of 2) CANCELLED 13:45 - 15:45 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

We are not currently able to offer classroom courses however our suite of online courses remain available

This course teaches users how to request goods/services required for their role using the UFS iProcurement module.

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

Speak to your key contact if you need access to iProcurement in UFS

  • They will discuss whether online or classroom course is most appropriate for you
  • 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 either:

  • your allocated training username and passphrase (for online courses) or
  • your joining instructions (classroom courses).

Friday 12 June 2020

10:30
VAT & Research CANCELLED 10:30 - 12:30 Institute of Criminology, Room B3

This session provides you with a simple overview of the basics and how VAT applies to Research Grants including;

  • How to establish the correct VAT rate to attribute to an award when it is set up in CUFS
  • Why it is so important
  • How the VAT rate attributed affects expenditure subsequently coded to the grant

Tuesday 16 June 2020

09:30
Grants Part 3: Viewing Grants in CUFS CANCELLED 09:30 - 13:00 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

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.

Wednesday 17 June 2020

14:00
Cognos Introduction CANCELLED 14:00 - 16:00 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

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.

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.

Thursday 18 June 2020

13:00
How to Excel - Part 1 & 2 (For Finance Staff) (1 of 2) CANCELLED 13:00 - 16:00 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

NOTE This classroom-based course may not go ahead depending on the circumstances at the time. You can join our VIRTUAL course, delivered via Microsoft Teams, at https://www.training.cam.ac.uk/fin/course/HTE+1+and+2

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.

Thursday 25 June 2020

09:30
Grants Part 4: Administration of Grants in CUFS CANCELLED 09:30 - 13:00 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

This course covers the day to day and month end transactions that need to be completed using a variety of tools in CUFS.

13:30
How to Excel - Part 1 & 2 (For Finance Staff) (2 of 2) CANCELLED 13:30 - 16:30 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

NOTE This classroom-based course may not go ahead depending on the circumstances at the time. You can join our VIRTUAL course, delivered via Microsoft Teams, at https://www.training.cam.ac.uk/fin/course/HTE+1+and+2

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.

Tuesday 30 June 2020

09:30
Grants Part 2: Grant reports in Cognos CANCELLED 09:30 - 13:30 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

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.

Wednesday 1 July 2020

10:00
Grants and Indirect Costs Seminar CANCELLED 10:00 - 11:30 Greenwich House, Heidelberg Room

« Description not available »

14:00
Cognos Introduction CANCELLED 14:00 - 16:00 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

This course is currently being offered virtually, see https://www.training.cam.ac.uk/fin/course/CogIntro for details

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.

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.

Thursday 2 July 2020

09:30
AP Part 2: Matching, Amending and Foreign Invoices in Accounts Payable CANCELLED 09:30 - 16:15 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

This course builds on the knowledge gained in AP Part 1. The delegates will learn how to match invoices to purchase orders, add in freight charges and process invoices from other departments. The course also covers international payments including accounting for VAT and foreign currencies. Delegates will also learn more about month end procedures and AP Reports.

Wednesday 8 July 2020

09:30
iProcurement Part 1: Getting Started in iProcurement (1 of 2) CANCELLED 09:30 - 13:00 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

We are not currently able to offer classroom courses however our suite of online courses remain available

This course teaches users how to request goods/services required for their role using the UFS iProcurement module.

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

Speak to your key contact if you need access to iProcurement in UFS

  • They will discuss whether online or classroom course is most appropriate for you
  • 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 either:

  • your allocated training username and passphrase (for online courses) or
  • your joining instructions (classroom courses).
10:00
Welcome to Key Travel CANCELLED 10:00 - 11:00

Key Travel is the University’s preferred supplier for travel services and has recently linked up with Booking.com. This webinar is a great opportunity to find out more about how Key Travel can support you with your travel booking needs, how you can get the best out of their Online Booking Tool and the savings you could achieve.

13:45
iProcurement Part 1: Getting Started in iProcurement (2 of 2) CANCELLED 13:45 - 15:45 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

We are not currently able to offer classroom courses however our suite of online courses remain available

This course teaches users how to request goods/services required for their role using the UFS iProcurement module.

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

Speak to your key contact if you need access to iProcurement in UFS

  • They will discuss whether online or classroom course is most appropriate for you
  • 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 either:

  • your allocated training username and passphrase (for online courses) or
  • your joining instructions (classroom courses).

Thursday 9 July 2020

09:30
GL Part 1: Getting Started in the General Ledger module CANCELLED 09:30 - 12:30 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

NOTE This classroom-based course may not go ahead depending on the circumstances at the time. You can join our VIRTUAL course, delivered via Microsoft Teams, at https://www.training.cam.ac.uk/course/GL+Part+1

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.

Tuesday 14 July 2020

09:30
Budgeting part 2: Creating and monitoring budgets in CUFS and Cognos CANCELLED 09:30 - 13:00 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

This session covers how to make a financial plan, prepare it for upload to the finance system and monitor progress against the plan. It is a practical course which will look at the techniques and systems within the University that can be used for budgeting.

It is an ideal follow on from Budgeting part 1 and for those who have a good working knowledge of budgeting principles and want to develop skills in using the University budgeting tools.

Thursday 16 July 2020

09:30
GL Part 2: Reporting in the General Ledger CANCELLED 09:30 - 16:30 Finance Division, Greenwich House, Ferrara Room (IT Training Room)
  • This course provides users the opportunity to run General Ledger reports and how to interpret them when managing departmental funds.
  • You are invited to bring with you any reference documents that you may have detailing your own departmental codes.

Monday 20 July 2020

14:30
Cognos Refresher Training CANCELLED 14:30 - 16:00 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

We are not currently able to offer this as a classroom course but are offering a virtual alternative https://training.cam.ac.uk/course/CogIntro, you would be very welcome to book onto the Q&A webinar (session 2) if you would like to brush up on your skills.

Have you previously attended Cognos training but not used the reporting tool since and would like to start using the tool again? If so then this course will enable you to get re-acquainted with Cognos..

Note: What it does not do is go through in detail the outputs of each individual report. Less experienced users of the Grants and/or General Ledger modules in CUFS are recommended to attend instead one of the following courses:

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

These two courses not only cover the mechanics of running the reports but also more advice on how to interpret and use the information as well as discussion about when to use which report.

Tuesday 21 July 2020

09:30
AR Part 2: Adjustments and set up in Accounts Receivable CANCELLED 09:30 - 12:30 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

This course covers the essentials for keeping your AR accounts in order. In addition to showing you how to make corrections, receipt foreign currencies and the required month/year-end reports we will also show you how you can save time by setting up memo lines, sales persons and receivable activities for your department.

14:00
iProcurement Part 2: Month End processes in the Buyers Work Centre (1 of 2) CANCELLED 14:00 - 16:00 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

NOTE This classroom-based course will not be going ahead. You can book for our VIRTUAL course, which will be delivered online. More details can be found at https://www.training.cam.ac.uk/fin/course/iproc2

This course covers the various month-end processes that need to be completed within the iProcurement module.

16:00
iProcurement Part 2: Month End processes in the Buyers Work Centre (2 of 2) CANCELLED 16:00 - 16:30 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

NOTE This classroom-based course will not be going ahead. You can book for our VIRTUAL course, which will be delivered online. More details can be found at https://www.training.cam.ac.uk/fin/course/iproc2

This course covers the various month-end processes that need to be completed within the iProcurement module.