Use the check boxes on the left side to select the fields that you want to analyze. After you load the Analysis ToolPak, the Data Analysis command is available in the Analysis group on. In the Add-Ins available: box, select the Analysis ToolPak check box, and then click OK. Click Add-Ins and in the Manage box, select Excel Add-ins. You’ll then see the fields for your data and their summarized values. From Excel 2013 or Excel 2016, click the File tab, and then click Options. You’ll also see any recent questions that you’ve asked to quickly revisit them if you’d like.Īnswers to your questions or results from suggestions you pick display directly beneath.īelow the question area of the task pane is a link for Which Fields Interest You the Most? If you want to narrow down the data that you’re analyzing, you can do so by clicking this. Select Cells Notice the Quick Analysis Tool icon that is displayed at the bottom of the data. This provides a drop-down list of recommended questions. Have you ever wanted to calculate a simple statistic in Excel, but couldnt find the correct tab to do so If so, it is possible that you did not have the. Select the cells of data that you want to analyze. Step 4: Once you click on Add-Ins, at the bottom, you will see Manage drop-down list. If Analysis ToolPak is not listed in the Add-Ins. In the Add-Ins box, check the Analysis ToolPak check box, and then click OK. In the Manage box, select Excel Add-ins and then click Go. Step 3: After selecting Options, select Add-Ins. Click the File tab, click Options, and then click the Add-Ins category. Depending on the type of data that you’re using, you can type in things like, “How many shirts sales in January,” “What are shoes and pants total sales,” or “Total jackets excluding December.”Īlong with the ideas at the top, you can also see suggestions by clicking in the question box. Unleash Data Analysis Tool Pack in Excel.