Excel 365: For Beginners (In Person Face to Face) BeginnersPrerequisites
Tue 29 Sep 2026
Description
This is course will help you get to grips with spreadsheet basics using Microsoft Excel. It will be taught in a small group and no previous knowledge is assumed, however those that use Excel at a basic level will also learn new tricks and tips which will serve them well in saving time day to day and increasing knowledge.
- This is the In Person Face to Face version of the Live Online 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
- Basic computer skills i.e. familiarity with using a keyboard and mouse will be assumed.
- The course is aimed at beginners - no previous knowledge or experience of the software is assumed, however those who wish to improve their skills will learn some tips
Sessions
Number of sessions: 1
| # | Date | Time | Venue | Trainer | |
|---|---|---|---|---|---|
| 1 | Tue 29 Sep 09:30 - 13:00 | 09:30 - 13:00 | University Information Services, Roger Needham Building, Ely Training Room 1 | map | Lynn Foot |
Topics covered
- Building a new workbook (data entry and simple formulae)
- Modifying an existing workbook
- Enhancing the appearance of a worksheet
- Data Formatting
- Worksheet Techniques
- Page Setup for Printing
Objectives
By the end of this course, participants will be able to:
- Create and Modify Workbooks
- Build a new workbook by entering data and applying simple formulas.
- Modify existing workbooks by editing content, formatting cells, and updating formulas.
- Format and Enhance Worksheets
- Apply data formatting techniques to improve clarity and presentation.
- Enhance the appearance of worksheets using borders, shading, and font styles.
- Use Worksheet Techniques
- Navigate worksheets efficiently and apply basic techniques such as resizing columns, freezing panes, and sorting data.
- Prepare for Printing
- Set up page layout options including orientation, margins, and scaling.
- Preview and print worksheets with professional formatting.
Format
- Presentation, demonstration and practical activities
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.
What we expect from participants
- Please arrive at least 15 minutes before the start time to avoid disruptions.
- Participants are expected to actively engage with the lesson and the trainer and there will be activities to do.
- PC’s are provided in our training rooms but if you wish to bring and use your own laptop you can do.
- Feel free to ask questions at any time.
- We welcome your interaction throughout the course. Your contribution will enhance your own experience as well as that of others. Thank you.
Duration
- One half day session
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 (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 - Essential Training (Office 365/Microsoft 365) (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 365: Learning Excel Desktop (Microsoft 365) (Online)
- LiL: Excel 365: 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: 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 - 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