Course Details

This session explores how ChatGPT can dramatically speed up one of the most time-consuming parts of working in Excel: getting, preparing, and cleaning data. You’ll see how ChatGPT can assist us in cleaning messy inconsistent datasets to create analysis-ready spreadsheets.

 

In this session Alan Murray will cover the following topics:

 

  • How ChatGPT can be used to identify data issues in a spreadsheet.
  • Extract data from PDF and other Excel files.
  • Using ChatGPT can prepare, reformat, or structure data before it reaches Excel.
  • Cleaning and standardising messy Excel datasets using ChatGPT prompts.
  • Generating Power Query steps or M code with ChatGPT.

 

By attending this session, you will: -

 

  • Understand how ChatGPT can help clean and organise data before and within Excel.
  • Learn prompt techniques to restructure messy information quickly.
  • Gain confidence combining ChatGPT with Excel tools for accurate results.
  • Discover practical techniques to eliminate repetitive manual cleaning.
  • Be equipped to streamline the first stage of your reporting and analysis workflow.

 

This session will be of most interest to, Accountants, finance professionals, and analysts who regularly import, prepare, or clean data — and want to learn how ChatGPT can assist with these processes.

 

Course Level: Intermediate

CPD Course Speaker

Computergaga

Alan Murray

Alan Murray is an experienced Excel trainer and Microsoft MVP. With over 23 years of experience as an Excel trainer, he helps users build confidence and expertise in Excel and Power BI - empowering them to solve problems, automate tasks, and work more efficiently.

Alan is the author of the ‘Advanced Excel Formulas’ and ‘Advanced Excel Success’ books and has a YouTube channel – named Computergaga – with 118,000+ subscribers and over 50 million views.

He organises the London Excel Meetup group to provide a community event for professionals to network, share, and develop their Excel skills.

Alan loves showing people what’s possible with the tools they already have. His training approach is relaxed, practical, and always focused on the needs of the people in the room. Everyone should feel confident using Excel and empowered to ask any question - no matter how simple or advanced.