Finance Training course timetable

This session covers the theory and practice of budgeting in the University, how to interpret department budget reports and understand the causes of overspends (and underspends) against budgets. The course refers closely to Chapter 3 of the Financial Procedures Manual

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

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.

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

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

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 year end seminars this year will be run on a school basis. There will be a short presentation from the Finance Division team and then a session for school specific questions relating to the year end process. Questions and topics for discussion can be submitted in advance via your School Finance manager

The year end seminars this year will be run on a school basis. There will be a short presentation from the Finance Division team and then a session for school specific questions relating to the year end process. Questions and topics for discussion can be submitted in advance via your School Finance manager

The session will be followed by the accounts forum

The year end seminars this year will be run on a school basis. There will be a short presentation from the Finance Division team and then a session for school specific questions relating to the year end process. Questions and topics for discussion can be submitted in advance via your School Finance manager

The session will be followed by the accounts forum

This event is for accounts staff from the UAS and non-schools institutions.

There will be a short presentation from the Finance Division team and then a session for institution specific questions relating to the year end process. Questions and topics for discussion can be submitted in advance via your School Finance manager

The year end seminars this year will be run on a school basis. There will be a short presentation from the Finance Division team and then a session for school specific questions relating to the year end process. Questions and topics for discussion can be submitted in advance via your School Finance manager.

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.

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 virtual new users Q&A session gives you an opportunity to ask specific questions related to the modules covered. All presenters will be present.

It is designed as a follow on from the explanatory videos which cover the year end processes in more detail than the general year-end presentation, and include specific procedures and tasks for each module.

To view the presentations, go to Finance Policy and Procedures > Financial Procedures > Chapter 11: Year-end instructions > Year end presentations and Q&A sessions: https://www.finance.admin.cam.ac.uk/Year-end-2021_presentations_and_QA_sessions

Modules covered include:

• iProcurement
• Accounts Payable
• Accounts Receivable
• The AP Dashboard
• Fixed Assets
• General Ledger
• Grants
• Cognos Reports

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.

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.

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.

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.