skip to navigation skip to content
Wed 11 Dec, Wed 18 Dec 2019
09:30, ...

Venue: Finance Division, Greenwich House, Ferrara Room (IT Training Room)

Provided by: Finance Training


Booking
There are places available Book a place
(Provisional)

NOTE: Bookings on this event require approval by the event administrator.

You may make a provisional booking using this page, but your place will not be confirmed until the booking has been approved.

Other dates:


2020


[ Show past events ]



Register interest
Register your interest - if you cannot make any of the currently scheduled dates and would be interested in additional dates being scheduled.


Booking / availability

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

Wed 11 Dec, Wed 18 Dec 2019

Description

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 which may suit your requirements better.

Prerequisites

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

Sessions

Number of sessions: 2

# Date Time Venue Trainer
1 Wed 11 Dec   09:30 - 12:30 09:30 - 12:30 Finance Division, Greenwich House, Ferrara Room (IT Training Room) map Max Smith
2 Wed 18 Dec   13:30 - 16:30 13:30 - 16:30 Finance Division, Greenwich House, Ferrara Room (IT Training Room) map Max Smith
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
Format

Presentation with guided practical exercises.

Duration

Two half day sessions.

Related courses
Theme
Reporting

Booking / availability