Cleaning Excel Data With Power Query Straight to the Point

Book cover of Cleaning Excel Data With Power Query Straight to the Point

Book description

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…

Explore

Topics

Genres

Coming soon!

When you buy books, we may earn a commission that helps keep our lights on (or join the rebellion as a member).

Why read it?

1 author picked Cleaning Excel Data With Power Query Straight to the Point as one of their favorite books. Why do they recommend it?

Bill Jelen

Author

If you just want to find out if Power Query is for you, this short book, written by the entertaining host of the Excel On Fire YouTube channel will show you what is possible using Power Query. Oz will show you the types of everyday problems that can be solved using the Get & Transform section of the Data tab in Excel. Once you get a taste of what is possible, you will be ready to dive in with Ken Puls’ book.

From Bill's list on to go from Excel to Power Query and Power BI.