Excel
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
LinkedIn Learning – 1-month free trial
If you enjoy learning at your own pace from videos, we highly recommend LinkedIn Learning’s 1-month free trial, which will give you full access to their Excel courses.
LinkedIn Learning offers thousands of on-demand courses created by industry experts. Receive personalized course recommendations tailored to your unique needs, backed by data-driven insights from millions of professionals on the worldwide LinkedIn network.
Master Excel on LinkedIn Learning:
- Click here to view Excel courses on LinkedIn Learning
- Click here to sign up for a 1-month free trial of the entire LinkedIn Learning catalog
As a LinkedIn Learning affiliate, the 365 Training Portal earns a commission on purchases made through this site.
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
- Overview of PivotTables and PivotCharts
- Create a PivotTable to analyze worksheet data
- Create a PivotChart
- Use PivotTables and other business intelligence tools to analyze your data
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.
Source: How Power Query and Power Pivot work together
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.
- What is Power Query?
- Power Query documentation
- About Power Query in Excel
- Create a Data Model in Excel
- How Power Query and Power Pivot work together
- Power Pivot: Powerful data analysis and data modeling in Excel
- Power Pivot – Overview and Learning
- Get started with Power Pivot in Microsoft Excel
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:
- Excel: The Complete Illustrative Guide for Beginners to Learning any Fundamental, Formula, Function and Chart in Less than 5 Minutes with Simple and Real-Life Examples
- Exploring Microsoft Excel’s Hidden Treasures: Turbocharge your Excel proficiency with expert tips, automation techniques, and overlooked features
- Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365) (Business Skills)
As an Amazon affiliate, the 365 Training Portal earns a commission on purchases made through this site.
Latest news from the Excel blog
Recommended YouTube channels
Ads
Related apps
See also
- Available chart types in Office
- Data Visualization with Excel and Power BI
- Excel certifications
- Excel Community Feedback (preview)
- Excel courses on LinkedIn Learning (1-month free trial)
- Excel functions (alphabetical)
- Excel Glossary
- Excel roadmap
- Excel specifications and limits
- Get Office mobile for your phone
- Microsoft Community
- Microsoft templates
- Number format codes
- Replay your ink strokes in Office
- What is data modeling?
- What’s New: Changes made to Excel functions
- What’s new in Excel 2021 for Windows
- What’s new in Excel for Microsoft 365
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.