Finance Training course timetable

As a recent new starter to the Finance Division, we would like to invite you to attend a welcome session in Greenwich House with David Hughes. These sessions are an opportunity for you to meet with other members of staff who have recently joined Finance, as well as hearing from David and senior members of the team.

Please book onto a session below that suits your office working pattern best. We encourage you to attend in your first three months in the Finance Division but if you are unable to attend either of these dates, more dates will follow later in the year.

The session will look at more advanced formulas and macros using the recorder and VBA tools.

The formulas covered in this course include SUMIF and COUNTIF which will allow 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.

The session will run on Teams and delegates must be able to access Excel during the session

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.

This is an opportunity for the members of the University to go one-on-one with Tableau experts across the Business Information and Strategic Insights Team, who can help you solve challenges.

This is an opportunity for the members of the University to go one-on-one with Tableau experts across the Business Information and Strategic Insights Team, who can help you solve challenges.

How to make a group booking with Key Travel - Organising group travel for research or to undertake work on behalf of the University.

This training session, delivered by Key Travel, is open to new and experienced colleagues who are responsible for booking group travel (10 passengers or more) on behalf of the University. Key Travel’s Specialist Travel team will take you through the process of group bookings including:

• What is group travel?
• How to make a group booking with Key Travel (what information is required)
• Services available
• Benefits of booking with Key Travel

The primary purpose of the training session will be to walk you through the booking process, however, there will also be opportunities to ask questions and explore the services provided.

This is an opportunity for the members of the University to go one-on-one with Tableau experts across the Business Information and Strategic Insights Team, who can help you solve challenges.

This course provides users the opportunity to run General Ledger reports and how to interpret them when managing departmental funds.

This course is designed to help anyone responsible for purchasing items which will be used in medical or veterinary research and training. It will explain when it is appropriate to claim VAT relief and how the relief is claimed.

This course provides users the opportunity to run General Ledger reports and how to interpret them when managing departmental funds.

This is an opportunity for the members of the University to go one-on-one with Tableau experts across the Business Information and Strategic Insights Team, who can help you solve challenges.

This is an opportunity for the members of the University to go one-on-one with Tableau experts across the Business Information and Strategic Insights Team, who can help you solve challenges.

This is a classroom version of the Cognos Introduction held at Greenwich House - All delegates will need to bring a laptop (docking stations, monitors, external keyboard and mice will be available in the room)

Please note - there is no parking available at Greenwich House. The Madingley Park and Ride is a 15 minute walk and the Universal Bus stops on Madingley Road.

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.

Cannot make any dates? See the on-demand online version of the course. Completion of this course will count as Cognos attendance for the purpose of acceptance onto the above courses. You should ask your Key Contact to request Cognos access for you, prior to working through the on-demand material.

This is an opportunity for the members of the University to go one-on-one with Tableau experts across the Business Information and Strategic Insights Team, who can help you solve challenges.

There are many benefits to working at Cambridge. In this session we will explore how to make the most of the discounts and resources you are entitled to and highlight the activities available to help you make the most of working here.

This is an opportunity for the members of the University to go one-on-one with Tableau experts across the Business Information and Strategic Insights Team, who can help you solve challenges.

This is an opportunity for the members of the University to go one-on-one with Tableau experts across the Business Information and Strategic Insights Team, who can help you solve challenges.

How to book with Key Travel - Travelling for research or to undertake work on behalf of the University.

This training session, delivered by Key Travel, is open to new and experienced colleagues who are responsible for booking travel on behalf of the University. Key Travel is the University’s preferred supplier for travel management services and provides the following support for colleagues:

• Booking services (online and offline) for flights, accommodation and rail
• Group booking services
• 24/7 Traveller support
• 24/7 Emergency scanning and support
• Refund management

The primary purpose of the training session will be to walk you through the booking process using Key Travel’s online portal. However, the session will also provide you with hints and tips on how to identify the best travel options for your requirements.

This is an opportunity for the members of the University to go one-on-one with Tableau experts across the Business Information and Strategic Insights Team, who can help you solve challenges.

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.

This is a classroom version of the General Ledger 1 course held at Greenwich House - All delegates will need to bring a laptop (docking stations, monitors, external keyboard and mice will be available in the room)

Please note - there is no parking available at Greenwich House. The Madingley Park and Ride is a 15-minute walk and the Universal Bus stops on Madingley Road.

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.

If none of the dates are suitable then there are two on-demand packages which can be completed instead.

Chart of Accounts and Account Enquiry https://www.training.cam.ac.uk/fin/event/4716069

Journals https://www.training.cam.ac.uk/fin/event/4716067