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 staff only who would like to develop their spreadsheet skills
Number of sessions: 2
# | Date | Time | Venue | Trainer | |
---|---|---|---|---|---|
1 | Wed 12 Sep 2018 09:30 - 12:30 | 09:30 - 12:30 | University Information Services, 17 Mill Lane Training Room | map | Helen Parker |
2 | Wed 19 Sep 2018 09:30 - 12:30 | 09:30 - 12:30 | University Information Services, 17 Mill Lane Training Room | map | Helen Parker |
Two half day sessions
Booking / availability