With Power Query (known as Get & Transform in Excel) and Power Pivot in Excel, you'll spend less time manipulating data, and more time driving impact. Watch this 2-minute video to learn how.

This QuickStart is for users new to Power Pivot in Excel or tabular model projects authored in SQL Server Data Tools. It is meant to give you a quick and easy introduction on how you can use Data …

Get started using Power Pivot in Excel to perform powerful data analysis, create sophisticated data models, mash up large volumes of data from various sources, and perform information analysis rapidly.

Excel incorporates Power Query (also called Get & Transform) technology to provide greater capability when importing, refreshing, and authenticating data sources, managing Power Query data sources, …

Power Query is a technology embedded in Excel and other Microsoft products designed to help you shape your data. In Excel, select the Data tab on the ribbon to see the Get & Transform Data and …

The following links and information can get you going with Power Pivot, including how to enable Power Query in Excel, how to get started using Power Pivot, then tutorials, and community connections.

Know which environment you're in Power Query is well-integrated into the Excel user interface, especially when you import data, work with connections, and edit Pivot Tables, Excel tables, and …

Before you can start working with the Data Model, you need to get some data. For that we'll use the Get & Transform (Power Query) experience, so you might want to take a step back and watch a video, or …

Microsoft Support is here to help you with Microsoft products. Find how-to articles, videos, and training for Microsoft Copilot, Microsoft 365, Windows 11, Surface, and more.

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.