Finance Training course timetable
Monday 16 March 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
|
12:00 |
An overview of the role of Central and Research Accounting and a taster of the range of the activities that they are involved with. This session is a required pre-requisite for attendance on the detailed walk-through sessions for any of the following topics:
|
Tuesday 17 March 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 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. |
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. |
|
PLEASE NOTE - THIS EVENT IS NOW A WEBINAR AND WILL BE LIVESTREAMED FROM 9.30AM AT http://cam.adobeconnect.com/ftp/ INSTRUCTIONS ON HOW TO JOIN ADOBE CONNECT WEBINARS CAN BE FOUND AT https://www.finance.admin.cam.ac.uk/files/participants_guide_to_webinars.pdf The Finance Transformation Programme’s Discovery Phase ended in December and we are now in a position to share the findings with you. The Discovery Phase was designed to help us understand how Finance operates and to guide on how we can transform processes and systems to better support the University. We’d like to thank everyone who participated and are delighted to now share the findings during these meetings, where we will also outline next steps. This will include establishing a number of work streams during the next few months to evaluate best practice and take this work forward. We are also keen to answer your questions, therefore please submit any you might have via the FTP email address in advance: ftprogramme@admin.cam.ac.uk or there will be an opportunity for Q&A during the session. |
|
14:00 |
Accountants' Annual Update
POSTPONED
In light of the current situation we have made the decision to postpone the Accountants Update which was due to take place tomorrow. This is not a decision that we have taken lightly but we appreciate that people might be uncomfortable with gathering in a large group and will also have increased pressures on their time due to the contingency planning that is currently taking place. We will arrange a new event at a later date Our external auditors PricewaterhouseCoopers will be coming in to give an update on accounting issues and developments that are relevant to the University Group. Qualified staff can use this towards their annual CPD. |
Wednesday 18 March 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 |
To provide an introduction to the Property Accounting Services team and the activities undertaken in the Section |
10:00 |
VAT & the University
CANCELLED
This session provides you with a simple overview of the basics and how VAT applies to the University. |
Thursday 19 March 2020
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. |
Friday 20 March 2020
09:30 |
Tableau for Explorers - Research
POSTPONED
Tableau Server is an online application available to all members of the university to access Tableau dashboards and visualisations Tableau Explorer is intermediate level access to Tableau Server and allows you to view, interact and edit Tableau content. |
Monday 23 March 2020
13:00 |
An update on the Expenses Management System project - to take a look a the proposed system and ask questions. |
Tuesday 24 March 2020
11: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. |
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. |
Wednesday 25 March 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:30 |
Grants Part 2: Grant reports in Cognos
CANCELLED
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:
In this course we will not access the Grants module in CUFS. |
Thursday 26 March 2020
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. |
Monday 30 March 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 |
Tuesday 31 March 2020
10:00 |
Grants and Indirect Costs Seminar
CANCELLED
« Description not available » |
14:00 |
This course covers the various month-end processes that need to be completed within the iProcurement module. |
16:00 |
This course covers the various month-end processes that need to be completed within the iProcurement module. |
Wednesday 1 April 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
|
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. |
Wednesday 8 April 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
|
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. |