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

Excels 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 youll 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 youll recognize Solvers interface used for specifying objective functions and constraints is intuitive and easy to use. Next youll 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.