Found insideThe new Microsoft Excel 2016 for Microsoft also carries a new Analysis ToolPak for statistical functions and new data filter buttons to help you add filter data in a pivot table. Note, Solver was added back into Excel 2011 with. Click the Data tab > Data Analysis command to see that the Data Analysis tools are now activated. Go to the Tools menu in the main menu bar & select Excel Add-ins which should produce this dialog window: Tick the check box for Analysis ToolPak then click OK. We have successfully loaded the Analysis Toolpak. Follow these steps to load the Analysis ToolPak in Excel 2016 for Mac: Click the Tools menu, and then click Excel Add-ins.
