Excel 365: Top Tips - Bitesize Learning (In Person Face to Face)
Thu 16 May 2024
Description
This instructor-led course is for people who want to keep up to date with newer or the lesser-known features of Microsoft Excel. It is a quick fire succession of topics at a fast pace and aimed at those who are comfortable using computers.
- This is the In Person Face to Face version of the Live Online Excel: Top Tips
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 or equivalent knowledge of Excel 365: For Beginners and Improvers
Sessions
Number of sessions: 1
| # | Date | Time | Venue | Trainer | |
|---|---|---|---|---|---|
| 1 | Thu 16 May 09:30 - 11:00 | 09:30 - 11:00 | University Information Services, Roger Needham Building, Ely Training Room 1 | map | Simon Meaker |
Topics covered
- Templates
- Keyboard Shortcuts
- Highlight & Remove Duplicates
- Turn a List into Table
- Accessibility Checker
- Flash Fill
- Transpose Data using Paste Special
- Convert and other functions
- Create a Chart Template
- No effort Pivot Tables
- New Chart Types
- Turn Data into Maps
- Stock & Geographic Data Types
- The Analyze button
- Workbook Statistics
Format
- Instructor-led workshop
Notes
- The course files and slides can be downloaded here
- This course is taught on Windows desktop using Excel 365, if you have a different operating system or version of Excel, then there will some differences, but you are welcome to attend bearing that in mind.
Duration
- A session of one an a half hours (approximately)
Frequency
- Termly
Related courses
- Excel 365: Analysing & Summarising Data (In Person Face to Face)
- Excel 365: Analysing & Summarising Data (Live Online using MS Teams)
- Excel 365: For Beginners (In Person Face to Face)
- Excel 365: For Beginners (Live Online using MS Teams)
- Excel 365: Functions (In Person Face to Face)
- Excel 365: Functions (Live Online using MS Teams)
- Excel 365: Managing Data & Lists (In Person Face to Face)
- Excel 365: Managing Data & Lists (Live Online using MS Teams)
- Excel 365: Pivot Tables (In Person Face to Face)
- Excel 365: Pivot Tables (Live Online using MS Teams)
- Excel 365: Top Tips - Bitesize Learning (In Person Face to Face)
- Excel 365: Top Tips - Bitesize Learning (Live Online using MS Teams)
- Word 365: Top Tips - Bitesize Learning (In Person Face to Face)
- Word 365: Top Tips - Bitesize Learning (Live Online using MS Teams)
- LiL: Excel - 20 Nano Tips for Maximizing Excel (Online)
- LiL: Excel - Advanced Formulas and Functions (Online)
- LiL: Excel - Avoiding Common Mistakes (365/2019) (Online)
- LiL: Excel - Charts in Depth (Online)
- LiL: Excel - Conditional Formatting for Beginners - Office 365/Excel 2019 (Online)
- LiL: Excel - Creating Drop-Down Lists (Online)
- LiL: Excel - Data Validation in Depth (Online)
- LiL: Excel - Data Visualization: Mastering 20+ Charts and Graphs (Online)
- LiL: Excel - Excel Online Tips and Tricks (Microsoft 365)
- LiL: Excel - Filtering Data for Beginners (Online)
- LiL: Excel - Formulas and Functions Quick Tips (Online)
- LiL: Excel - Introduction to Formatting (Online)
- LiL: Excel - Introduction to Formulas and Functions (Microsoft 365) (Online)
- LiL: Excel - Learning Excel Desktop (Microsoft 365) (Online)
- LiL: Excel - Learning Excel Online (Office 365) (Online)
- LiL: Excel - Lookup functions in depth (365/2019) (Online)
- LiL: Excel - Miss Excel’s Top Productivity Hacks (Online)
- LiL: Excel - Nano Tips for Using Excel (Online)
- LiL: Excel - Pivot Tables for Beginners (Online)
- LiL: Excel - Pivot Tables in Depth (Online)
- LiL: Excel - Pivot Tables Quick Tips (Online)
- LiL: Excel - Pivot Tables: Real-World Case Studies (Online)
- LiL: Excel - Productivity Tips (365/2019) (Online)
- LiL: Excel - Quick Tips (Office 365/Microsoft 365) (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 - Tips Weekly (Online)
- LiL: Excel - Vlookup and Xlookup for Beginners (Office 365/Microsoft 365) (Online)
- LiL: Excel - Weekly Challenge (Online)
- LiL: Excel for Mac - Advanced Formulas and Functions (365/2019) (Online)
- LiL: Excel For Mac - Essential Training (Office 365/Microsoft 365) (Online)
Themes
Booking / availability