Excel 365: Managing Data & Lists (In Person Face to Face) Prerequisites
Wed 26 Apr 2023
CANCELLED
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.
This hands-on course is a follow up from the Excel 365: For Beginners and Improvers course which comes in 2 forms:
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
- Good competency in Excel will be assumed
- Attendance of or equivalent knowledge of Excel: Beginners and Improvers
Sessions
Number of sessions: 1
| # | Date | Time | Venue | Trainer | |
|---|---|---|---|---|---|
| 1 | Wed 26 Apr 2023 09:30 - 13:00 | 09:30 - 13:00 | University Information Services, Roger Needham Building, Ely Training Room 1 | map | Simon Meaker |
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
- Excel 2016: Introduction
- Excel 365: Managing Data & Lists (In Person Face to Face)
- Excel 365: Managing Data & Lists (Live Online using MS Teams)
- Excel 365: Pivot Tables (Live Online using MS Teams)
- Excel 365: Analysing & Summarising Data (Live Online using MS Teams)
- Excel 365: For Beginners (In Person Face to Face)
- Excel 365: Functions (Live Online using MS Teams)
- Excel 365: Analysing & Summarising Data (In Person Face to Face)
- Excel 365: Pivot Tables (In Person Face to Face)
- LiL: Excel - Avoiding Common Mistakes (365/2019) (Online)
- LiL: Excel - Essential Training (Office 365/Microsoft 365) (Online)
- LiL: Excel - Excel Online Tips and Tricks (Microsoft 365)
- LiL: Excel for Mac - Advanced Formulas and Functions (365/2019) (Online)
- LiL: Excel - Learning Excel Online (Office 365) (Online)
- LiL: Excel - Lookup functions in depth (365/2019) (Online)
- LiL: Excel - Macros in Depth (365/2019) (Online)
- LiL: Excel - Managing and Analysing Data in Excel (Office 365/Excel 365) (Online)
- LiL: Excel - Quick Tips (Office 365/Microsoft 365) (Online)
- LiL: Excel - Productivity Tips (365/2019) (Online)
- LiL: Excel - 20 Nano Tips for Maximizing Excel (Online)
- LiL: Excel - Advanced Formatting Techniques (Online)
- LiL: Excel - Advanced Formulas and Functions (Online)
- LiL: Excel - Charts in Depth (Online)
- LiL: Excel - Creating Drop-Down Lists (Online)
- LiL: Excel - Pivot Tables in Depth (Online)
- LiL: Excel Pivot Tables: Mastering Pivot Tables and Pivot Charts (Online)
- LiL: Excel - Pivot Tables Quick Tips (Online)
- LiL: Excel - Pivot Tables: Real-World Case Studies (Online)
- LiL: Excel - Power Pivot for Beginners (Online)
- LiL: Excel - Power Query for Beginners (Online)
- LiL: Excel - Setting Up a Database (Office 365/Microsoft 365) (Online)
- LiL: Excel - Spreadsheet Design Extreme Makeover (Online)
- LiL: Excel - Tips and Tricks (Online)
- LiL: Excel - Vlookup and Xlookup for Beginners (Office 365/Microsoft 365) (Online)
Themes
Booking / availability