1, avenue to Jane Data processing tools-(Getting Started with Microsoft power query) _power

Source: Internet
Author: User

Avenue to Jane data processing tools-microsoft Power Query

Farewell to complex Excel functions, Excel VBA programming, let everything return to simplicity and function.

What kind of crowd fits such a tool:

1, cashier, accounting, statistics, warehouse management, data analysis and other data dealing with the post.

2, do not want to learn the functions of data processing, VBA programming and other complex functions, but the work of people who need.

What exactly is Microsoft Power Query

A, access to data:

B, cleaning data:

C, Fusion Data:

D, summary data:

Version requirements:

Operating system version: At least Window7 and above.

Office version: office2010 version and above. Need to download the installation, version 2016 built in.

Location: Data--getting and converting

Download Address: http://www.microsoft.com/zh-CN/download/details.aspx?id=39379


Supported Operating systems

Windows 7, Windows 8, Windows Server 2008 R2, Windows Server 2008 Windows Server R2 Windows Server Windows 7 Win Dows 8 Windows 8.1
Supports the following Office versions: Microsoft Office Professional Plus and Software protection Microsoft Office 2013
Microsoft Power Query for Excel requires Internet Explorer version 9 or later.

Microsoft Power Query for Excel is available for 32-bit (x86) and 64-bit (x64) platforms, and your selections must match the architecture of the installed Office version. Download the version of the Power Query add-in that matches the architecture of Office you have installed (x86 or x64). Run the MSI installer and follow the installer steps.
How do you know what version of your Excel is?


Next install: powerquery_2.39.4526.123 (32-bit) [Zh-cn].msi

First close the office-related product, and then proceed directly to the next installation success.


We opened the excel2013 and found that we already have a tab tab (Power Query).


No, in the development tool, the add-in is checked.


Conditions allow, the direct use of 2016, more complete functions.



Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.