Cleaning Excel Data With Power Query Straight to the Point
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…
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?
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.
Our community of 9,000+ authors has personally recommended 8 books like Cleaning Excel Data With Power Query Straight to the Point.