Virtual - How to Excel - Part 1 & 2 (For Finance Staff) Updated
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.
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.
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 | Wed 9 Sep 2020 09:30 - 11:30 | 09:30 - 11:30 | Finance Division, At Participant's Desk | Helen Parker |
| 2 | Thu 10 Sep 2020 09:30 - 11:30 | 09:30 - 11:30 | Finance Division, At Participant's Desk | Helen Parker |
- 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
The course will run as 2 webinars with exercises to complete between them. The first webinar will have time midway through to complete exercises and there will be practice exercises set after each webinar
Booking / availability