skip to navigation skip to content
Thu 18 Jun, Thu 25 Jun 2020
13:00, ...


Provided by: Finance Training


Bookings cannot be made on this event (Event is not taking bookings).

Other dates:

No more events

Booking / availability

How to Excel - Part 1 & 2 (For Finance Staff)

Thu 18 Jun, Thu 25 Jun 2020


NOTE This classroom-based course may not go ahead depending on the circumstances at the time. You can join our VIRTUAL course, delivered via Microsoft Teams, at

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.

Target audience

This course is aimed at staff in a financial role who would like to develop their spreadsheet skills using data from CUFS.

If you would like a more generalised Excel course to learn from, there are many courses here provided by UIS which may suit your requirements better.


We will need to ensure you are working in a finance role within the University as staff before confirming your booking.


Number of sessions: 2

# Date Time Venue Trainer
1 Thu 18 Jun   13:00 - 16:00 13:00 - 16:00 Finance Division, Greenwich House, Ferrara Room (IT Training Room) map Max Smith
2 Thu 25 Jun   13:30 - 16:30 13:30 - 16:30 Finance Division, Greenwich House, Ferrara Room (IT Training Room) map Max Smith
Topics covered
  • 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

Presentation with guided practical exercises.


Two half day sessions.


Booking / availability