Think you know the Excel ribbons? Think again. In this lunch and learn series, John Tennent, Chartered Accountant and Founder of Corporate Edge, will take you on a guided tour of the lesser known but incredibly useful features and functionality tucked away in the Excel ribbons.
File and Home
This first webinar in the series explores the essentials and how to get more from the File and Home Ribbons. John covered a range of features and functionality including applying cleaner number and date formats, and using tools like Format Painter, Conditional Formatting, and Cell Styles to make your spreadsheets more polished and consistent.
First broadcast on 03 September 2025
Webinar resources
Formulas and Data
In the second webinar in the series, John will explore how to simplify your formulas with Named Ranges, automate tasks with Flash Fill, and explore features like Data from Picture. He will also compare the pros and cons of using Sort and Filter buttons versus formula-based filtering.
First broadcast on 15 October 2025
Webinar resources
Insert
In the third webinar in the series, John will explore the Insert Ribbon to show you how to make your spreadsheets more interactive and visual with tools like Checkboxes, Sparklines, and Charts.
First broadcast on 12 November 2025
Webinar resources
Everything else
In the last webinar of the series, John will explore the features that often go unnoticed. You’ll learn more about protecting your sheets, working with multiple windows, using Function Buttons, the new Sheet view and getting started with Form Controls from the Developer tab.
Taking place on 10 December 2025
CPD
Join the Excel Community
Do you use Excel in your organisation? Are you using it to its maximum potential? Develop your skills and minimise spreadsheet risk with our Excel resources. Membership is open to everyone - non ICAEW members are also welcome to join.
