skip to navigation skip to content
- Select training provider - (University Information Services - Digital Literacy Skills)
Instructor-led course

Provided by: University Information Services - Digital Literacy Skills


This course has 2 scheduled runs. To book a place, please choose your preferred date:


2024


[ Show past events ]

Events available

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


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

Events available