Wednesday, 31 October 2012

Add/Install Data Analysis Add-in

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.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)