Excel Hacks for Easy Data Cleaning
January 5, 2025
Thursday, 23rd January @ 12 pm EST | 9 am PST | 5 pm GMT
Webinar
Do you frequently deal with messy data that needs cleaning before it fits into your workflow? Excel now offers powerful tools to clean data once and apply those same steps to future files effortlessly!
Join Bill Jelen, aka MrExcel, for a free, hour-long session where he’ll showcase incredible, time-saving techniques to help you clean and organize your Excel spreadsheet data like a pro.
In this webinar, we’ll cover:
- Leveraging Excel’s Get & Transform tools for efficient data cleaning
- Exploring Power Query’s unique transformations, such as Unpivot and Split by Delimiter to Rows
- Automating data cleaning tasks across multiple files in a folder
- Extending Excel’s capabilities with the “M” macro language for advanced transformations
- Investigating how Python in Excel can unlock new data cleaning possibilities
Note: All those who attend the live webinar and participate in 3 out of the 4 poll questions will receive 1 CPE credit. Attendees will also receive the recording and related materials after the broadcast. If you’re not able to attend, register anyway to receive the recording and related resources for free!
Register Here:
About the Speaker: Bill Jelen
Bill Jelen is the host of MrExcel.com and the author of 68 books about Microsoft Excel including Excel Gurus Gone Wild, Pivot Table Data Crunching, and Excel Inside Out. He has made over 80 guest appearances on TV’s Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show. He has produced over 2500 episodes of his Excel video podcast “Learn Excel from MrExcel.” He was a three-time commentator for the Excel World Championships broadcast on ESPN.
He worries a lot about the Excel advice that is given by the new artificial intelligence tools and wonders how his former Accounting 101 professor would react to the concept of a bot hallucinating accounting results that change from day to day.
However, he is cautiously honing a MrExcel-GPT bot with all of the knowledge from hundreds of hours of his YouTube videos and books. Before founding MrExcel.com in 1998, Jelen spent twelve years as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company.
Additional MrExcel Resources
Follow us on our social networks:
