With Analyze in Excel, you can bring Power BI datasets into Excel, and then view and interact with them using PivotTables, charts, slicers, and other Excel features. How To Get Data Analysis For Excel Mac 2011 Download.How To Get Data Analysis For Excel Mac 2011.How To Get Data Analysis For Excel Mac 2011 Full.The Analysis Tool Pack is not included in the Mac version and needs a separate program as a work-around. Note, Solver was added back into Excel 2011 with. Solver Tutorial: Excel 2011 (Mac) Summary: This tutorial will show how you can activate Solver and the Analysis ToolPa k in Excel 2011 for Mac. When we can’t find the Data Analysis button in the toolbar, we must first load the Analysis Toolpak in Mac. The Data Analysis tools can be accessed in the Data tab. This articles assists all levels of Excel users on how to load the Data Analysis Toolpak in Excel Mac. Analysis toolPak of excel contains very helpful tools for statistical, financial, and engineering data analysis. By default, this add-in is not installed in Excel. The Analysis ToolPak is an add-on in Microsoft Excel. As the article suggests, today we will learn how to add Analysis ToolPak in Excel For Mac and Windows PCs. Under Add-ins, select Analysis ToolPak and click on the Go button.