Finance Training 2019-20
(Fri 9 Aug 2019 - Tue 21 Jul 2020)
[ Back to start of the programme ]
October 2019
Thu 10 |
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 11 |
Tableau Server is an online application available to all members of the university to access Tableau dashboards and visualisations Tableau Explorer is intermediate level access to Tableau Server and allows you to view, interact and edit Tableau content. |
Tue 15 |
This course covers the various month-end processes that need to be completed within the iProcurement module. |
This course covers the various month-end processes that need to be completed within the iProcurement module. |
|
Wed 16 |
Tableau for Viewers - Research
Finished
Tableau Server is an online application available to all members of the university to access Tableau dashboards and visualisations. Tableau Viewer is entry level access to Tableau Server and allows you to view Tableau content created by others. |
Cognos: Refresher Training
CANCELLED
Have you previously attended Cognos training but not used the reporting tool since and would like to start using the tool again? If so then this course will enable you to get re-acquainted with Cognos.. Note: What it does not do is go through in detail the outputs of each individual report. Less experienced users of the Grants and/or General Ledger modules in CUFS are recommended to attend instead one of the following courses:
These two courses not only cover the mechanics of running the reports but also more advice on how to interpret and use the information as well as discussion about when to use which report. |
|
Thu 17 |
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 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. |
|
Fri 18 |
Off Payroll Worker Briefing Sessions
Finished
From 6 April 2017 new rules will apply to payments made to limited companies largely controlled by a single individual where they provide services to the University, or agencies providing such resource to the University. The Finance Division is holding a number of seminars to explain procedures and guidelines that they are implementing to help departments manage this risk. |
Tue 29 |
This course covers the day to day and month end transactions that need to be completed using a variety of tools in CUFS. |
November 2019
Fri 8 |
Tableau Server is an online application available to all members of the university to access Tableau dashboards and visualisations Tableau Explorer is intermediate level access to Tableau Server and allows you to view, interact and edit Tableau content. |
Mon 11 |
Tableau for Viewers - Research
Finished
Tableau Server is an online application available to all members of the university to access Tableau dashboards and visualisations. Tableau Viewer is entry level access to Tableau Server and allows you to view Tableau content created by others. |
Tue 12 |
This course is aimed at new iProcurement users and provides an introduction to using iProcurement for creating requisitions and purchase orders. iProcurement is also available as an online course for you to learn in your own time. Choose from our available online options if you are unable to make the classroom dates or prefer to study in this way. |
This course is aimed at new iProcurement users and provides an introduction to using iProcurement for creating requisitions and purchase orders. iProcurement is also available as an online course for you to learn in your own time. Choose from our available online options if you are unable to make the classroom dates or prefer to study in this way. |
|
This course is aimed at new iProcurement users and provides an introduction to using iProcurement for creating requisitions and purchase orders. iProcurement is also available as an online course for you to learn in your own time. Choose from our available online options if you are unable to make the classroom dates or prefer to study in this way. |
|
Wed 13 |
Welcome to Key Travel
Finished
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. |
Thu 14 |
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. |
Fri 15 |
VAT & Research
POSTPONED
This session provides you with a simple overview of the basics and how VAT applies to Research Grants including;
|
Mon 18 |
Tableau for Explorers - Research
Finished
Tableau Server is an online application available to all members of the university to access Tableau dashboards and visualisations Tableau Explorer is intermediate level access to Tableau Server and allows you to view, interact and edit Tableau content. |
Tue 19 |
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. |
Wed 20 |
This course provides users the opportunity to run General Ledger reports and how to interpret them when managing departmental funds. You are invited to bring with you any reference documents that you may have detailing your own departmental codes. |
Thu 21 |
Tax Exemptions - Medically Exempt
Finished
A briefing session to remind iProc buyers/requisitioners of when departments are eligible to apply/claim medical exemption relief from VAT. This area of VAT is being highlighted at the moment as it is a current focus of HMRC. Additionally, some suppliers are reviewing their controls over the application of Medical Exemption, and are therefore checking our use of ME0% on recent orders. |
Tue 26 |
This session covers how to make a financial plan, prepare it for upload to the finance system and monitor progress against the plan. It is a practical course which will look at the techniques and systems within the University that can be used for budgeting. It is an ideal follow on from Managing the Budget Part 1 and for those who have a good working knowledge of budgeting principles and want to develop skills in using the University budgeting tools. |
Getting Started in Cognos
CANCELLED
Cognos is a reporting tool that utilises data from CUFS to provide users with additional reports and options. This master class is designed to get existing CUFS users going with the reporting tool. It covers everything from running a report successfully as well as a number of useful tips and shortcuts. Note: What it does not do is go through in detail the outputs of each individual report. Less experienced users of the Grants and/or General Ledger modules in CUFS are recommended to attend instead one of the following courses:
These two courses not only cover the mechanics of running the reports but also more advice on how to interpret and use the information as well as discussion about when to use which report. |
|
Thu 28 |
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:
In this course we will not access the Grants module in CUFS. |