Finance Training course timetable

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.

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.

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 AAT Foundation Certificate in Bookkeeping is the starting point for studying the AAT qualfiication.

It is a short qualification which will help you to develop essential bookkeeping skills. Once completed, you will have an understanding of basic accounting practices and techniques including double-entry bookkeeping. It can be treated as a stand alone qualifcation or used as a stepping stone to further AAT study at Level 3.

Once you have registered here you will need to complete the application form at the back of the briefing pack. These packs will be made available on our website https://www.finance.admin.cam.ac.uk/training/professional-qualifications/aat/university-programme

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

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.

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.

We are not currently able to offer classroom courses however our suite of online courses remain available

• https://www.training.cam.ac.uk/fin/event/3087715 for buyers
• https://www.training.cam.ac.uk/fin/event/3087769 for requisitioners

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 covers the various month-end processes that need to be completed within the iProcurement module.

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.

The AAT Foundation Certificate in Bookkeeping is the starting point for studying the AAT qualfiication.

It is a short qualification which will help you to develop essential bookkeeping skills. Once completed, you will have an understanding of basic accounting practices and techniques including double-entry bookkeeping. It can be treated as a stand alone qualifcation or used as a stepping stone to further AAT study at Level 3.

Once you have registered here you will need to complete the application form at the back of the briefing pack. These packs will be made available on our website https://www.finance.admin.cam.ac.uk/training/professional-qualifications/aat/university-programme

This session provides you with a simple overview of the basics and how VAT applies to Research Grants including;

• How to establish the correct VAT rate to attribute to an award when it is set up in CUFS
• Why it is so important
• How the VAT rate attributed affects expenditure subsequently coded to the grant

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

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 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.

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.

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 enables users to learn the basics of how the General Ledger module works, how to run online account enquiries and how to process journals.

It is run as two webinars with some pre-course reading

Webinar 1: For everyone

Webinar 2: Optional, if you are not going to be using journals it is not compulsory but may be of interest

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 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.