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.
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 the tool uses the appropriate statistical or engineering macro functions to calculate and display the results in an output table.
Help for Excel for Windows add-ins - Microsoft Support
Use the Analysis ToolPak for complex, statistical analyses, such as regression, histograms, sampling, and z-Tests. There are also special VBA functions available to use with the Analysis ToolPak. Help for Analysis ToolPak / Analysis ToolPak VBA.
Add or remove add-ins in Excel - Microsoft Support
Add-ins provide optional commands and features for Microsoft Excel. By default, add-ins are not immediately available in Excel, so you must first install and (in some cases) activate these add-ins so that you can use them. Some add-ins are built in …
Load the Solver Add-in in Excel - Microsoft Support
After you load the Solver Add-in, the Solver command is available in the Analysis group on the Data tab. On the Tools menu, select Excel Add-Ins . In the Add-Ins available box, select the Solver Add-In check box, and then click OK .
Analyze Data in Excel - Microsoft Support
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. In addition, Analyze Data provides high-level visual summaries, trends, and patterns.
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 with Excel: Scenarios , Goal Seek , and Data Tables .
Analyze and format in Excel - Microsoft Support
Use the Quick Analysis tool to pick the right chart for your data. Select the data you want to show in a chart. Select the Quick Analysis button to the bottom-right of the selected cells.
Use PivotTables and other business intelligence tools to analyze …
Analyze your data in a PivotTable or PivotChart, build a Data Model, or use other business intelligence tools like Power Pivot and Power View.
Analyze data with Excel for Windows - Microsoft Support
Use the Quick Analysis tool to pick the right chart for your data. Select the data you want to show in a chart. Select the Quick Analysis button to the bottom-right of the selected cells. Select Charts, hover over the options, and pick the chart you want. Try it!
Power Pivot: Powerful data analysis and data modeling in Excel
Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.