Solver is one of the hidden Gem of excel which is rarely used by people. Do you know that solver is the best *What If Analysis Tool*, through which we can minimize cost or maximize profit within the constraints given? Solver is much much powerful tool than Goal Seek. Let's do mastery on it.
👉 What is Goal Seek, Where is its use.
👉 Limitation of Goal Seek, Very limited use.
👉 Let's Understand Solver, How to Install i
👉 What is Goal Seek, Where is its use.👉 Limitation of Goal Seek, Very limited use.
👉 Few Business uses of Solver
👉 How to make scenarios for comparision
👉 Let's solve some business Problems: