Finance Training course timetable

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.

An update on the Expenses Management System project - to take a look a the proposed system and ask questions.

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.

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.

• GL Part 2: Reporting in the General Ledger
• Grants Part 2: Grant reports in Cognos

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.

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.

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:

• Summary financial information for Projects
• Detailed expenditure analysis
• Management reports for Grants due to close

In this course we will not access the Grants module in CUFS.

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.

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

« Description not available »

This course covers the various month-end processes that need to be completed within the iProcurement module.

This course covers the various month-end processes that need to be completed within the iProcurement module.

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.

The AAT Level 3, Diploma in Accounting, introduces to students to more complex financial processes and accounting tasks, the principles of VAT, professional ethics and develops their spreadsheet skills.

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.

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.

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.

The AAT Level 3, Diploma in Accounting, introduces to students to more complex financial processes and accounting tasks, the principles of VAT, professional ethics and develops their spreadsheet skills.

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.

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.

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

• They will discuss whether online or classroom course is most appropriate for you
• They will confirm the level of access which you will require
• The course booking request will be made by them via the UFS responsibility access form

Once this request has been submitted by your Key Contact, you should receive an email within 1-2 working days with either:

• your allocated training username and passphrase (for online courses) or
• your joining instructions (classroom courses).

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

• They will discuss whether online or classroom course is most appropriate for you
• They will confirm the level of access which you will require
• The course booking request will be made by them via the UFS responsibility access form

Once this request has been submitted by your Key Contact, you should receive an email within 1-2 working days with either:

• your allocated training username and passphrase (for online courses) or
• your joining instructions (classroom courses).

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.