Transforming text data in Excel

Recording & downloads

• A recording will be made available after the event.
• All files used in the session will be shared at the time of the event.

This webinar explores a variety of techniques for transforming and analyzing text data in ways previously difficult or impossible to do in Excel:

• Master text cleaning techniques in Excel using Power Query for efficient data preparation.
• Utilize dynamic array functions like TEXTSPLIT() and TEXTJOIN() to streamline text manipulation.
• Apply regular expression functions in Excel to extract and organize complex text patterns.
• Analyze text data effectively using Excel's new Copilot features and Python integration.
• Develop workflows to automate text transformation tasks for repeated use across projects.

Prerequisites

• To make the most of this workshop you should be familiar with Excel concepts such as IF() statements and conditonal aggregation, lookup functions like VLOOKUP() and XLOOKUP(), and creating data summaries and reports with PivotTables.
• It is recommended to attend this session on a Windows machine with Microsoft 365 for desktop.
• No other preparation is needed. The workshop materials will be shared with you at the time of the event.

About your instructor

George Mount is the founder of Stringfest Analytics. He has over 10 years of experience in data analytics and holds master’s degrees in both finance and information systems from Case Western Reserve University. George is the author of Advancing into Analytics: From Excel to Python and R (O’Reilly, 2021) and Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics (O'Reilly, 2024). He is a recipient of the Most Valuable Professional (MVP) award from Microsoft for technical excellence & community advocacy.

I look forward to seeing you at the event!

If your team is looking for custom training in Modern Excel, check out my corporate workshops.