Finance Training course timetable

The AAT Foundation Certificate in Bookkeeping is the starting point for studying the AAT qualfiication.

It is a short qualification which will help you to develop essential bookkeeping skills. Once completed, you will have an understanding of basic accounting practices and techniques including double-entry bookkeeping. It can be treated as a stand alone qualifcation or used as a stepping stone to further AAT study at Level 3.

Once you have registered here please complete and return the application form at the back of the briefing pack, this pack can be found on our website http://www.finance.admin.cam.ac.uk/training/professional-qualifications/aat/university-programme

« Description not available »

This course is aimed at new iProcurement users and provides an introduction to using iProcurement for creating requisitions and purchase orders.

The AAT Foundation Certificate in Bookkeeping is the starting point for studying the AAT qualfiication.

It is a short qualification which will help you to develop essential bookkeeping skills. Once completed, you will have an understanding of basic accounting practices and techniques including double-entry bookkeeping. It can be treated as a stand alone qualifcation or used as a stepping stone to further AAT study at Level 3.

Once you have registered here please complete and return the application form at the back of the briefing pack, this pack can be found on our website http://www.finance.admin.cam.ac.uk/training/professional-qualifications/aat/university-programme

« Description not available »

« Description not available »

« Description not available »

A presentation by the University's Procurement Services Team, held on site in Room 3.37 at the Wellcome Trust / MRC Building.

This course covers the various month-end processes that need to be completed within the iProcurement module as well as showing you how to personalise and work with the Buyers Work Centre.

Building on the knowledge gained in iProcurement part 1, delegates will develop an understanding of running month end reports to identify open and incomplete requisitions and orders and how to correct and cancel them.

« Description not available »

« Description not available »

AAT Level 4, Professional Diploma in accounting.

The dates below are assuming that we have a bespoke day release group. If this is not possible, then the dates will be different.

Once you have registered here please complete and return the application form at the back of the briefing pack, this pack can be found on our website http://www.finance.admin.cam.ac.uk/training-and-development/professional-qualification/aat/university-programme

This course covers how to make corrections to sales invoices and receipts as well as more on foreign currencies and banking procedures. It will also guide you through month-end requirements and a variety of set-up tasks for your department to ensure that you get the most out of the system.

« Description not available »

The AAT Foundation Certificate in Bookkeeping is the starting point for studying the AAT qualfiication.

It is a short qualification which will help you to develop essential bookkeeping skills. Once completed, you will have an understanding of basic accounting practices and techniques including double-entry bookkeeping. It can be treated as a stand alone qualifcation or used as a stepping stone to further AAT study at Level 3.

Once you have registered here please complete and return the application form at the back of the briefing pack, this pack can be found on our website http://www.finance.admin.cam.ac.uk/training/professional-qualifications/aat/university-programme

AAT Level 4, Professional Diploma in accounting.

The dates below are assuming that we have a bespoke day release group. If this is not possible, then the dates will be different.

Once you have registered here please complete and return the application form at the back of the briefing pack, this pack can be found on our website http://www.finance.admin.cam.ac.uk/training-and-development/professional-qualification/aat/university-programme

This course is aimed at new iProcurement users and provides an introduction to using iProcurement for creating requisitions and purchase orders.

The AAT Foundation Certificate in Bookkeeping is the starting point for studying the AAT qualfiication.

It is a short qualification which will help you to develop essential bookkeeping skills. Once completed, you will have an understanding of basic accounting practices and techniques including double-entry bookkeeping. It can be treated as a stand alone qualifcation or used as a stepping stone to further AAT study at Level 3.

Once you have registered here please complete and return the application form at the back of the briefing pack, this pack can be found on our website http://www.finance.admin.cam.ac.uk/training/professional-qualifications/aat/university-programme

AAT Level 4, Professional Diploma in accounting.

The dates below are assuming that we have a bespoke day release group. If this is not possible, then the dates will be different.

Once you have registered here please complete and return the application form at the back of the briefing pack, this pack can be found on our website http://www.finance.admin.cam.ac.uk/training-and-development/professional-qualification/aat/university-programme

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.

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.

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

To provide an opportunity for someone from elsewhere in Fin Ops to spend a day in the Accounting Services Team to get an overview and appreciation of the function of the Helpdesk and Cashier.

Across the university and assoicated bodies we have many members of staff who have previously studied AAT or are currently studying. We have set up an alumni group specifically for these AAT qualified/part qualified staff as a way to maintain the connection and to support their continued developmen

Schedule:

• Coffee and networking
• Internal audit
• Producing the University Financial Statements
• University AAT programme

The AAT Level 3, Diploma in Accounting, introduces to students to more complex financial processes and accounting tasks, the principles of VAT, professional ethics and develops their spreadsheet skills.

To provide an opportunity for someone from elsewhere in Finance Division to spend half a day in the Financial Reporting Team to get an overview and appreciation of what they do.

