Excel for CamSIS Users Prerequisites
Tue 15 Nov 2016
Description
Delegates will learn how to use shortcuts in Excel to improve their productivity, and also techniques for analysing complex data quickly by using pivot tables.
Target audience
- College Staff
- Further details regarding CamSIS' eligibility criteria are available
Prerequisites
- Participants should have attended the CamSIS: An Introduction course or have equivalent knowledge
Sessions
Number of sessions: 1
| # | Date | Time | Venue | Trainer | |
|---|---|---|---|---|---|
| 1 | Tue 15 Nov 2016 14:00 - 17:00 | 14:00 - 17:00 | University Information Services, Roger Needham Building, Ely Training Room 2 | map | John Hocking |
Topics covered
- Sheet navigation – keyboard shortcuts
- Changing column width - shortcut
- Deleting data
- Formatting data – Dates
- Formatting data – Text
- Formatting data –conditional formatting
- Using and protecting formulae
- Freezing panes
- Sorting and filtering
- Pivot Tables
- Inserting, colouring and renaming worksheets
Objectives
To be able to:
- Quickly navigate around an Excel spreadsheet
- Format the data
- Sort and filter the data
- Use Pivot Tables to view the data in a different and clearer way
Aims
To become familiar with shortcuts in Excel, and the use of Pivot Tables for analysing data.
Format
Presentations, demonstrations and practicals
Duration
One half day session
Frequency
Monthly
Related courses
- Advanced CamSIS Search [Provided by CamSIS Training]
- Basic Student Financials in CamSIS [Provided by CamSIS Training]
- Basic Reporting (CamSIS Search, Queries and Reports) [Provided by CamSIS Training]
Themes
Booking / availability