how to get data analysis on excel on mac

This provides a drop-down list of recommended questions. Select Cells Notice the Quick Analysis Tool icon that is displayed at the bottom of the data. 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. From Excel 2013 or Excel 2016, click the File tab, and then click Options. You’ll then see the fields for your data and their summarized values. Click Add-Ins and in the Manage box, select Excel Add-ins. In the Add-Ins available: box, select the Analysis ToolPak check box, and then click OK.

After you load the Analysis ToolPak, the Data Analysis command is available in the Analysis group on.

Use the check boxes on the left side to select the fields that you want to analyze.

How to get data analysis on excel on mac