Master Class on Solver and Goal Seek

Course Fee - INR 500

Why it's important!

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.

COURSE CURRICULUM

Master Class on Solver and Goal Seek
  • Master Class on Solver and Goal Seek
Downloadable Working Files
  • Downloadable Working Files

Salient Features of the Course 


👉 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.

👉 Let's Understand Solver, How to Install

👉 Few Business uses of Solver           

  1. Minimize Transportaion Cost         
  2.  How much to Order          
  3. Maximize Profit
  4.  Product Mix with maximum Gross Profit        

👉 How to make scenarios for comparision

👉 Let's solve some business Problems:     

  1. Minimize Transportation cost - Decision Variable 4 factories and 4 markets - Total 16    
  2. Order Management - Constraint of Limited Capital and Space Storage     
  3. McDonald Outlet - Get Minimum Cost or Maximum Profit

👉  Q&A


CONNECT WITH US