Independent Publishers Group Logo

Sign up today...
for featured pop culture and science reads, books for kids and teens,special offers, bestsellers, and more, in your inbox!

Select topics of interest:
Cleaning Excel Data With Power Query Straight to the Point
Cleaning Excel Data With Power Query Straight to the Point

Cleaning Excel Data With Power Query Straight to the Point

Straight to the Point


52 Pages, 8 x 10

Formats: PDF

PDF, $4.95 (US $4.95) (CA $6.95)

Publication Date: March 2019

ISBN 9781615471492

Rights: WOR

Holy Macro! Books (Mar 2019)

Price: $4.95
NOTE: You are attempting to order an e-book. Please see will it work on my eReader? for directions on how to enjoy this book on your eReader device.
add ebook to cart


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.