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.