Import and analyze data

You can use Power Query (formerly called Get & Transform) experience to connect to multiple data sources, then use the Query Editor to shape and transform data.

Power Query for Excel Help

About Power Query in Excel

Import data from external data sources

Refresh an external data connection in Excel

How data journeys through Excel

Handling data source errors

Create Power Query formulas in Excel

Power Query data sources in Excel versions

Overview of Excel tables

Create and format tables

Copy a Word table into Excel

Format an Excel table

Resize a table by adding or removing rows and columns

Use calculated columns in an Excel table

Total the data in an Excel table

Sort data in a range or table

Filter data in a range or table

Filter for unique values or remove duplicate values

Available chart types in Office

Create a chart

Add a pie chart

Present your data in a Gantt chart

Create a waterfall chart in Office 2016

Create a histogram

Change axis labels in a chart

Select data for a chart

Add axis titles to a chart

Add a trend or moving average line to a chart 

Create a PivotTable to analyze worksheet data

Use multiple tables to create a PivotTable

Calculate values in a PivotTable

Format PivotTables by using the Field List to arrange fields

Change the source data for a PivotTable

Delete a PivotTable

Create dynamic charts by using PivotCharts

Filter data in a PivotTable

Create a PivotTable timeline to filter dates

Create a data model in Excel

Import Data into Excel and Create a Data Model

Power Pivot Overview and Learning

Delete relationships between tables in a Data Model

Measures in Power Pivot

Data Model specification and limits

Add worksheet data to a Data Model using a linked table 

Data Analysis Expressions DAX in Power Pivot​​​​​​​