Method 2Method 2 of 2:Using Mac Download Article. Open the Excel file you want to analyze. Find the Excel file you want to edit on your computer, and open it. Click the Tools tab on your menu bar. This button is between Format and Data on the menu bar at the top of your screen. Where is the Quick Analysis Lens in Excel for the Mac? I'm running Office 365. I need to be able to use the Quick Analysis button in Excel.

Quick Analysis Tool Excel Mac

1. Unfortunately, the pared down version of Excel on Mac doesn't have Quick Analysis. You'll have to vote for it in the Excel Suggestion Box (as referenced here ). Meanwhile, there seems to be a 3rd-party-option that you might be able to use (as referenced here ).
2. We can use any of these features by clicking on them and the result is reflected on your screen immediately. It gives us a shortcut to data analysis. Here we take an example to show the Quick Analysis tool feature in Excel 2013. Step 1: Open the Microsoft Excel 2013 Preview.

You can use the Analysis Toolpak add-in to generate descriptive statistics. For example, you may have the scores of 14 participants for a test.

Data Analysis In Excel

To generate descriptive statistics for these scores, execute the following steps.

1. On the Data tab, in the Analysis group, click Data Analysis.

Note: can't find the Data Analysis button? Click here to load the Analysis ToolPak add-in.

2. Select Descriptive Statistics and click OK.

3. Select the range A2:A15 as the Input Range.

4. Select cell C1 as the Output Range.

5. Make sure Summary statistics is checked.

6. Click OK.

How To Do Quick Analysis In Excel Mac

Result: