Excel 2016: Managing Data & Lists PrerequisitesUpdated
Tue 20 Jun 2017
Description
- This hands-on course is a follow up from the Excel: Introduction course.
Target audience
- All current Cambridge University members (departments and colleges)
- Further details regarding eligibility criteria are available
Prerequisites
- Good competency in Excel will be assumed
- Attendance of Excel: Introduction or equivalent knowledge
Sessions
Number of sessions: 1
# | Date | Time | Venue | Trainers | |
---|---|---|---|---|---|
1 | Tue 20 Jun 2017 14:00 - 17:00 | 14:00 - 17:00 | Phoenix Teaching Room 1, New Museums Site | map | Lynn Foot, Emma Lilley |
Topics covered
- Importing and exporting data
- Sorting
- Filtering
- Grouping and Outlining
- Summarising
- Validating Data
- Protecting Data
- Conditional Formatting
- Sparklines
Format
- Presentation, demonstrations and self-paced practicals
Taught using
Excel 2016 on MCS Windows
Notes
- The course will be taught using Excel 2010 on PCs but will also be suitable for Excel 2007/2013 users. Apple Mac users of Excel 2011 should also find it useful.
- Anyone wishing to copy the course exercise files should bring a USB memory stick they can be downloaded
Duration
- One half day session
Related courses
- Excel 2016: Introduction
- Excel 2016: Introduction (Self-paced)
- Excel 2016: Analysing and Summarising Data
Theme
Research
Booking / availability