How to find Analyze Data in Excel

Hi iamyllej,

To find Analyze Data in Excel, follow these steps:

1. Click the File tab.
2. Click Options.
3. Click Add-Ins.
4. In the Manage list, select Excel Add-ins.
5. Click Go.
6. In the Add-Ins dialog box, check the Analysis ToolPak check box.
7. Click OK.
   
   

   
   Once you have enabled the Analysis ToolPak, you should see the Analyze Data button on the Data tab. If you don't see the Analyze Data button, it may be because the Data tab is not visible. To make the Data tab visible, follow these steps:

1. Click the File tab.
2. Click Options.
3. Click Customize Ribbon.
4. In the Customize the Ribbon dialog box, select Main Tabs from the Choose commands from drop-down list.
5. Make sure the Data check box is selected.
6. Click OK.