Microsoft Office 2016: The Complete Guide (2015)

THE GET & TRANSFORM QUERY

You cannot analyze data until you have brought the relevant data that will answer the question you are asking. A new feature of Excel 2016 is the built-in function which makes getting and transforming your data much faster and easier and allows you to find and gather all your data into one place. These new capabilities were only available previously as a separate add-in called Power Query. Now they can be found built into Excel 2016. They can be accessed from the Get & Transform group located on the Data tab.