Microsoft Excel’s Data Analysis Toolpak is an invaluable add-in for those who require complex statistical or engineering analyses.

After opening Excel, click File. At the bottom of the File menu, click Options. Click Add-Ins and then Go… . This opens an additional pop-up window that allows you to select the Analysis ToolPak.

Discover how Python in Excel transforms data analysis with advanced features. Is it worth the hype? Find out if it’s right for your workflow.

If you get prompted that the Solver Add-in is not currently installed on your computer, you will be prompted. Click Yes to install it. Now read: How to use Data Visualizer Add-In for Excel.