O'Reilly logo

Excel 2016 In Depth by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

13. Transforming Data

Excel 2016 adds amazing tools to Edit, Transform & Load data into Excel. The tools available in the Power Query add-in are now part of Excel 2016, rebranded as the Get & Transform group on the Data tab. This chapter introduces some of the tools available in Power Query as well as traditional tools such as Sort, Filter, Remove Duplicates, and Flash Fill.

Using Power Query

The Power Query add-in was created to make it easier to clean ugly data. Suppose that your IT department provides a data set every day that has a number of problems. Rather than wait for the IT department to rewrite the query, you can use Power Query to memorize the steps needed to clean the data. When the IT department provides a new file, you simply refresh ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required