Chapter 13Transforming Data

What if there was a tool that let you clean data 20 percent faster on day one? What if that tool accurately remembered all your steps so you could clean the data 99 percent faster on days two through two hundred? That tool has been hiding on the Data tab since Excel 2016.

Power Query is the best feature to arrive in Excel about which most people have never heard. After Excel 2013 was released, the Power Query add-in was released for Excel 2010 and Excel 2013. The Add-in was great, but many people in corporate environments ...

Get Microsoft Excel 2019 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.