Finance Training 2019-20

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

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

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.

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.

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.

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.

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.

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.

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

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.

« Description not available »

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.

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.

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.

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

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

NOTE This classroom-based course is not going ahead but 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.

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.

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.

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.

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.

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.

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

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.

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

• https://www.training.cam.ac.uk/fin/event/3087715 for buyers
• https://www.training.cam.ac.uk/fin/event/3087769 for requisitioners

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