How to Excel for Finance Staff NewUpdated
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.
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
This course is aimed at finance staff only who would like to develop their spreadsheet skills
Number of sessions: 2
# | Date | Time | Venue | Trainer | |
---|---|---|---|---|---|
1 | Thu 18 Oct 2018 13:00 - 16:00 | 13:00 - 16:00 | University Information Services, 17 Mill Lane Training Room | map | Helen Parker |
2 | Thu 25 Oct 2018 13:00 - 16:00 | 13:00 - 16:00 | University Information Services, 17 Mill Lane Training Room | map | Helen Parker |
Two half day sessions
Booking / availability