Use the Analysis ToolPak to perform complex data analysis
If you need to develop complex statistical or engineering analyses, you can save steps and time by using the Analysis ToolPak. You provide the data and parameters for each analysis, and …
Load the Analysis ToolPak in Excel - Microsoft Support
Perform statistical and engineering analysis with the Analysis ToolPak. The Analysis ToolPak is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel.
Create a PivotTable to analyze worksheet data - Microsoft Support
A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. PivotTables work a little bit differently …
Handling data source errors (Power Query) - Microsoft Support
What follows are a few suggestions to help you deal with errors you may encounter. Find and save the specific error First examine the Queries & Connections pane (Select Data > , select …
Group or ungroup data in a PivotTable - Microsoft Support
Create a PivotTable to analyze worksheet data. In Excel, show items or values in logical groups like months or quarters for ease of summarizing and performing data analysis.
Outline (group) data in a worksheet - Microsoft Support
Use an outline to quickly display summary rows or columns, or to reveal the detail data for each group. You can create an outline of rows (as shown in the example below), an outline of …
Add or remove a secondary axis in a chart in Excel - Microsoft …
Select Combo > Cluster Column - Line on Secondary Axis. Select Secondary Axis for the data series you want to show. Select the drop-down arrow and choose Line .
Define and solve a problem by using Solver - Microsoft Support
Solver is a Microsoft Excel add-in program you can use for what-if analysis. Use Solver to find an optimal (maximum or minimum) value for a formula in one cell — called the objective cell — …
Analyze Data in Excel - Microsoft Support
Simply select a cell in a data range > select the Analyze Data button on the Home tab. Analyze Data in Excel will analyze your data, and return interesting visuals about it in a task pane. If …
Power Pivot: Powerful data analysis and data modeling in Excel
How to use Power Pivot in Excel to perform data analysis and create sophisticated data models using data from various sources to see hidden patterns and trends.
Introduction to What-If Analysis - Microsoft Support
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 …