Finance Training course timetable
November 2019
| Mon 18 |
Tableau for Explorers - Research
[Places]
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. |
| Tue 19 |
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. |
|
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. |
|
| Wed 20 |
AAT Level 3 Diploma in Accounting 2019-20
Not bookable
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 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. |
|
|
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:
|
|
| Thu 21 |
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. |
| Mon 25 |
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. |
| Tue 26 |
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. |
|
Managing the Budget - Part 2
[Places]
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 Managing the Budget 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. |
|
|
Getting Started in Cognos
[Places]
Cognos is a reporting tool that utilises data from CUFS to provide users with additional reports and options. This master class is designed to get existing CUFS users going with the reporting tool. It covers everything from running a report successfully as well as a number of useful tips and shortcuts. 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:
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. |
|
| Wed 27 |
AAT Level 3 Diploma in Accounting 2019-20
Not bookable
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
|
| Thu 28 |
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. |
December 2019
| Tue 3 |
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. |
| Wed 4 |
Cognos: Refresher Training
[Places]
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:
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 5 |
Managing the Budget - Part 1
[Places]
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 session led by Finance Managers and Advisers will provide attendees with an insight into their roles and how different Schools operate. The session will be equally split between two different School teams:
to reflect the different approaches and demands of different sectors within the University. |
|
| Mon 9 |
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. |
| Tue 10 |
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. |
|
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. |
|
| Wed 11 |
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. |
|
Welcome to Key Travel
[Places]
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.  |
|
| Thu 12 |
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. |
| Fri 13 |
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. |
| Mon 16 |
AAT Level 3 Diploma in Accounting 2019-20
Not bookable
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
|