Complete Guide to Excel 365: What-If Analysis Solver & Analysis ToolPak

“Excel s Scenario Manager allows you to create named scenarios with different values for key variables. These scenarios can be quickly examined and summarized using the What-If Analysis tool.
In this course you ll use GoalSeek and Solver both of which are mathematical tools. Goal Seek comes in handy when solving quadratic cubic or other equations. Solver is much more powerful and allows complex constrAIned optimization problems to be easily defined and addressed.
As you ll recognize Solver s interface used for specifying objective functions and constrAInts is intuitive and easy to use.
Next you ll use several heavy-duty statistical techniques in Analysis ToolPak. These range from the creation of correlation and covariance matrices hypothesis testing and F-test and T-test interpretations to ANOVA random and periodic sampling and the construction and analysis of linear regression models.”