Excel

Click play (above) to watch “Microsoft 365 Copilot in Excel” (Press “F” to toggle full screen mode.)

What is Microsoft Excel?

Microsoft Excel is the industry leading spreadsheet program, a powerful data visualization and analysis tool.

Source: https://www.microsoft.com/en-us/microsoft-365/excel

Excel training & resources

PivotTables

You can use a PivotTable to summarize, analyze, explore, and present summary data. PivotCharts complement PivotTables by adding visualizations to the summary data in a PivotTable, and allow you to easily see comparisons, patterns, and trends. Both PivotTables and PivotCharts enable you to make informed decisions about critical data in your enterprise. You can also connect to external data sources such as SQL Server tables, SQL Server Analysis Services cubes, Azure Marketplace, Office Data Connection (.odc) files, XML files, Access databases, and text files to create PivotTables, or use existing PivotTables to create new tables.

Source: https://support.microsoft.com/en-us/office/overview-of-pivottables-and-pivotcharts-527c8fa3-02c0-445a-a2db-7794676bce96

Power Query and Power Pivot

Power Query (Get & Transform) and Power Pivot complement each other. Power Query is the recommended experience for importing data. Power Pivot is great for modeling the data you’ve imported. Use both to shape your data in Excel so you can explore and visualize it in PivotTables, PivotCharts, and Power BI.

In short, with Power Query you get your data into Excel, either in worksheets or the Excel Data Model. With Power Pivot, you add richness to that Data Model.

Source: How Power Query and Power Pivot work together

Suggested reading on Amazon

The 365 Training Portal provides quick access to Microsoft’s top online resources. However, if you prefer to have a good book on hand, we have also selected three highly rated Excel books on Amazon for you to consider.

Our top picks for Excel books on Amazon:

As an Amazon Associate, the 365 Training Portal earns a commission on qualifying purchases.


Latest news from the Excel blog

Noteworthy in Excel

Feedback

Our goal is to keep the 365 Training Portal as up-to-date and useful as possible. Please use the feedback form to let us know about any broken links or updated resources, to suggest additional resources or content, or to provide general feedback about this site.