Enable Analysis Tools The analysis tools in Excel need to be switched on before use. To enable the Data Analysis tools: Select Options from the File tab Choose Add-ins At the bottom of the box, select Excel Add-ins and click Go Ensure both the Analysis ToolPak and Solver Add-in are ticked and click OK Performing … Continue reading Analysis Functions in Excel 2010