Mainly Month-end and queries from other individuals.

This course covers the essentials for keeping your AR accounts in order. In addition to showing you how to make corrections, receipt foreign currencies and the required month/year-end reports we will also show you how you can save time by setting up memo lines, sales persons and receivable activities for your department.

A workshop designed to look more closely at the issues around invoicing and billing in the Grants module, providing best practice & hints and tips for raising invoices.

A workshop designed to look more closely at the issues around invoicing and billing in the Grants module, providing best practice & hints and tips for raising invoices.

AAT Level 4, Professional Diploma in accounting.

The dates below are assuming that we have a bespoke day release group. If this is not possible, then the dates will be different.

Once you have registered here please complete and return the application form at the back of the briefing pack, this pack can be found on our website http://www.finance.admin.cam.ac.uk/training-and-development/professional-qualification/aat/university-programme

The AAT Level 3, Diploma in Accounting, introduces to students to more complex financial processes and accounting tasks, the principles of VAT, professional ethics and develops their spreadsheet skills.

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

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.

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.

To provide an opportunity for someone from elsewhere in Finance Division to spend half a day in the Financial Reporting Team to get an overview and appreciation of what they do.

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:

• Grants Part 2 COGNOS Reporting
• General Ledger Reporting

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.

The AAT Foundation Certificate in Bookkeeping is the starting point for studying the AAT qualfiication.

It is a short qualification which will help you to develop essential bookkeeping skills. Once completed, you will have an understanding of basic accounting practices and techniques including double-entry bookkeeping. It can be treated as a stand alone qualifcation or used as a stepping stone to further AAT study at Level 3.

Once you have registered here please complete and return the application form at the back of the briefing pack, this pack can be found on our website http://www.finance.admin.cam.ac.uk/training/professional-qualifications/aat/university-programme

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.

The AAT Level 3, Diploma in Accounting, introduces to students to more complex financial processes and accounting tasks, the principles of VAT, professional ethics and develops their spreadsheet skills.

AAT Level 4, Professional Diploma in accounting.

The dates below are assuming that we have a bespoke day release group. If this is not possible, then the dates will be different.

Once you have registered here please complete and return the application form at the back of the briefing pack, this pack can be found on our website http://www.finance.admin.cam.ac.uk/training-and-development/professional-qualification/aat/university-programme

The AAT Foundation Certificate in Bookkeeping is the starting point for studying the AAT qualfiication.

It is a short qualification which will help you to develop essential bookkeeping skills. Once completed, you will have an understanding of basic accounting practices and techniques including double-entry bookkeeping. It can be treated as a stand alone qualifcation or used as a stepping stone to further AAT study at Level 3.

Once you have registered here please complete and return the application form at the back of the briefing pack, this pack can be found on our website http://www.finance.admin.cam.ac.uk/training/professional-qualifications/aat/university-programme

« Description not available »

The AAT Level 3, Diploma in Accounting, introduces to students to more complex financial processes and accounting tasks, the principles of VAT, professional ethics and develops their spreadsheet skills.

This course is aimed at new iProcurement users and provides an introduction to using iProcurement for creating requisitions and purchase orders.

* Please read all the information below carefully before booking, as the sessions you need to attend depends on your role within the department *

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.

« Description not available »

This course covers the various month-end processes that need to be completed within the iProcurement module.

The AAT Foundation Certificate in Bookkeeping is the starting point for studying the AAT qualfiication.

It is a short qualification which will help you to develop essential bookkeeping skills. Once completed, you will have an understanding of basic accounting practices and techniques including double-entry bookkeeping. It can be treated as a stand alone qualifcation or used as a stepping stone to further AAT study at Level 3.

Once you have registered here please complete and return the application form at the back of the briefing pack, this pack can be found on our website http://www.finance.admin.cam.ac.uk/training/professional-qualifications/aat/university-programme

To provide an opportunity for someone from elsewhere in Finance Division to spend half a day in the Financial Reporting Team to get an overview and appreciation of what they do.

The AAT Level 3, Diploma in Accounting, introduces to students to more complex financial processes and accounting tasks, the principles of VAT, professional ethics and develops their spreadsheet skills.

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:

• Grants Part 2 COGNOS Reporting
• General Ledger Reporting

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.

AAT Level 4, Professional Diploma in accounting.

The dates below are assuming that we have a bespoke day release group. If this is not possible, then the dates will be different.

Once you have registered here please complete and return the application form at the back of the briefing pack, this pack can be found on our website http://www.finance.admin.cam.ac.uk/training-and-development/professional-qualification/aat/university-programme

This course is aimed at new iProcurement users and provides an introduction to using iProcurement for creating requisitions and purchase orders.

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.

AAT Level 4, Professional Diploma in accounting.

