skip to navigation skip to content

Finance Training

Finance Training course timetable

Show:

Thu 14 Nov 2019 – Mon 9 Dec 2019

Now Today



Thursday 14 November 2019

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

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.

Friday 15 November 2019

10:00
VAT & Research POSTPONED 10:00 - 12:00 Greenwich House, Heidelberg Room

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
13:15
Finance Division Knowledge Bites - Finance Business Transformation Project new Finished 13:15 - 14:00 Greenwich House, Cairo Room

An overview of the Finance Business Transformation Programme (FBTP), a large scale initiative which aims to shape and enhance Finance’s processes and tools of the future. Those working in Finance roles and all users of Finance services will be crucial to making the programme a success and, as well as giving you the chance to learn about the FBTP during this session, we would also welcome your views and thoughts.

Monday 18 November 2019

09:30
Tableau for Explorers - Research Finished 09:30 - 12:30 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

Tableau Server is an online application available to all members of the university to access Tableau dashboards and visualisations

Tableau Explorer is intermediate level access to Tableau Server and allows you to view, interact and edit Tableau content.

Tuesday 19 November 2019

09:30
How to Excel - Part 3 (For Finance Staff) Finished 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.

Wednesday 20 November 2019

09:30
AAT Level 3 Diploma in Accounting 2019-20 charged (8 of 24) Finished 09:30 - 16:30 First Intuition


The AAT Level 3, Diploma in Accounting, introduces to students to more complex financial processes and accounting tasks, the principles of VAT, professional ethics and develops their spreadsheet skills.

In addition to applying for a provisional place here, you will need to complete an application form which can be found on our website https://www.finance.admin.cam.ac.uk/training/professional-qualifications/aat/university-programme
GL Part 2: Reporting in the General Ledger Finished 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.

10:00
Finance Division Taster Sessions - Central & Research Accounting Finished 10:00 - 11:00 Greenwich House, Heidelberg Room

An overview of the role of Central and Research Accounting and a taster of the range of the activities that they are involved with.

This session is a required pre-requisite for attendance on the detailed walk-through sessions for any of the following topics:

  • Fixed Assets
  • Lynxvale Limited Property Accounting
  • Fee collection
  • Trust Funds
  • Research Accounting

Thursday 21 November 2019

09:00
Finance Division Taster Sessions - Treasury & Investments (Investments) Finished 09:00 - 12:00 Finance Division, At Participant's Desk

To provide an opportunity for someone from elsewhere in Fin Division to spend half a day in the Treasury & Investments Team to get an overview and appreciation of what they do. The Treasury & Investments team are offering two sessions, one on Treasury and one on Investments. Ideally the Treasury session should be attended before this one (Investments) however this is not a pre-requisite.

14:00
Tax Exemptions - Medically Exempt new Finished 14:00 - 14:45 Department of Biochemistry, Hopkins Seminar Room One

A briefing session to remind iProc buyers/requisitioners of when departments are eligible to apply/claim medical exemption relief from VAT. This area of VAT is being highlighted at the moment as it is a current focus of HMRC. Additionally, some suppliers are reviewing their controls over the application of Medical Exemption, and are therefore checking our use of ME0% on recent orders.

Monday 25 November 2019

09:15
Finance Division Taster Sessions - Accounts Payable & Cashier Finished 09:15 - 12:15 Finance Division, At Participant's Desk

An opportunity for others within the Finance Division to spend some time with the Accounting Services Team to gain an overview of their roles and a greater appreciation of what they do.

Tuesday 26 November 2019

09:15
Finance Division Taster Sessions - Helpdesk & Cash Management CANCELLED 09:15 - 12:00 Finance Division, At Participant's Desk

An opportunity for others within the Finance Division to spend some time with the Accounting Services Team to gain an overview of their roles and a greater appreciation of what they do.

09:30
Budgeting part 2: Creating and monitoring budgets in CUFS and Cognos (Formerly Managing the Budget - Part 2) 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 Managing the Budget 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.

14:00
Getting Started in Cognos CANCELLED 14:00 - 15:30 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 master class is designed to get existing CUFS users going with the reporting tool. It covers everything from running a report successfully as well as a number of useful tips and shortcuts.

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.

Wednesday 27 November 2019

09:30
AAT Level 3 Diploma in Accounting 2019-20 charged (9 of 24) Finished 09:30 - 16:30 First Intuition


The AAT Level 3, Diploma in Accounting, introduces to students to more complex financial processes and accounting tasks, the principles of VAT, professional ethics and develops their spreadsheet skills.

In addition to applying for a provisional place here, you will need to complete an application form which can be found on our website https://www.finance.admin.cam.ac.uk/training/professional-qualifications/aat/university-programme

Thursday 28 November 2019

09:30
Grants Part 2: Grant reports in Cognos Finished 09:30 - 13:00 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.

Monday 2 December 2019

09:45
Tax Exemptions - Medically Exempt new Finished 09:45 - 10:30 Clinical School, Seminar Room 12

A briefing session to remind iProc buyers/requisitioners of when departments are eligible to apply/claim medical exemption relief from VAT. This area of VAT is being highlighted at the moment as it is a current focus of HMRC. Additionally, some suppliers are reviewing their controls over the application of Medical Exemption, and are therefore checking our use of ME0% on recent orders.

11:00
Tax Exemptions - Medically Exempt new Finished 11:00 - 11:45 Clinical School, Seminar Room 12

A briefing session to remind iProc buyers/requisitioners of when departments are eligible to apply/claim medical exemption relief from VAT. This area of VAT is being highlighted at the moment as it is a current focus of HMRC. Additionally, some suppliers are reviewing their controls over the application of Medical Exemption, and are therefore checking our use of ME0% on recent orders.

Tuesday 3 December 2019

09:00
Finance Division Taster Sessions - Shared Services Finished 09:00 - 12:30 Finance Division, At Participant's Desk

An opportunity to gain an insight into the work of the Shared Services Finance team and to understand and have an appreciation of the interrelationships with other areas and the demands and challenges faced.

09:30
AP Part 2: Matching, Amending and Foreign Invoices in Accounts Payable Finished 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 4 December 2019

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

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.

Thursday 5 December 2019

09:30

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.

14:00
Finance Division Taster Sessions - Finance Managers Group Finished 14:00 - 17:00 17 Mill Lane, Seminar Room G

This session led by Finance Managers and Advisers will provide attendees with an insight into their roles and how different Schools operate.

The session will be equally split between two different School teams:

  • School of Physical Sciences
  • School of Humanities & Social Sciences

to reflect the different approaches and demands of different sectors within the University.

14:15
Tax Exemptions - Medically Exempt new Finished 14:15 - 15:00 Greenwich House, Cairo Room

A briefing session to remind iProc buyers/requisitioners of when departments are eligible to apply/claim medical exemption relief from VAT. This area of VAT is being highlighted at the moment as it is a current focus of HMRC. Additionally, some suppliers are reviewing their controls over the application of Medical Exemption, and are therefore checking our use of ME0% on recent orders.

Monday 9 December 2019

14:00
Finance Division Taster Sessions - Greenwich House Operational Support Team (GHOST) CANCELLED 14:00 - 15:00 Finance Division, At Participant's Desk

An opportunity for others within the Finance Division to spend some time with GHOST to gain an overview of their roles and a greater appreciation of what they do.