Make Sense of Your Excel Data

New dates coming in 2027

Further dates for this Masterclass will be announced soon

Looking for a Masterclass in 2026? 

Other Workplace Productivity Masterclasses are available to book this year. View 2026 Masterclasses

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

A spreadsheet can contain hundreds or thousands of rows of information — but having the data doesn't automatically give you the answers you need.

Which areas need attention? Where are the risks? What are the trends? How can you summarise all that information without manually working through every row?

This Masterclass explores practical Excel tools that help you move beyond simply storing data and start using it to answer meaningful business questions.

Organise data to find what matters

Use sorting and filtering techniques to quickly explore larger datasets and focus on the information you need.

Highlight important information

Use conditional formatting to make patterns, exceptions and areas requiring attention easier to identify.

Summarise large amounts of data

Use PivotTables to turn hundreds of records into meaningful summaries without creating complex formulas.

Explore information from different perspectives

Rearrange and filter PivotTable data to answer different business questions and investigate what's happening within your data.

Make analysis easier to explore

Use slicers and timelines to create quick, visual ways to filter information and investigate particular areas or periods.

Present patterns and trends more clearly

Use PivotCharts and Sparklines to make important patterns and changes in your data easier to see and communicate.

This session is designed for everyday Excel users who work with lists, reports or larger sets of business data and want to get more useful information from them.

It's particularly useful if you regularly find yourself:

Sorting through large spreadsheets · Repeatedly filtering data · Manually creating summaries · Looking for patterns or exceptions · Answering questions about performance or trends · Turning spreadsheet data into management information

You don't need to be an advanced Excel user or know complex formulas. The focus is on practical analysis tools that help you understand the data you already have.

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 a realistic workplace dataset and the questions that might be asked of it. You'll see practical Excel analysis tools being used to turn rows of information into useful answers.

Live online
Join from wherever you're based.

Practical demonstrations
See Excel analysis techniques being used to answer realistic business questions.