How to Excel NewUpdated
Mon 16 Apr, Mon 23 Apr 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 anyone who would like to develop their spreadsheet skills
Sessions
Number of sessions: 2
| # | Date | Time | Venue | Trainer | |
|---|---|---|---|---|---|
| 1 | Mon 16 Apr 2018 09:30 - 13:00 | 09:30 - 13:00 | Finance Division, Greenwich House, Ferrara Room (IT Training Room) | map | Helen Parker |
| 2 | Mon 23 Apr 2018 09:30 - 13:00 | 09:30 - 13:00 | Finance Division, Greenwich House, Ferrara Room (IT Training Room) | map | Helen Parker |
Duration
Two half day sessions
Booking / availability