Using Microsoft Excel Solver to Solve Multiple Equations
Microsoft Excel Solver is a powerful tool that addresses some of the limitations of Goal Seek. In this video, we will see how we can use it to solve multiple linear equations. Solver can also be used to solve more complex problems such as optimization, cost-volume-profit problem and so on. Our focus today, however, is on multiple linear equations.
[Sorry for the poor audio - a better version is uploaded here: • Using Microsoft Excel Solver to Solve Mult... ]
Brief introduction of Solver tool 00:24
How do I load the solver add-in? 01:12
How to prepare the data for the solver tool? 03:20
Cell naming 03:34
Solver function 05:50
You can practise with the file used for the training below:
https://drive.google.com/file/d/1tjX2...