Finance Training course timetable
Tuesday 19 May 2020
09:15 |
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 |
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
|
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. |
|
10:00 |
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. It is run as two webinars with some pre-course reading Webinar 1: For everyone Webinar 2: Optional, if you are not going to be using journals it is not compulsory but may be of interest |
Wednesday 20 May 2020
09:15 |
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 |
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 21 May 2020
10:00 |
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. It is run as two webinars with some pre-course reading Webinar 1: For everyone Webinar 2: Optional, if you are not going to be using journals it is not compulsory but may be of interest |
13:00 |
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. |
Tuesday 26 May 2020
09:30 |
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
|
Tuesday 2 June 2020
09:30 |
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
|
Virtual - Cognos Introduction
Finished
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. 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. |
Wednesday 3 June 2020
09:30 |
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. |
10:00 |
Welcome to Key Travel
CANCELLED
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. |
14:00 |
Cognos Introduction
CANCELLED
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. 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. |
Virtual - Cognos Introduction
Finished
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. 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. |
Thursday 4 June 2020
09:00 |
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 will be made available on our website https://www.finance.admin.cam.ac.uk/training/professional-qualifications/aat/university-programme |
10:30 |
VAT & the University
CANCELLED
This session provides you with a simple overview of the basics and how VAT applies to the University. |
Monday 8 June 2020
14:00 |
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. |
Tuesday 9 June 2020
09:30 |
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
|
We are not currently able to offer classroom courses however our suite of online courses remain available
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
Once this request has been submitted by your Key Contact, you should receive an email within 1-2 working days with either:
|
|
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 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. |
|
13:45 |
We are not currently able to offer classroom courses however our suite of online courses remain available
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
Once this request has been submitted by your Key Contact, you should receive an email within 1-2 working days with either:
|
14:00 |
This course covers the various month-end processes that need to be completed within the iProcurement module. |
Wednesday 10 June 2020
09:30 |
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. |