Finance Training course timetable
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. |
Thursday 9 April 2020
15: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. |
Monday 13 April 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. |
Wednesday 15 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
|
Thursday 16 April 2020
09:00 |
To provide an opportunity for someone from elsewhere in Finance Division to spend a day in the Credit Control Team to get an overview and appreciation of what they do. |
To provide an opportunity for someone from elsewhere in Finance 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 ofering two sessions, one on Treasury and one on Investments. Ideally participants should attend this one (Treasury) before attending the Investments session however this is not a pre-requisite. |
Tuesday 21 April 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 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:
|
13:45 |
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 |
An opportunity to gain an insight into the work of the Financial Systems Group, the day to day work and the major projects managed within this team as well as the relationships with UIS. |
Wednesday 22 April 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
|
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. |