Let Excel do the Thinking

Friday 6 November

10:00–11:00 Book Your Place

(Registrations close 05/11/26 16:00)

Can't make this date?

Further dates will be added in 2027

Please note: This Masterclass uses Microsoft 365 Excel features. Some features demonstrated may not be available in older versions of Excel. 

Bookings are non-refundable and non-transferable. Please ensure you can attend before booking. View Booking & Cancellation Policy 

All times shown are UK time.

Many Excel users spend time manually searching, counting, checking and filtering information to answer everyday business questions.

What is the total cost? Which records need attention? Which orders are overdue? How much has each department spent? Which information should management see?

The data is often already there. The challenge is getting Excel to answer those questions for you.

This Masterclass explores practical functions and techniques that can reduce repetitive work and help Excel return the information you need.

Build formulas without starting from scratch

Use Excel's function tools to help build formulas correctly and reduce problems with formula syntax.

Turn business rules into Excel logic

Use functions including IF, AND, IFS and SWITCH to automatically identify, categorise and respond to different situations in your data.

Calculate using specific criteria

Use functions such as SUMIF to answer questions without repeatedly filtering and calculating information manually.

Show only the information you need

Use the FILTER function to create automatically updating views based on the criteria that matter to you.

Create useful lists automatically

Use UNIQUE to extract distinct information from your data without sorting, copying or manually removing duplicates.

Create simpler views and combine data

Explore CHOOSECOLS and VSTACK to display selected information and bring data from separate lists together. 

This session is designed for everyday Excel users who already work with spreadsheets but want Excel to do more of the repetitive work for them.

It's particularly useful if you regularly find yourself:

Counting or calculating information · Checking records · Applying the same rules repeatedly · Filtering data to answer questions · Creating separate lists or views · Combining information from different sources

You don't need to be an advanced Excel user, but you should already be comfortable working with basic spreadsheets and data.

The learning doesn't have to stop when the Masterclass ends. You'll also receive practical resources designed to help you revisit the key techniques and apply them in your workplace.

Masterclass Companion Guide

A practical reference guide covering the key techniques from the session, so you can revisit what you've learned when you need it.

7-Day Productivity Challenge

Simple follow-up activities designed to encourage you to apply what you've learned in your own workplace over the following week.

Certificate of Attendance

A PDF certificate confirming your attendance at the Workplace Productivity Masterclass.

Learn it | Apply it | Make it part of the way you work.

This is a live, instructor-led session built around everyday Excel questions and workplace scenarios, with practical demonstrations and opportunities to participate and ask questions.

Live online
Join from wherever you're based.

Practical demonstrations
See Excel techniques being used to solve real workplace problems.