skip to navigation skip to content

Finance Training

Finance Training course timetable

Show:

Tue 31 Jan – Thu 23 Mar

Now Today

[ No events today ]

February 2023

Wed 1
Virtual - How to Excel - Part 3 (For Finance staff) Not bookable 09:30 - 12:30 Via MS Teams

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

Fri 3
Tableau Drop In Sessions (via Teams) new [Places] 11:00 - 11:30 Via MS Teams

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.

Tableau Drop In Sessions (via Teams) new [Places] 11:30 - 12:00 Via MS Teams

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.

Fri 10
Tableau Drop In Sessions (via Teams) new [Full] 11:00 - 11:30 Via MS Teams

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.

Tableau Drop In Sessions (via Teams) new [Places] 11:30 - 12:00 Via MS Teams

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.

Wed 15
Virtual - Cognos Introduction (1 of 2) [Places] 10:00 - 11:30 Via MS Teams

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.

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.

Thu 16
Virtual - Cognos Introduction (2 of 2) [Places] 10:00 - 11:00 Via MS Teams

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.

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.

Fri 17
Tableau Drop In Sessions (via Teams) new [Places] 11:00 - 11:30 Via MS Teams

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.

Tableau Drop In Sessions (via Teams) new [Places] 11:30 - 12:00 Via MS Teams

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.

Wed 22
Virtual - Budgeting 1: Introduction to budgeting [Places] 09:30 - 12:00 Via MS Teams

This session introduces the theory and practice of budgeting, looking at why and how budgets can be set. Group exercises are used to prompt discussion around the types of costs that should be included in a budget and decision making when setting budgets.

The session will give an overview of the budgeting process in the university and then focus in more detail on practical tools for day-to-day budgeting.

Note: This session does not cover the detailed budgeting and rules relating to individual research grants.

Fri 24
Tableau Drop In Sessions (via Teams) new [Places] 11:00 - 11:30 Via MS Teams

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.

Tableau Drop In Sessions (via Teams) new [Places] 11:30 - 12:00 Via MS Teams

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.

Tue 28

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.

March 2023

Fri 3
Tableau Drop In Sessions (via Teams) new [Places] 11:00 - 11:30 Via MS Teams

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.

Tableau Drop In Sessions (via Teams) new [Places] 11:30 - 12:00 Via MS Teams

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.

Wed 8
Virtual - GL 1: Getting Started in the General Ledger module (1 of 2) [Places] 09:30 - 11:30 Via MS Teams

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

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.vle.cam.ac.uk/mod/scorm/view.php?id=18767511

Journals https://www.vle.cam.ac.uk/course/view.php?id=202131

Thu 9
Virtual - GL 1: Getting Started in the General Ledger module (2 of 2) [Places] 09:30 - 11:00 Via MS Teams

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

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.vle.cam.ac.uk/mod/scorm/view.php?id=18767511

Journals https://www.vle.cam.ac.uk/course/view.php?id=202131

Fri 10
Tableau Drop In Sessions (via Teams) new [Places] 11:00 - 11:30 Via MS Teams

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.

Tableau Drop In Sessions (via Teams) new [Places] 11:30 - 12:00 Via MS Teams

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.

Wed 15
Virtual - How to Excel - Part 1 & 2 (For Finance Staff) (1 of 2) [Full] 09:30 - 11:30 Via MS Teams

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.

Fri 17
Tableau Drop In Sessions (via Teams) new [Places] 11:00 - 11:30 Via MS Teams

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.

Tableau Drop In Sessions (via Teams) new [Places] 11:30 - 12:00 Via MS Teams

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.

Wed 22
Virtual - How to Excel - Part 1 & 2 (For Finance Staff) (2 of 2) [Full] 09:30 - 11:30 Via MS Teams

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.

Thu 23
Virtual - Grants Part 2: Grant reports in Cognos (1 of 2) [Places] 10:00 - 12:00 Via MS Teams

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.

The course material will be split across 2 webinars on consecutive days