skip to navigation skip to content
Tue 25 Feb 2020
09:30 - 13:00

Venue: University Information Services, Titan Teaching Room 2, New Museums Site

Provided by: University Information Services


Booking
There are standby places available Book a place

Other dates:


2020


[ Show past events ]



Register interest
Register your interest - if you cannot make any of the currently scheduled dates and would be interested in additional dates being scheduled.


Booking / availability

Excel 2016: Managing Data & Lists
Prerequisites

Tue 25 Feb 2020

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
Sessions

Number of sessions: 1

# Date Time Venue Trainer
1 Tue 25 Feb 2020   09:30 - 13:00 09:30 - 13:00 University Information Services, Titan Teaching Room 2, New Museums Site map Lynn Foot
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

Booking / availability