Finance Training course timetable

Back by popular demand

We have decided to add an extra CPD session this year. There have been a number of requests for an additional session with a University specific focus and so Spencer Moore (Acting Head of Tax/International and Corporate Tax Manager) will be covering some of the tax issues that we need to be aware of.

Qualified staff can use this towards their annual CPD.

To provide an opportunity for someone from elsewhere in Fin Ops to spend a day in the Central and Research Accounting Team to get an overview and appreciation of what they do including Fixed Assets, Fee Collection, Property Accounting, Trust Funds and Research Accounting.

AAT Level 4, Professional Diploma in accounting.

Students will be placed on the public day release programme with the 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 The remaining dates will be added once they have been confirmed

To provide an opportunity for someone from elsewhere in Finance Division to spend a half day in the Payroll Team to get an overview and 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.

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.

To provide an opportunity for someone from elsewhere in Fin Ops to spend half a day in the Shared Services and Staff Bureau to get an overview and appreciation of what they do.

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

Topics covered:

• Extracting data from CUFS and COGNOS
• Basic formatting
• Basic formulas
• Navigating large spreadsheets
• Advanced formulas
• Conditional formatting
• Data validation
• Protecting cells and sheets
• Lookup function
• Pivot tables
• Charts and graphs
• Using data in other documents

Across the university and assoicated bodies we have many members of staff who have previously studied AAT or are currently studying. We have set up an alumni group specifically for these AAT qualified/part qualified staff as a way to maintain the connection and to support their continued development

Cyber security

Protecting the University’s assets, intellectual property and information against cyber security threats is a complex, evolving task. Cyber attacks can result in data loss, reputational damage, fines and other types of financial loss. To help protect the University against these risks, University Information Services (UIS) is overseeing a major programme to improve cyber security levels across the University

Kieren Lovell from UIS will be coming to speak about how we manage our security in the University and what steps we can take to protect ourselves.

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.

To provide an opportunity for someone from elsewhere in Fin Ops to spend a day in the Accounting Services Team to get an overview and appreciation of what they do.

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.

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:

• Grants Part 2 COGNOS Reporting
• General Ledger Reporting

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.

To provide an opportunity for someone from elsewhere in Fin Ops to spend a day in the Accounting Services Team to get an overview and appreciation of the function of the Helpdesk and Cashier.

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

Topics covered:

• Extracting data from CUFS and COGNOS
• Basic formatting
• Basic formulas
• Navigating large spreadsheets
• Advanced formulas
• Conditional formatting
• Data validation
• Protecting cells and sheets
• Lookup function
• Pivot tables
• Charts and graphs
• Using data in other documents

This session provides you with a simple overview of the basics and how VAT applies to the University.

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.

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.

To provide an opportunity for someone from elsewhere in Fin Ops to spend half a day in the Shared Services and Staff Bureau to get an overview and appreciation of what they do.

AAT Level 4, Professional Diploma in accounting.

Students will be placed on the public day release programme with the 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 The remaining dates will be added once they have been confirmed