Finance Training course timetable
Wednesday 22 January 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. |
Thursday 23 January 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. |
13:00 |
An informal welcome lunch for new Finance Division employees. Hosted by David Hughes (Director of Finance) and other senior managers this provides an opportunity to mingle and get to know other new starters and meet key people within the Division. A buffet lunch will be provided, please could you let us know in advance any dietary restrictions. |
Friday 24 January 2020
09:30 |
The course details are being finalised, for now please book a provisional place here and we will let you know when the details and application packs are available AAT Level 4, Professional Diploma in accounting. Students will be placed on the public day release programme with an 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 Dates will be added once they have been confirmed |
13:30 |
This course covers the various month-end processes that need to be completed within the iProcurement module. |
15:30 |
This course covers the various month-end processes that need to be completed within the iProcurement module. |
Tuesday 28 January 2020
09:30 |
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:00 |
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 29 January 2020
09:30 |
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. |
12:30 |
Please note, this session has now been moved 30 mins earlier, now beginning at 12:30 David Hughes will be delivering a review of the 2019 Financial Statements for anyone interested. It will be an opportunity to get an overview of the results for the year following the year-end audit. Finance Division staff only |
Friday 31 January 2020
09:30 |
The course details are being finalised, for now please book a provisional place here and we will let you know when the details and application packs are available AAT Level 4, Professional Diploma in accounting. Students will be placed on the public day release programme with an 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 Dates will be added once they have been confirmed |
10:00 |
A high level overview of indirect costs in relation to Research Grants here at Cambridge, where we discuss some of the reasons why this area is commonly misunderstood. |
Tuesday 4 February 2020
13:00 |
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. |
David Hughes will be delivering a review of the 2019 Financial Statements for anyone interested. It will be an opportunity to get an overview of the results for the year following the year end audit. This session is open to all finance staff in the University |
Wednesday 5 February 2020
09:30 |
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 |
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. |
Friday 7 February 2020
09:30 |
The course details are being finalised, for now please book a provisional place here and we will let you know when the details and application packs are available AAT Level 4, Professional Diploma in accounting. Students will be placed on the public day release programme with an 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 Dates will be added once they have been confirmed |
Monday 10 February 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
|
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 11 February 2020
09:30 |
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. |
13: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. |
14:00 |
The Finance Division values the professionalism and commitment of its members and therefore encourages all staff to develop their skills and knowledge. This short session will outline for you the Division’s policy on training and development, as well as highlighting resources from across the University that you can utilise. |
Wednesday 12 February 2020
09:30 |
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. |
10:00 |
Welcome to Key Travel
Finished
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. |
Thursday 13 February 2020
13:15 |
If you wish or need to work from home or away from the University's network for any reason, you may need to connect to the University's VPN or Remote Access systems. This talk will help you understand how this works and what you can do with it. OPTIONAL - SUPPORT |
14:00 |
If you wish or need to work from home or away from the University's network for any reason, you may need to connect to the University's VPN or Remote Access systems. This talk will help you understand how this works and what you can do with it. OPTIONAL - SUPPORT |