Excel 2016: Managing Data & Lists Prerequisites
Description
Bookings for this course are placed on hold in response to the rapidly changing events due to COVID-19. The status of these courses will be reviewed towards the end of April 2020. See the University's COVID-19 page for up to date information.
- 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
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
Theme
Research
Events available