skip to navigation skip to content
- Select training provider - (University Information Services - Digital Literacy Skills)
Thu 6 Jun 2024
09:30 - 13:00

Venue: University Information Services, Roger Needham Building, Ely Training Room 1

Provided by: University Information Services - Digital Literacy Skills


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.

Booking / availability

Excel 365: Managing Data & Lists (In Person Face to Face)

Thu 6 Jun 2024


Want to make it easier and more efficient when working with data in Excel? You'll e surprised how much you can do with Excel when managing your data. You will learn tips and tricks that will save you time over the course of your studies/career which can be transferred to home live too.

  • This is the In Person Face to Face version of the Live Online Excel: Data & Lists course.

Please Note: It is important that when you book on this course, on your booking confirmation page, click on Add to Calendar to start the process to import the course appointment into your calendar.

  • See Related Courses below to take your skills further
Target audience
  • All current Cambridge University members (departments and colleges)
  • Further details regarding eligibility criteria are available

Number of sessions: 1

# Date Time Venue Trainer
1 Thu 6 Jun   09:30 - 13:00 09:30 - 13:00 University Information Services, Roger Needham Building, Ely Training Room 1 map Hazel Turton
Topics covered
  • Sorting
  • Filtering
  • Grouping and Outlining
  • Summarising and Subtotalling
  • Validating Data
  • Conditional Formatting
  • Protecting Data
  • At the completion of this course you should be able to:
  • Sort Data in a list in a worksheet
  • Filter Data in a table
  • Group and Outline Data
  • Create summaries using Summarise and Subtotal
  • Validate Data using a variety of techniques
  • Use Conditional Formatting options
  • Protect Data on Worksheets and Workbooks
  • Presentation, demonstration and practical activities
Taught using
  • Excel 365 on Microsoft Windows
  • The course will be taught using Excel 365 on PCs but will also be suitable for Excel 2016/2019 users. Apple Mac users of Outlook should also find it useful.
  • Course files can be downloaded here
  • One half day session
  • Termly
Related courses

Booking / availability