Microsoft Power Query para Excel

Microsoft Power Query for Excel is a powerful data transformation tool developed by Microsoft Corporation. With this add-in for Microsoft Excel, users can easily transform and reshape data from a variety of sources.

Users can connect and import data from a multitude of sources, including Excel workbooks, text files, databases, and online services such as Microsoft Dynamics CRM, Salesforce, and Facebook. The tool provides an intuitive user interface that allows users to perform various transformations on their data, such as filtering, merging, splitting, and pivoting. Additionally, users can use the tool to create custom functions to further manipulate their data.

Microsoft Power Query for Excel also includes a wide range of built-in data connectors and transformation options. The tool provides an easy-to-use query editor that allows users to preview data at each stage of the transformation process. Users can also customize their queries by adding new steps and removing unnecessary ones.

Microsoft Power Query for Excel is an essential tool for anyone who needs to analyze and transform large sets of data in Microsoft Excel. Its intuitive interface and powerful set of features make it a must-have for anyone who wants to efficiently work with data.