CHAPTER 17 · ADVANCED EXCEL
What-If Analysis & Goal Seek
What‑If tools reverse questions solve karne me help karte hain: desired result achieve karne ke liye input kitna hona chahiye?
Goal Seek
Example: EMI model me monthly payment ₹20,000 target hai. Goal Seek formula cell ko target value par set karke ek input cell adjust kar sakta hai.
Scenario thinking
Best case, expected case aur worst case inputs ko separately model karke decision range samajh sakte ho.
Data Tables
One-variable ya two-variable sensitivity analysis se different input combinations ka output grid me compare kiya ja sakta hai.
Hinglish
Normal formula input se output nikalta hai; Goal Seek output target se required input find karta hai.
Practice task
Profit = Revenue − Cost model banao aur Goal Seek se required Revenue find karo jahan Profit ₹50,000 ho.