Learn how to use the Analysis ToolPak to perform complex Excel data analysis. Explore the various data analysis functions available in Excel.

In the Manage box, select Excel Add-ins and then click Go. If you're using Excel for Mac, in the file menu go to Tools > Excel Add-ins. In the Add-Ins box, check the Analysis ToolPak check …

Analyze Data in Excel empowers you to understand your data through natural language queries that allow you to ask questions about your data without having to write complicated formulas.

Excel 2021 for Mac allows you to collaboratively work with others and analyze data easily with new Excel capabilities including co-authoring, Dynamic Arrays, XLOOKUP, and LET functions.

Learn how to use sheets, functions, formulas, charts, and other useful resources for Excel for Mac 2011.

What-if analysis changes the values in cells to see how those changes will affect the outcome of formulas on the sheet. For example, you can use a data table to vary the interest rate and …

What-If Analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet. Three kinds of What-If Analysis tools come …

You can now get Office Add-ins from the Store or use add-ins you already have from right within recent versions of Word for Mac and Excel for Mac. There are two kinds of add-ins: Office Add …

Exploring charts in Excel and finding that the one you pick isn’t working well for your data is a thing of the past! Try the Recommended Charts command on the Insert tab to quickly create a …

You can import data into Excel using Power Query from a wide variety of data sources: Excel Workbook, Text/CSV, XML, JSON, SQL Server Database, SharePoint Online List, OData, …