The dates below are assuming that we have a bespoke day release group. If this is not possible, then the dates will be different.

Once you have registered here please complete and return the application form at the back of the briefing pack, this pack can be found on our website http://www.finance.admin.cam.ac.uk/training-and-development/professional-qualification/aat/university-programme

« Description not available »

To provide an opportunity for someone from elsewhere in Finance Division to spend half a day in the Treasury & Investments Team to get an overview and appreciation of what they do. The Treasury & Investments team are ofering two sessions, one on Treasury and one on Investments. Ideally participants should attend this one (Treasury) before attending the Investments session however this is not a pre-requisite.

To provide an opportunity for someone from elsewhere in Finance Division to spend half a day in the Financial Reporting Team to get an overview and appreciation of what they do.

To provide an opportunity for someone from elsewhere in Fin Ops to spend a day in the Accounting Services Team to get an overview and appreciation of what they do.

An overview of how the University departments can utilise Key Travel

• Accessing the Key Travel website
• Registering travel buyers and creating profiles
• Features and facilities available
• Requesting quotes
• Making bookings

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

« Description not available »

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 covers the various month-end processes that need to be completed within the iProcurement module.

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:

• Grants Part 2 COGNOS Reporting
• General Ledger Reporting

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.

This course builds on the knowledge gained in AP Part 1. The delegates will learn how to match invoices to purchase orders, add in freight charges and process invoices from other departments. The course also covers international payments including accounting for VAT and foreign currencies. Delegates will also learn more about month end procedures and AP Reports.

Due to the decommissioning of the Discoverer reporting tool, a number of Cognos reports have either been adapted or specially written to bridge the gap. This course is aimed at users who would like to update their Cognos skills. The functionality of Cognos will be covered, rather than report output. However, differences between Discoverer and the new Cognos reports will be highlighted.

This session will cover year end processes in more detail than the road shows and will include:

• Outline of the year end timetable to be followed
• Specific procedures and tasks for each module
• Guidance on journals especially accruals, prepayments and transfer codes
• Making better use of the COGNOS reporting tool
• Exploring areas that often cause problems
• Practical advice on how to prioritise during key periods

This session will cover year end processes in more detail than the road shows and will include:

• Outline of the year end timetable to be followed
• Specific procedures and tasks for each module
• Guidance on journals especially accruals, prepayments and transfer codes
• Making better use of the COGNOS reporting tool
• Exploring areas that often cause problems
• Practical advice on how to prioritise during key periods

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

« Description not available »

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.

« Description not available »

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.

« Description not available »

This course covers the day to day and month end transactions that need to be completed using a variety of tools in CUFS.

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.

To provide an opportunity for someone from elsewhere in Fin Ops to spend a day in the Central and Research Accounting Team to get an overview and appreciation of what they do including Fixed Assets, Fee Collection, Property Accounting, Trust Funds and Research Accounting.

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:

• Grants Part 2 COGNOS Reporting
• General Ledger Reporting

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.

To provide an opportunity for someone from elsewhere in Fin Ops to spend a day in the Accounting Services Team to get an overview and appreciation of the function of the Helpdesk and Cashier.

To provide an opportunity for someone from elsewhere in Finance Division to spend half a day in the Financial Reporting Team to get an overview and appreciation of what they do.

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 covers the day to day and month end transactions that need to be completed using a variety of tools in CUFS.

The AAT Level 3, Diploma in Accounting, introduces to students to more complex financial processes and accounting tasks, the principles of VAT, professional ethics and develops their spreadsheet skills.

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:

• Grants Part 2 COGNOS Reporting
• General Ledger Reporting

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.

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.

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.

This course builds on the knowledge gained in AP Part 1. The delegates will learn how to match invoices to purchase orders, add in freight charges and process invoices from other departments. The course also covers international payments including accounting for VAT and foreign currencies. Delegates will also learn more about month end procedures and AP Reports.

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.

To provide an opportunity for someone from elsewhere in Fin Division to spend half a day in the Treasury & Investments Team to get an overview and appreciation of what they do. The Treasury & Investments team are offering two sessions, one on Treasury and one on Investments. Ideally the Treasury session should be attended before this one (Investments) however this is not a pre-requisite.

The AAT Level 3, Diploma in Accounting, introduces to students to more complex financial processes and accounting tasks, the principles of VAT, professional ethics and develops their spreadsheet skills.

Back by popular demand

We have decided to add an extra CPD session this year. There have been a number of requests for an additional session with a University specific focus and so Spencer Moore (Acting Head of Tax/International and Corporate Tax Manager) will be covering some of the tax issues that we need to be aware of.

Qualified staff can use this towards their annual CPD.

AAT Level 4, Professional Diploma in accounting.

Students will be placed on the public day release programme with the external provider

