Stop Entering the Same Data Twice

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. 

Names in one worksheet. Departments in another. Training records somewhere else. Before long, the same information is being typed, copied and updated across multiple parts of a workbook.

That creates more work — and more opportunities for information to become inconsistent.

This Masterclass explores a better approach: creating a reliable source of information that Excel can reuse, so you can update data once rather than repeatedly entering the same information.

Structure your data more effectively

Understand some of the simple principles that make Excel data easier to manage, maintain and reuse.

Turn data into Excel Tables

Use Tables to create structured data that can expand automatically and provide a more reliable foundation for your workbook.

Create a single source of truth

Explore how master lists can help you maintain important information in one place rather than creating multiple versions.

Look up information automatically

Use XLOOKUP to retrieve information from a master list instead of repeatedly typing or copying it into different locations.

Control the information people enter

Use data validation and drop-down lists to make data entry quicker and help keep information consistent.

Build workbooks that are easier to maintain

Use structured references and clearer workbook design to make it easier to understand where information comes from and how it is being used

This session is designed for everyday Excel users who create, update or maintain workbooks containing information that is used in more than one place.

It's particularly useful if you regularly find yourself:

Retyping the same information · Copying data between worksheets · Maintaining several versions of the same list · Correcting inconsistent entries · Updating the same details in multiple places

You don't need to be an advanced Excel user. The focus is on using practical Excel features and better workbook structure to reduce unnecessary work.

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 scenario. You'll see how an Excel workbook can be restructured to reduce duplicate data entry and make information easier to maintain and reuse.

Live online
Join from wherever you're based.

Practical demonstrations
See Excel features being used to solve a common workplace problem.