Scribd
Upload
76 views10 pages

5.0 Introduction To Power Query

Power Query, also known as Get & Transform, is integrated into Excel 2016 and Microsoft 365, while it requires activation as an add-in in Excel 2013 and installation in Excel 2010. This tool automates repetitive tasks, allows data extraction from various sources, and provides powerful data transformation capabilities. It facilitates loading data into different formats and creating relationships for effective data analysis.

Uploaded by

iswadi1505
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
76 views10 pages

5.0 Introduction To Power Query

Power Query, also known as Get & Transform, is integrated into Excel 2016 and Microsoft 365, while it requires activation as an add-in in Excel 2013 and installation in Excel 2010. This tool automates repetitive tasks, allows data extraction from various sources, and provides powerful data transformation capabilities. It facilitates loading data into different formats and creating relationships for effective data analysis.

Uploaded by

iswadi1505
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 10

Installation of Power Query

1) Excel 2016 & Excel for Microsoft 365


Get & Transform (Power Query) has been integrated with Excel on the Data tab.
2) Excel 2013
Power Query is an add-in that's included with Excel, but needs to be activated. G
File > Options > Add-Ins, then in the Manage drop-down at the bottom of the p
select COM Add-Ins > Go. Check Microsoft Power Query for Excel, then OK to a
A Power Query tab will be added to the ribbon.
3) Excel 2010
Download and install the Power Query.. Once activated, a Power Query tab will
to the ribbon.
a) To check the Microsoft Excel is 32-bit or 64-bit, go to File > Help > About Microso
(left side center)
b) Go to Microsoft Office website add-in (http://www.microsoft.com/en-us/downlo
id=39379&CorrelationId=43c120db-d3f4-4382-), click Download
and choose the add-in accordingly, then click Next to initiate the download.
c) Close the Excel and then open and run the MSI installer.
d) Open Excel, and you may view Power Query tab is at your menu bar.

Different Data ribbon tab in Excel 2016


on the Data tab.

to be activated. Go
bottom of the pane,
cel, then OK to activate it.

er Query tab will be added

p > About Microsoft Excel

om/en-us/download/details.aspx?

he download.

u bar.
What is Power Query?

Power Query is a powerful free tool embedded to Microsoft


Power Query is also know as Get & Transform.
Power Query's commands are simple.

Power Query is useful to


1) automate boring and repetitive tasks
2) to import/get/extract data from different sources such as
a) from another workbook
b) text file (csv, txt)
c) folder
d) sharepoint
e) different database (Access)
f) web
g) email (Outlook) etc
3) transform and clean data such as
a) remove columns
b) remove rows
c) sort
d) split column
e) change case
f) append data
g) merge data
h) change data types
i) group and aggregate
4) load a data to
a) Table
f) append data
g) merge data
h) change data types
i) group and aggregate
4) load a data to
a) Table
b) PivotTable Report
c) Connection only
d) Data Model
5) create relationship that allow PivotTable to work with mu

Why use Power Query?


1) Storing up to millions rows of data
2) Powerful transformation tools
3) Update with just a click of button
ery?

to Microsoft Excel.

rces such as
work with multiple tables.

You might also like