Once you have registered here you will need to complete the application form at the back of the briefing pack. This pack is available on our website https://www.finance.admin.cam.ac.uk/training/professional-qualifications/aat/university-programme The remaining dates will be added once they have been confirmed

To provide an opportunity for someone from elsewhere in Finance Division to spend a half day in the Payroll Team to get an overview and appreciation of what they do.

The AAT Level 3, Diploma in Accounting, introduces to students to more complex financial processes and accounting tasks, the principles of VAT, professional ethics and develops their spreadsheet skills.

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.

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

Topics covered:

• Extracting data from CUFS and COGNOS
• Basic formatting
• Basic formulas
• Navigating large spreadsheets
• Advanced formulas
• Conditional formatting
• Data validation
• Protecting cells and sheets
• Lookup function
• Pivot tables
• Charts and graphs
• Using data in other documents

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.

« Description not available »

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:

• Grants Part 2 COGNOS Reporting
• General Ledger Reporting

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.

This session provides you with a simple overview of the basics and how VAT applies to the University.

This course covers the various month-end processes that need to be completed within the iProcurement module.

To provide an opportunity for someone from elsewhere in Fin Ops to spend half a day in the Shared Services and Staff Bureau to get an overview and appreciation of what they do.

AAT Level 4, Professional Diploma in accounting.

Students will be placed on the public day release programme with the external provider

Once you have registered here you will need to complete the application form at the back of the briefing pack. This pack is available on our website https://www.finance.admin.cam.ac.uk/training/professional-qualifications/aat/university-programme The remaining dates will be added once they have been confirmed

The AAT Level 3, Diploma in Accounting, introduces to students to more complex financial processes and accounting tasks, the principles of VAT, professional ethics and develops their spreadsheet skills.

AAT Level 4, Professional Diploma in accounting.

Students will be placed on the public day release programme with the external provider

Once you have registered here you will need to complete the application form at the back of the briefing pack. This pack is available on our website https://www.finance.admin.cam.ac.uk/training/professional-qualifications/aat/university-programme The remaining dates will be added once they have been confirmed

Demo on basic use of Macros

The AAT Level 3, Diploma in Accounting, introduces to students to more complex financial processes and accounting tasks, the principles of VAT, professional ethics and develops their spreadsheet skills.

To provide an opportunity for someone from elsewhere in Fin Ops to spend half a day in the Shared Services and Staff Bureau to get an overview and appreciation of what they do.

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 enables users to learn the basics of how the General Ledger module works, how to run online account enquiries and how to process journals.

Project Indigo- Invoice scanning : what we hope the solution will look like, figurative timelines, some of the challenges and the type of deployment (e.g. phased roll out)

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:

• Grants Part 2 COGNOS Reporting
• General Ledger Reporting

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.

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.

To provide an opportunity for someone from elsewhere in Fin Ops to spend a day in the Accounting Services Team to get an overview and appreciation of the function of the Helpdesk and Cashier.

Looking at a template to write business cases, to provide information on what to include, for lightweight business cases and more detailed business cases. Providing some hints and tips to assist with business case writing.

To provide an opportunity for someone from elsewhere in Fin Division to spend half a day in the Treasury & Investments Team to get an overview and appreciation of what they do. The Treasury & Investments team are offering two sessions, one on Treasury and one on Investments. Ideally the Treasury session should be attended before this one (Investments) however this is not a pre-requisite.

« Description not available »

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

Topics covered:

• Extracting data from CUFS and COGNOS
• Basic formatting
• Basic formulas
• Navigating large spreadsheets
• Advanced formulas
• Conditional formatting
• Data validation
• Protecting cells and sheets
• Lookup function
• Pivot tables
• Charts and graphs
• Using data in other documents

This course covers the day to day and month end transactions that need to be completed using a variety of tools in CUFS.

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.

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:

• Grants Part 2 COGNOS Reporting
• General Ledger Reporting

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.

« Description not available »

The AAT Level 3, Diploma in Accounting, introduces to students to more complex financial processes and accounting tasks, the principles of VAT, professional ethics and develops their spreadsheet skills.

A bespoke session to provide an overview and guidance on how VAT applies to Research Grants. Including:

• How to establish the correct VAT rate to attribute to an award when it is set up in CUFS
• Why it is so important
• How the VAT rate attributed affects expenditure subsequently coded to the grant

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.

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

Topics covered:

• Extracting data from CUFS and COGNOS
• Basic formatting
• Basic formulas
• Navigating large spreadsheets
• Advanced formulas
• Conditional formatting
• Data validation
• Protecting cells and sheets
• Lookup function
• Pivot tables
• Charts and graphs
• Using data in other documents

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 covers the essentials for keeping your AR accounts in order. In addition to showing you how to make corrections, receipt foreign currencies and the required month/year-end reports we will also show you how you can save time by setting up memo lines, sales persons and receivable activities for your department.

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.

« Description not available »