Purchase any WEBINAR and get
10% Off
CODE: SAVE10
T&C applicable, please referFAQ
Validity : 26th Mar'25 to 05th Apr'25
Using Excel's Power Query tools to automate data cleansing tasks
- Unpivoting data to make it easier to analyze
- Automating redundant data cleansing tasks
- Audit trail of changes made to data.
- Fuzzy matching of data
Overview of the webinar
Data cleansing is one of the most time-consuming and error-prone tasks in Excel—especially for professionals dealing with compliance, governance, and risk management. Power Query offers a game-changing solution by automating repetitive data-cleaning processes, reducing manual effort, and ensuring data accuracy.
In this one-hour webinar, we’ll explore how Power Query can transform messy data into structured, usable information. Learn how to quickly unpivot data, convert complex delimited values into new rows, and even handle extreme cases like splitting data into 205 individual columns. Discover how Power Query can perform a VLOOKUP during data import, saving time and improving accuracy. We’ll also cover fuzzy matching, a powerful feature for reconciling inconsistencies in names, addresses, and other text-based data—critical for compliance and risk management.
By the end of this session, you’ll have a clear understanding of how to automate tedious data-cleaning tasks, improve efficiency, and ensure consistency in your reports. Whether you’re working with financial records, regulatory data, or internal reports, these Power Query techniques will help you streamline processes and reduce the risk of human error.
Take control of your data—register today and discover the power of automation in Excel!
Who should attend?
- Anyone that is tasked with cleaning and/or prepping data sets for further work in Excel
- All Excel Users
- Accountants
- CFOs
- Controllers
- CPA's
- Financial Consultants
- Human Resources Professionals
- Marketing Professionals
- Sales Professionals
- Supervisors
- Business Owners
- Database Administrators (DBA)
- Trainers
- Managers
Why should you attend?
If your role involves managing, analyzing, or ensuring the accuracy of data, Power Query is an essential tool that can automate repetitive tasks, reduce errors, and improve efficiency. Instead of spending hours manually cleaning and restructuring data, learn how to unpivot, split, and transform messy datasets in just a few clicks.
In this webinar, you’ll see how Power Query can perform lookups during import, handle fuzzy matching for inconsistencies, and even split complex data structures automatically—all crucial for compliance, governance, and risk management.
Stop wasting time on manual data cleanup—attend this webinar and let Excel do the work for you!
Faculty - Mr.Bill Jelen
Bill Jelen is the host of MrExcel.com and the author of 69 books about Microsoft Excel including Excel Gurus Gone Wild, Pivot Table Data Crunching, and Microsoft Excel Inside Out. He was an ESPN commentator for the World Excel Championships, 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 writes the Excel column for Strategic Finance magazine. He has produced over 2500 episodes of his video podcast Learn Excel from MrExcel. Bill will entertain you while showing you the powerful tricks in Excel. Before founding MrExcel.com in 1998, Jelen spent twelve years “in the trenches”, as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company. Since then, his company automates Excel reports for hundreds of clients around the world. The website answers over 30,000 questions a year – for free – for readers all over the world. Jelen joins us from Merritt Island, Florida.