Smart Reconciliation in Power Query: From UI to Custom M | Mahmood Bani Asadi

Speakers: Mahmood Bani Asadi
Start Date: Thu, Dec 18th 2025 · 7:00 PM EEST (5:00 PM GMT)
Language: ENGLISH
Location: Online (link visible for attendees)
Description:

In this session, we will explore practical reconciliation methods in Power Query that also handle duplicate records.
We start with simple UI steps to clean, compare, and match data between tables.
Then, we will use custom M function to automate the process, including detecting and managing duplicates.

This session is ideal for anyone who wants accurate, repeatable, and reliable reconciliation workflows.

At the end of the Meetup we'll have a Raffle with prizes offered by EDNA: 2 FREE one-year access Licenses on EDNA Platform for two lucky winners from the Live attendees !

Speaker: Mahmood Bani Asadi
Microsoft MVP Alumni, Data Analyst, Excel Trainer

With over a decade of Excel expertise, I’ve been providing professional training on YouTube and Instagram (@SoftwareTrain) for more than 10 years.
I was honored to become a Microsoft MVP in 2023, and I remain committed to continuous learning and staying ahead in the industry.