skip to navigation skip to content

Finance Training


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
Tue 20 Oct 2020 09:30 Not bookable
Wed 20 Jan 2021 09:30 [Places]
Tue 2 Mar 2021 09:30 [Places]

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
Wed 28 Oct 2020 09:30 Not bookable
Tue 2 Feb 2021 09:30 [Places]
Wed 24 Mar 2021 09:30 [Places]