Add/Install Data Analysis Add-in : Data Analysis « Data Analysis « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Data Analysis
  3. Data Analysis
Click office button. Then click the Excel Option.
Click the Data tab. Then click the Solver button.
Click the Add-in and click the Data Analysis in the list.
Select the target cell.
Click GO
Click an Equal To option, and then, if necessary, enter a value.
Select Data Analysis add-in in the list. Click OK.
Select the cell range the solver uses to compare against the target cell.
Click OK to install Data Analysis. 
           And Data Analysis button is added to Data tab.
Then click OK.








10.1.Data Analysis
10.1.1.Add/Install Data Analysis Add-inAdd/Install Data Analysis Add-in
10.1.2.Use Data Analysis ToolsUse Data Analysis Tools