How to Excel NewUpdated
Mon 25 Jun, Mon 2 Jul 2018
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
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
Target audience
This course is aimed at staff only who would like to develop their spreadsheet skills
Sessions
Number of sessions: 2
| # | Date | Time | Venue | Trainer | |
|---|---|---|---|---|---|
| 1 | Mon 25 Jun 2018 13:00 - 16:00 | 13:00 - 16:00 | Finance Division, Greenwich House, Ferrara Room (IT Training Room) | map | Helen Parker |
| 2 | Mon 2 Jul 2018 13:00 - 16:00 | 13:00 - 16:00 | Finance Division, Greenwich House, Ferrara Room (IT Training Room) | map | Helen Parker |
Duration
Two half day sessions
Booking / availability