Page 488 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

EXERCISE 76 : Demonstrate a power query, power query

function. Invoking the power query function

and combining queries. Organize the

workbook queries

Objectives

At the end of this exercise you shall be able to
• install power query
• demonstrate a power query, power query function
• invoking the power query function and combining queries.

Procedure

How to Install Power Query
Excel 2016
Power Query is included with Excel 2016 (Office 365). It has been renamed and is now on the Data tab of the
Ribbon in the Get & Transform section.

This means there is nothing to install. If you are using Excel 2016, go to the Data tab on the ribbon and press the
New Query button to create a query and open the Power Query editor.
Power Query is available with all levels of Office 365 subscriptions.
Excel 2010 & 2013
For Excel 2010 and 2013 you will need to download the Power Query add-in and install it.
The installation steps are about the same in Excel 2010 and 2013.

1 Close (exit) Excel completely.
2 Click the following link to go to the download page.
https://www.microsoft.com/en-us/download/details.aspx?id=39379
3 Click the Download button.

473