skip to navigation skip to content
Thu 13 Jun 2019
09:30 - 13:00

Venue: University Information Services, Phoenix Teaching Room 1, New Museums Site

Provided by: University Information Services


Booking

Bookings cannot be made on this event (Event is completed).


Other dates:


2019


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

Thu 13 Jun 2019

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 Thu 13 Jun   09:30 - 13:00 09:30 - 13:00 University Information Services, Phoenix Teaching Room 1, New Museums Site map Simon Meaker
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