skip to navigation skip to content

Finance Training

Finance Training course timetable

Show:

Wed 21 Mar 2018 – Wed 25 Apr 2018

Now Today

[ No events on Wed 21 Mar 2018 ]

Thursday 22 March 2018

12:15
Knowledge Bites - Project Indigo Update new Finished 12:15 - 13:00 Greenwich House, Heidelberg Room

A high level demo of system functionality to show how an invoice image will be attached and available in CUFS, this will benefit departments who use Shared Services Finance. The solution will reduce the need for movement of manual paper copies by increasing electronic processing methods.

13:00
Grants Part 2: Grant reports in COGNOS Finished 13:00 - 16: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.

Tuesday 27 March 2018

09:30
AAT Level 3 Diploma in Accounting 2017-18 new charged (18 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

Wednesday 28 March 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.

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.

Thursday 29 March 2018

09:30
AAT Level 4 Professional Diploma in Accounting 2017-18 charged (20 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

AAT Level 2 Certificate in Bookkeeping 2017-18 - Day Release charged (6 of 10) Finished 09:30 - 12:30 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

The AAT Foundation Certificate in Bookkeeping is the starting point for studying the AAT qualfiication.

It is a short qualification which will help you to develop essential bookkeeping skills. Once completed, you will have an understanding of basic accounting practices and techniques including double-entry bookkeeping. It can be treated as a stand alone qualifcation or used as a stepping stone to further AAT study at Level 3.

Once you have registered here you will need to complete the application form at the back of the briefing pack. These packs are available on our website https://www.finance.admin.cam.ac.uk/training/professional-qualifications/aat/university-programme

Wednesday 4 April 2018

13:00

To provide an opportunity for someone from elsewhere in Finance Division to spend a half day with the Financial Systems Group to get an overview and appreciation of what they do.

Thursday 5 April 2018

09:30
AAT Level 4 Professional Diploma in Accounting 2017-18 charged (21 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

Tuesday 10 April 2018

12:15
Knowledge Bites - Business System Strategy Financial Systems Programme new Finished 12:15 - 13:00 Greenwich House, Heidelberg Room

The culmination of Project Beacon to review the future direction of the Finance System is formation of a programme of work, endorsed by the Information Services Committee to look at the implementation of the next stage for CUFS and to review Procurement.

Thursday 12 April 2018

09:30
AAT Level 4 Professional Diploma in Accounting 2017-18 charged (22 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

Monday 16 April 2018

09:30
AAT Level 4 Professional Diploma in Accounting 2017-18 charged (23 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

How to Excel new (1 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 17 April 2018

09:30
AAT Level 3 Diploma in Accounting 2017-18 new charged (19 of 26) Finished 09:30 - 12:30 Finance Division, Greenwich House, Ferrara Room (IT Training 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 (24 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

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

Wednesday 18 April 2018

09:30
AAT Level 4 Professional Diploma in Accounting 2017-18 charged (25 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

Thursday 19 April 2018

09:30
AAT Level 2 Certificate in Bookkeeping 2017-18 - Day Release charged (7 of 10) Finished 09:30 - 16:30 Greenwich House, Heidelberg Room

The AAT Foundation Certificate in Bookkeeping is the starting point for studying the AAT qualfiication.

It is a short qualification which will help you to develop essential bookkeeping skills. Once completed, you will have an understanding of basic accounting practices and techniques including double-entry bookkeeping. It can be treated as a stand alone qualifcation or used as a stepping stone to further AAT study at Level 3.

Once you have registered here you will need to complete the application form at the back of the briefing pack. These packs are available 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.

Monday 23 April 2018

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 24 April 2018

09:30
AR Part 2: Adjustments and Set Up in Accounts Receivable Finished 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:30
COGNOS: Refresher training new 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 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 25 April 2018

10:00
VAT for the ROO and Research Accounting new Finished 10:00 - 12:00 Finance Division, Clinical School Seminar Room 1

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:00
Grants Part 3: Viewing Grants in CUFS Finished 13:00 - 16:30 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.