Tuesday, November 20, 2012

How to Display Statistical Worksheet Functions in Excel


1. Click the Microsoft 'Office' button in the top left corner of Excel.
2. Click the 'Excel Options' button.
3. Click 'Add-Ins' in the list. The window to the right will display all the inactive add-ins that you can add. You do not need to click any of these at this point.
4. Click 'Excel Add-Ins' under the Manage section at the bottom and click 'Go.' You will get a pop-up window with available add-ins.
5. Check the 'Analysis ToolPak' box and click 'OK.' If you get a message that it is not installed and are asked if you want to install it, click 'Yes' to install it.
6. Click the 'Data' tab on the ribbon to check whether you have the statistical add-in. You should now have an 'Analysis' group under the 'Data' tab.

Blogger news