skip to navigation skip to content
- Select training provider - (Finance Training)

Finance Training

Finance Training course timetable

Show:

Wed 20 Dec 2017 – Tue 23 Jan 2018

Now Today



Wednesday 20 December 2017

09:30
How to Excel new (2 of 2) Finished 09:30 - 13:00 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

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

Topics covered:

  • Extracting data from CUFS and COGNOS
  • Basic formatting
  • Basic formulas
  • Navigating large spreadsheets
  • Advanced formulas
  • Conditional formatting
  • Data validation
  • Protecting cells and sheets
  • Lookup function
  • Pivot tables
  • Charts and graphs
  • Using data in other documents

Tuesday 9 January 2018

09:30
AAT Level 3 Diploma in Accounting 2017-18 new charged (12 of 26) Finished 09:30 - 16:30 Greenwich House, Heidelberg Room


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
iProcurement Part 1: Getting Started in iProcurement (1 of 2) Finished 09:30 - 13:00 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

This course is aimed at new iProcurement users and provides an introduction to using iProcurement for creating requisitions and purchase orders.

iProcurement is also available as an online course for you to learn in your own time. Choose from our available online options if you are unable to make the classroom dates or prefer to study in this way.

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

This course is aimed at new iProcurement users and provides an introduction to using iProcurement for creating requisitions and purchase orders.

iProcurement is also available as an online course for you to learn in your own time. Choose from our available online options if you are unable to make the classroom dates or prefer to study in this way.

Wednesday 10 January 2018

10:00
VAT for the ROO and Research Accounting new CANCELLED 10:00 - 12:00 Greenwich House, Cairo Room

A bespoke session to provide an overview and guidance on 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:30
AR Part 2: Adjustments and Set Up in Accounts Receivable Finished 13:30 - 16: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.

Thursday 11 January 2018

09:30
First Steps in Procurement 2017 new charged (2 of 6) Finished 09:30 - 16:30 Greenwich House, Edmonton Room

This course has been specifically designed by the Training team for the University. It is aligned with the old level 2 course that was offered by the Chartered Institute of Procurement & Supply (CIPS) and is structured to cover the same introductory concepts and techniques.

All participants will be required to complete an application form which can be found on our website https://www.finance.admin.cam.ac.uk/training/professional-qualification/cips/first-steps-procurement

AAT Level 4, Professional Diploma in accounting.

Students will be placed on the public day release programme with the external provider

Once you have registered here you will need to complete the application form at the back of the briefing pack. This pack is available on our website https://www.finance.admin.cam.ac.uk/training/professional-qualifications/aat/university-programme The remaining dates will be added once they have been confirmed

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 12 January 2018

09:00

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.

15:00
GL Coaching Session new Finished 15:00 - 17:30 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

« Description not available »

Tuesday 16 January 2018

09:30
AAT Level 3 Diploma in Accounting 2017-18 new charged (13 of 26) Finished 09:30 - 16:30 Greenwich House, Heidelberg Room


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
AAT Level 4 Professional Diploma in Accounting 2017-18 charged (10 of 37) Finished 09:30 - 16:30

AAT Level 4, Professional Diploma in accounting.

Students will be placed on the public day release programme with the external provider

Once you have registered here you will need to complete the application form at the back of the briefing pack. This pack is available on our website https://www.finance.admin.cam.ac.uk/training/professional-qualifications/aat/university-programme The remaining dates will be added once they have been confirmed

AR Part 3 - Customer Set-up in Accounts Receivable new CANCELLED 09:30 - 12:00 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

With the introduction of e-Sales, and the centralising of setting up customers in Accounts Receivable, there is little need for departments to set up or amend customers in AR. This central service is designed to reduce the administrative burden on the departments, eliminate customer duplication, ensure consistent set up and identify situations where credit checks might be required or where eSales (WPM) would be a better alternative to conventional invoicing.

If a department wishes to maintain this set up within the department a new AR Manager responsibility will be required. To receive this responsibility you must attend this compulsory master class. The master class will provide you with the opportunity to practice setting up and amending customers within CUFS. Upon completion of the course you will receive your AR Manager responsibility.

Please Note: Departments are encouraged to either use e-Sales, or take advantage of this central service. There is no need to register; simply complete and email the form through as and when you have a new customer or amendment request (http://www.finance.admin.cam.ac.uk/staff-and-departmental-services/forms)

eSales Departments are encouraged to consider if using the CUFS module to set up and raise invoices to private individuals is the best option and whether it would be more appropriate to use the University’s online store. For more information please see the eSales website or watch the three short videos below which give an overview of what the eSales system looks like and what it can do.

Introduction to the Online Store

Events and Conferences in the Online Store

Product Catalogues in the Online Store

14:30
Getting Started in COGNOS Finished 14:30 - 16: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 COGNOS Reporting
  • 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 17 January 2018

09:30
Bespoke iProcurement for Fitzwilliam Museum new Finished 09:30 - 13:00 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

« Description not available »

10:30
Off Payroll Worker Briefing Sessions new Finished 10:30 - 12:00 8 Mill Lane, Lecture Room 10

From 6 April 2017 new rules will apply to payments made to limited companies largely controlled by a single individual where they provide services to the University, or agencies providing such resource to the University. The Finance Division is holding a number of seminars to explain procedures and guidelines that they are implementing to help departments manage this risk.

Thursday 18 January 2018

09:30
GL Part 2: Reporting in the General Ledger (1 of 2) Finished 09:30 - 13:00 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.

Budgeting part 1: Introduction to budgeting in the University (Formerly Managing the Budget) new CANCELLED 09:30 - 12:30 Cambridge University Library, IT Training 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:30
Budgeting part 1: Introduction to budgeting in the University (Formerly Managing the Budget) new CANCELLED 13:30 - 16:30 Cambridge University Library, IT Training 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.

14:00
GL Part 2: Reporting in the General Ledger (2 of 2) Finished 14:00 - 16:00 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.

Friday 19 January 2018

09:30
Bespoke iProcurement for Fitzwilliam Museum new Finished 09:30 - 13:00 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

« Description not available »

Monday 22 January 2018

09:30

To provide an opportunity for those in the Finance Division to spend half a day with the Training Team to get an overview and appreciation of what they do.

Tuesday 23 January 2018

09:30
AAT Level 3 Diploma in Accounting 2017-18 new charged (14 of 26) Finished 09:30 - 16:30 Greenwich House, Heidelberg Room


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
AAT Level 4 Professional Diploma in Accounting 2017-18 charged (11 of 37) Finished 09:30 - 16:30

AAT Level 4, Professional Diploma in accounting.

Students will be placed on the public day release programme with the external provider

Once you have registered here you will need to complete the application form at the back of the briefing pack. This pack is available on our website https://www.finance.admin.cam.ac.uk/training/professional-qualifications/aat/university-programme The remaining dates will be added once they have been confirmed

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.