preview

Pt1420 Unit 15 Analysis

Satisfactory Essays

30. 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.

Get Access