Cleaning Excel Data With Power Query Straight to the Point

Overview

Author Oz Du Soleil’s area of frustration with Excel is cleaning data. From his earliest days with Excel, he has found himself constantly needing to fix names that are ALLCAPS, peel addresses away from phone numbers, and fixing all the many other things that prevent data from being useful. In this intro to Power Query, Oz shows you five core techniques in Excel Power Query: Splitting data, Filling blanks, Joining data sets, grouping and summarizing, and adding columns using Column From Examples.

Author Biography

Oz du Soleil is an Excel MVP who’s been working with Excel since 2001. Oz has several Excel courses on the LinkedIn Learning platform. He’s possibly best known for the dramatic and colorful Excel tutorials he posts on his YouTube channel Excel on Fire.Most recently, Oz has presented Excel topics and master classes at conferences in Amsterdam; Sofia, Bulgaria; São Paulo, Brazil; Toronto, Canada; and cities around the United States.When Oz isn’t elbows-deep in the guts of a spreadsheet, he does storytelling around Portland, Oregon. He has told stories onstage for Risk!, Pants on Fire, Seven Deadly Sins, Pickathon, The Moth, and other storytelling shows.