skip to navigation skip to content

Finance Training

Reset

Filter by

Course type

Show only:



Dates available




Places available



Filter search

Browse or search for courses


2 matching courses
Courses per page: 10 | 25 | 50 | 100
Clear search


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.

3 other events...

Date Availability
Mon 7 Dec 2020 09:30 [Places]
Wed 20 Jan 2021 09:30 [Places]
Tue 2 Mar 2021 09:30 [Places]

This is a pilot of the new virtual course

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

3 other events...

Date Availability
Tue 15 Dec 2020 09:30 [Places]
Tue 2 Feb 2021 09:30 [Places]
Wed 24 Mar 2021 09:30 [Places]