Now the Data Analysis command is available on the Data tab.
Follow these steps to load the Analysis ToolPak in Excel 2016 for Mac: Click the Tools menu. The Analysis ToolPak is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel. You can also use built-in add-ins created by Microsoft or third-party Excel add-ins that you can purchase from a wide variety of vendors.īefore you can use any Excel add-in program, the add-in must be installed in the proper folder on your hard drive, and then you must select the add-in in the Add-Ins dialog box.
Office Add-ins aren’t the only ones that you can use to extend Excel 2016’s built-in features in some way. I've looked around on the MS website and can't find a way to download this feature. I use some of the functions of the toolpak occassionally, and find some of my users unable to install this - probably due to some limited, corporate version of Excel that did include this in the original install. Does anyone know if it's possible (how & where?) to add the Analysis ToolPak to installed versions of Excel which don't already have this available in their library?
