How to Excel 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 anyone who would like to develop their spreadsheet skills
Number of sessions: 2
# | Date | Time | Venue | Trainer | |
---|---|---|---|---|---|
1 | Wed 29 Nov 2017 09:30 - 13:00 | 09:30 - 13:00 | Finance Division, Greenwich House, Ferrara Room (IT Training Room) | map | Helen Parker |
2 | Wed 6 Dec 2017 09:30 - 13:00 | 09:30 - 13:00 | Finance Division, Greenwich House, Ferrara Room (IT Training Room) | map | Helen Parker |
Two half day sessions
Booking / availability