skip to navigation skip to content
- Select training provider - (University Information Services - Digital Literacy Skills)
Wed 20 Mar 2024
09:30 - 13:00

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

Provided by: University Information Services - Digital Literacy Skills


Booking

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


Other dates:


Thu 6 Jun 2024


[ Show past events ]



Booking / availability

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

Wed 20 Mar 2024

Description

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
Prerequisites
Sessions

Number of sessions: 1

# Date Time Venue Trainer
1 Wed 20 Mar   09:30 - 13:00 09:30 - 13:00 University Information Services, Roger Needham Building, Ely Training Room 1 map Lynn Foot
Topics covered
  • Sorting
  • Filtering
  • Grouping and Outlining
  • Summarising and Subtotalling
  • Validating Data
  • Conditional Formatting
  • Protecting Data
Objectives
  • 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
Format
  • Presentation, demonstration and practical activities
Taught using
  • Excel 365 on Microsoft Windows
Notes
  • 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
Duration
  • One half day session
Frequency
  • Termly
Related courses
Themes

Booking / availability