Excel 2016: Managing Data & Lists Prerequisites
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
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: Analysing and Summarising Data
- Excel 2016: Functions
- Excel 2016: Introduction
- Excel 2016: Introduction (Self-paced)
- Excel 2016: Recorded Macros
- Office 2016: Excel, Word and PowerPoint Top Ten Tips
- Office 365, Office Online and OneDrive: An introduction
Theme
Research
Events available