Finance Training course timetable
Tuesday 20 June 2023
| 09:30 |
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 |
| 15:00 |
Tableau Drop In Sessions (via Teams)
Finished
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. |
Wednesday 21 June 2023
| 14:00 |
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. |
Thursday 22 June 2023
| 09:30 |
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. |
Friday 23 June 2023
| 11:00 |
Tableau Drop In Sessions (via Teams)
Finished
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. |
| 11:30 |
Tableau Drop In Sessions (via Teams)
Finished
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. |
Tuesday 27 June 2023
| 10:00 |
The Safety Team & Procurement Services welcome you to a Supplier Event with the University's new Hazardous Waste contractors Tradebe; who will collect hazardous chemical waste and hazardous WEEE electrical waste & Sharpsmart; who will collect Bio-Hazardous waste and provide a Returnable Sharps bin service. There will be presentations throughout the day, please book on the most convenient session. On each day the sessions will be as follows;
The Suppliers will showcase the waste collection and treatment strategy for the University including their equipment so you will be able to see what some of the new items will look like. The Suppliers will also bring along some additional information to show from their individual marketing stands. You will then have the opportunity to ask any questions. We look forward to introducing you to the University's New Suppliers. There are three venues on three days
|
| 10:30 |
« Description not available » |
| 10:50 |
The Safety Team & Procurement Services welcome you to a Supplier Event with the University's new Hazardous Waste contractors Tradebe; who will collect hazardous chemical waste and hazardous WEEE electrical waste & Sharpsmart; who will collect Bio-Hazardous waste and provide a Returnable Sharps bin service. There will be presentations throughout the day, please book on the most convenient session. On each day the sessions will be as follows;
The Suppliers will showcase the waste collection and treatment strategy for the University including their equipment so you will be able to see what some of the new items will look like. The Suppliers will also bring along some additional information to show from their individual marketing stands. You will then have the opportunity to ask any questions. We look forward to introducing you to the University's New Suppliers. There are three venues on three days
|
| 11:40 |
The Safety Team & Procurement Services welcome you to a Supplier Event with the University's new Hazardous Waste contractors Tradebe; who will collect hazardous chemical waste and hazardous WEEE electrical waste & Sharpsmart; who will collect Bio-Hazardous waste and provide a Returnable Sharps bin service. There will be presentations throughout the day, please book on the most convenient session. On each day the sessions will be as follows;
The Suppliers will showcase the waste collection and treatment strategy for the University including their equipment so you will be able to see what some of the new items will look like. The Suppliers will also bring along some additional information to show from their individual marketing stands. You will then have the opportunity to ask any questions. We look forward to introducing you to the University's New Suppliers. There are three venues on three days
|
| 12:30 |
The Safety Team & Procurement Services welcome you to a Supplier Event with the University's new Hazardous Waste contractors Tradebe; who will collect hazardous chemical waste and hazardous WEEE electrical waste & Sharpsmart; who will collect Bio-Hazardous waste and provide a Returnable Sharps bin service. There will be presentations throughout the day, please book on the most convenient session. On each day the sessions will be as follows;
The Suppliers will showcase the waste collection and treatment strategy for the University including their equipment so you will be able to see what some of the new items will look like. The Suppliers will also bring along some additional information to show from their individual marketing stands. You will then have the opportunity to ask any questions. We look forward to introducing you to the University's New Suppliers. There are three venues on three days
|
| 13:20 |
The Safety Team & Procurement Services welcome you to a Supplier Event with the University's new Hazardous Waste contractors Tradebe; who will collect hazardous chemical waste and hazardous WEEE electrical waste & Sharpsmart; who will collect Bio-Hazardous waste and provide a Returnable Sharps bin service. There will be presentations throughout the day, please book on the most convenient session. On each day the sessions will be as follows;
The Suppliers will showcase the waste collection and treatment strategy for the University including their equipment so you will be able to see what some of the new items will look like. The Suppliers will also bring along some additional information to show from their individual marketing stands. You will then have the opportunity to ask any questions. We look forward to introducing you to the University's New Suppliers. There are three venues on three days
|
| 14:10 |
The Safety Team & Procurement Services welcome you to a Supplier Event with the University's new Hazardous Waste contractors Tradebe; who will collect hazardous chemical waste and hazardous WEEE electrical waste & Sharpsmart; who will collect Bio-Hazardous waste and provide a Returnable Sharps bin service. There will be presentations throughout the day, please book on the most convenient session. On each day the sessions will be as follows;
The Suppliers will showcase the waste collection and treatment strategy for the University including their equipment so you will be able to see what some of the new items will look like. The Suppliers will also bring along some additional information to show from their individual marketing stands. You will then have the opportunity to ask any questions. We look forward to introducing you to the University's New Suppliers. There are three venues on three days
|
| 15:00 |
Tableau Drop In Sessions (via Teams)
Finished
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. |
Wednesday 28 June 2023
| 10:00 |
Virtual - Cognos Introduction
Finished
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. |
Thursday 29 June 2023
| 09:30 |
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. |
| 10:00 |
Virtual - Cognos Introduction
Finished
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. |
| 10:30 |
« Description not available » |
| 11:00 |
This event looks at key events currently affecting SCM. It outlines the Year End process, with reminders of the key dates and tasks required for a smooth close to the 2022/23 financial year. There will also be an update on the VAT Medical Exemption process and on the Finance Transformation Programme (FTP). There will be presenters from Central Finance and Tax available for answering questions. If you have specific queries on any of the topics being covered or any other Finance questions, please include them in the Special Requirements section when you book. |
Friday 30 June 2023
| 11:00 |
Tableau Drop In Sessions (via Teams)
Finished
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. |
| 11:30 |
Tableau Drop In Sessions (via Teams)
Finished
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. |
Monday 3 July 2023
| 10:00 |
The Safety Team & Procurement Services welcome you to a Supplier Event with the University's new Hazardous Waste contractors Tradebe; who will collect hazardous chemical waste and hazardous WEEE electrical waste & Sharpsmart; who will collect Bio-Hazardous waste and provide a Returnable Sharps bin service. There will be presentations throughout the day, please book on the most convenient session. On each day the sessions will be as follows;
The Suppliers will showcase the waste collection and treatment strategy for the University including their equipment so you will be able to see what some of the new items will look like. The Suppliers will also bring along some additional information to show from their individual marketing stands. You will then have the opportunity to ask any questions. We look forward to introducing you to the University's New Suppliers. There are three venues on three days
|
| 10:50 |
The Safety Team & Procurement Services welcome you to a Supplier Event with the University's new Hazardous Waste contractors Tradebe; who will collect hazardous chemical waste and hazardous WEEE electrical waste & Sharpsmart; who will collect Bio-Hazardous waste and provide a Returnable Sharps bin service. There will be presentations throughout the day, please book on the most convenient session. On each day the sessions will be as follows;
The Suppliers will showcase the waste collection and treatment strategy for the University including their equipment so you will be able to see what some of the new items will look like. The Suppliers will also bring along some additional information to show from their individual marketing stands. You will then have the opportunity to ask any questions. We look forward to introducing you to the University's New Suppliers. There are three venues on three days
|
| 11:40 |
The Safety Team & Procurement Services welcome you to a Supplier Event with the University's new Hazardous Waste contractors Tradebe; who will collect hazardous chemical waste and hazardous WEEE electrical waste & Sharpsmart; who will collect Bio-Hazardous waste and provide a Returnable Sharps bin service. There will be presentations throughout the day, please book on the most convenient session. On each day the sessions will be as follows;
The Suppliers will showcase the waste collection and treatment strategy for the University including their equipment so you will be able to see what some of the new items will look like. The Suppliers will also bring along some additional information to show from their individual marketing stands. You will then have the opportunity to ask any questions. We look forward to introducing you to the University's New Suppliers. There are three venues on three days
|
| 12:30 |
The Safety Team & Procurement Services welcome you to a Supplier Event with the University's new Hazardous Waste contractors Tradebe; who will collect hazardous chemical waste and hazardous WEEE electrical waste & Sharpsmart; who will collect Bio-Hazardous waste and provide a Returnable Sharps bin service. There will be presentations throughout the day, please book on the most convenient session. On each day the sessions will be as follows;
The Suppliers will showcase the waste collection and treatment strategy for the University including their equipment so you will be able to see what some of the new items will look like. The Suppliers will also bring along some additional information to show from their individual marketing stands. You will then have the opportunity to ask any questions. We look forward to introducing you to the University's New Suppliers. There are three venues on three days
|
| 13:20 |
The Safety Team & Procurement Services welcome you to a Supplier Event with the University's new Hazardous Waste contractors Tradebe; who will collect hazardous chemical waste and hazardous WEEE electrical waste & Sharpsmart; who will collect Bio-Hazardous waste and provide a Returnable Sharps bin service. There will be presentations throughout the day, please book on the most convenient session. On each day the sessions will be as follows;
The Suppliers will showcase the waste collection and treatment strategy for the University including their equipment so you will be able to see what some of the new items will look like. The Suppliers will also bring along some additional information to show from their individual marketing stands. You will then have the opportunity to ask any questions. We look forward to introducing you to the University's New Suppliers. There are three venues on three days
|
| 14:10 |
The Safety Team & Procurement Services welcome you to a Supplier Event with the University's new Hazardous Waste contractors Tradebe; who will collect hazardous chemical waste and hazardous WEEE electrical waste & Sharpsmart; who will collect Bio-Hazardous waste and provide a Returnable Sharps bin service. There will be presentations throughout the day, please book on the most convenient session. On each day the sessions will be as follows;
The Suppliers will showcase the waste collection and treatment strategy for the University including their equipment so you will be able to see what some of the new items will look like. The Suppliers will also bring along some additional information to show from their individual marketing stands. You will then have the opportunity to ask any questions. We look forward to introducing you to the University's New Suppliers. There are three venues on three days
|