skip to navigation skip to content

Map

Venue: Phoenix Teaching Room 1, New Museums Site

Provided by: University Information Services - Digital Literacy Skills

Booking

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

Other dates:

No more events

[ Show past events ]

Register interest

Register your interest - if you would be interested in additional dates being scheduled.

Excel 2016: Managing Data & Lists
Prerequisites

Thu 13 Jun 2019

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

Sessions

Number of sessions: 1

#	Date	Time	Venue		Trainer
1	Thu 13 Jun 2019 09:30 - 13:00	09:30 - 13:00	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

Theme

Research