skip to navigation skip to content

Finance Training

Finance Training course timetable

Show:

Sun 17 Jun – Wed 18 Jul

Now Today

[ No events today ]

June 2018

Mon 18
Year end 2018 seminar - Non Schools/UAS/General new [Open] 10:30 - 11:30 17 Mill Lane, Seminar Room B

This event is for accounts staff from the UAS and non-schools institutions.

There will be a short presentation from the Finance Division team and then a session for institution specific questions relating to the year end process. Questions and topics for discussion can be submitted in advance via your School Finance manager

Tue 19
AAT Level 3 Diploma in Accounting 2017-18 new charged (25 of 26) Not bookable 09:30 - 16: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
Year end 2018 seminar - School of Biological Sciences new [Open] 14:00 - 15:00 17 Mill Lane, Seminar Room B

The year end seminars this year will be run on a school basis. There will be a short presentation from the Finance Division team and then a session for school specific questions relating to the year end process. Questions and topics for discussion can be submitted in advance via your School Finance manager

Thu 21
AAT Level 4 Professional Diploma in Accounting 2017-18 charged (36 of 37) Not bookable 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

Year end 2018 seminar - School of Humanities and Social Sciences new [Open] 10:00 - 11:00 Finance Division, Mond Building, Mond Seminar Room

The year end seminars this year will be run on a school basis. There will be a short presentation from the Finance Division team and then a session for school specific questions relating to the year end process. Questions and topics for discussion can be submitted in advance via your School Finance manager

The session will be followed by the accounts forum

Fri 22

To provide an opportunity for someone from elsewhere in Fin Ops to spend a day in the Central and Research Accounting Team to get an overview and appreciation of what they do including Fixed Assets, Fee Collection, Property Accounting, Trust Funds and Research Accounting.

Mon 25
[Finance Division only] Knowledge Bites - Year End Briefing new [Open] 12:15 - 13:00 Greenwich House, Heidelberg Room

The financial year end is approaching and with it comes additional tasks, module close dates outside the usual monthly schedule, and queries from departments as they try to meet the deadlines. This briefing session will ensure you’re aware of year-end deadlines and changes to previous years, help you understand what the departments may be looking to finalise at various points over the year end, and give you a chance to ask questions.

How to Excel new (1 of 2) [Full] 13:00 - 16:30 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
Tue 26
Cognos: Refresher training new [Places] 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.

Thu 28
AAT Level 4 Professional Diploma in Accounting 2017-18 charged (37 of 37) Not bookable 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 3: Viewing Grants in CUFS [Places] 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.

Fri 29
Year end 2018 seminar - Schools of Technology and Physical Sciences new [Open] 10:00 - 11:00 8 Mill Lane, Lecture Room 5

The year end seminars this year will be run on a school basis. There will be a short presentation from the Finance Division team and then a session for school specific questions relating to the year end process. Questions and topics for discussion can be submitted in advance via your School Finance manager

The session will be followed by the accounts forum

July 2018

Mon 2
How to Excel new (2 of 2) [Full] 13:00 - 16:30 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
Tue 3
iProcurement Part 1: Getting Started in iProcurement (1 of 2) [Places] 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.

iProcurement Part 1: Getting Started in iProcurement (2 of 2) [Places] 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.

Thu 5
GL Part 1: Getting Started in the General Ledger module [Places] 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.

Tue 10
Year-end for New Users new [Places] 09:30 - 13:00 Greenwich House, Heidelberg Room

This session will cover year end processes in more detail than the road shows and will include:

  • Outline of the year end timetable to be followed
  • Specific procedures and tasks for each module
  • Guidance on journals especially accruals, prepayments and transfer codes
  • Making better use of the COGNOS reporting tool
  • Exploring areas that often cause problems
  • Practical advice on how to prioritise during key periods
Wed 11
How to Excel - Part 3 (PILOT) new [Full] 09:30 - 13:00 Finance Division, Greenwich House, Ferrara Room (IT Training Room)

This session is a pilot and only open to those who have attended the How to Excel course this year Places will be awarded on a first come, first served basis

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

Thu 12

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.

Grants Part 2: Grant reports in COGNOS [Places] 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.

Fri 13
Year end 2018 seminar - General new [Open] 11:00 - 12:00 Todd-Hamied

This event is for accounts staff from the UAS and non-schools institutions.

There will be a short presentation from the Finance Division team and then a session for institution specific questions relating to the year end process. Questions and topics for discussion can be submitted in advance via your School Finance manager

Tue 17
GL Part 2: Reporting in the General Ledger (1 of 2) [Places] 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.

GL Part 2: Reporting in the General Ledger (2 of 2) [Places] 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.

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

Wed 18
AR Part 2: Adjustments and Set Up in Accounts Receivable [Places] 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.