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

CANCELLED

Provided by: University Information Services - Digital Literacy Skills


Booking

Bookings cannot be made on this event (Event is not taking bookings).


Other dates:

No more events

[ Show past events ]



Booking / availability

Excel 2016: Managing Data & Lists
Prerequisites

Thu 18 Jun 2020
CANCELLED

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.

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 18 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