Master Class on Solver and Goal Seek

Course Fee - INR 999 /- only

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

Solver & Goal Seek
  • Solver & Goal Seek
Working Files - (Download)
  • Working Files - (Download)

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