#Quick analysis tool in excel for mac how to#
How to turn on/off the Quick Analysis feature
If the Data Analysis command is not available in your version of Excel, you need to load the Analysis ToolPak add-in program. In the Add-Ins box, check the Analysis ToolPak check box, and then click OK. Where is the quick analysis tool in Excel 2016 Mac?įollow these steps to load the Analysis ToolPak in Excel 2016 for Mac: Click the File tab, click Options, and then click the Add-Ins category.