microsoft office 2013 pro powerpivot power query

Substitute data from one table to another by the coincidence of one or several parameters, i.e., perfectly replaces the VPR function (VLOOKUP) and its analogs.Transform tables in every way by bringing them into the desired view (filter, sort, change the order of columns, transpose, add totals, expand cross-tables into flat ones, and rollback).Putting data in order: correct case, number-as-text, fill in the blanks, add the correct table header, disassemble the text sticking to the columns and merge back, divide the data into components, etc.Clear the data from the “garbage”: extra columns or rows, repetitions, service information in the “header,” extra spaces or unprintable characters, etc.From Excel workbooks, you can automatically download data from all sheets at once. Collect data from files of all basic data types like XLSX, TXT, CSV, JSON, HTML, both singly and in bulk, from all the files in the specified folder.Download data to Excel from almost 40 different sources, including databases like SQL, Oracle, Access, Teradata, corporate ERP-systems like SAP, Microsoft Dynamics, Internet services like Facebook, Google Analytics, almost any sites.Back in 2013, a specially created group of developers inside Microsoft released for Excel a free Power Query add-on (other names are Data Explorer, Get and Transform), which can do a lot of useful things for everyday work: It allows users to extract data from different sources, manipulate the specified data into a form that matches their needs, and load it into Excel. Power Query is an ETL (Extract, Transform, Load) self-service tool that works like an Excel add-in. What is Power Query, Power Pivot, Power BI, and Why do you Need Them? Not everyone clearly understands what is behind these concepts, how they are interrelated, and how they can help an ordinary Excel user. The terms “Power Query,” “Power Pivot,” “Power BI,” and other “Power” more often appear in articles and materials about Microsoft Excel. Difference Between Power Pivot, Power Query and Power BI

Microsoft office 2013 pro powerpivot power query