skip to navigation skip to content
Instructor-led course

Provided by: University Information Services


This course has 4 scheduled runs. To book a place, please choose your preferred date:


2017


2018


[ Show past events ]

Events available

Excel 2016: Managing Data & Lists
Prerequisites


Description
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
Themes

Events available