🔹 Goal Seek kya hai?

Goal Seek Microsoft Excel ka ek What-If Analysis tool hai. Iska use tab kiya jata hai jab humein final result (target) pata ho, lekin us result ko achieve karne ke liye input value kitni honi chahiye, ye find karna ho.

Simple words mein:

Goal Seek “Target Result” ko achieve karne ke liye required input value find karta hai.

1. Simple Example

Maan lijiye:

• Sales = ₹1,00,000
• Expenses = ₹70,000
• Profit = ₹30,000

Formula:

=Sales-Expenses

Ab humein ₹50,000 profit chahiye.

Question:

₹50,000 profit achieve karne ke liye Sales kitni honi chahiye?

Yahan Goal Seek required Sales value find karega.

Agar expenses ₹70,000 hain:

Required Sales = ₹1,20,000

2. Goal Seek ke 3 Important Parts

Goal Seek mein mainly 3 values important hoti hain:

① Set Cell

Wo cell jisme final result/formula hai.

Example:

Profit Cell

② To Value

Wo target value jo humein achieve karni hai.

Example:

₹50,000

③ By Changing Cell

Wo input cell jisko Excel change karega taaki target achieve ho sake.

Example:

Sales Cell

Easy Formula:

Set Cell → Target Result → Changing Cell

3. Goal Seek ka Practical Example

Suppose:

Profit formula:

=B2-B3

Ab target profit hai:

₹50,000

Goal Seek:

Set Cell: Profit
To Value: 50000
By Changing Cell: Sales

Excel Sales ko automatically change karke required value find karega.

Result:

4. Goal Seek Open Karne ka Path

Excel mein:

Data → What-If Analysis → Goal Seek

Goal Seek dialog box mein:

Set cell:       Profit Cell
To value:       50000
By changing cell: Sales Cell

Phir OK par click karein.

Excel required input value calculate karega.

5. Student Marks Example

Goal Seek education mein bhi useful hai.

Suppose student ke marks:

Student ko 80% overall percentage chahiye.

Goal Seek se Maths ke required marks find kiye ja sakte hain.

Example:

Set Cell: Percentage
To Value: 80
By Changing Cell: Maths Marks

Excel required Maths marks calculate karega.

6. Business Example

Suppose:

• Product Price = ₹500
• Quantity = 1,000
• Revenue = ₹5,00,000

Company ka target revenue:

₹7,50,000

Question:

Target revenue achieve karne ke liye quantity kitni honi chahiye?

Goal Seek mein:

Set Cell: Revenue
To Value: ₹7,50,000
By Changing Cell: Quantity

Excel required quantity find karega.

7. Financial Example

Suppose loan calculation mein:

• Loan Amount = ₹5,00,000
• Interest Rate = 10%
• EMI = Formula

Agar target EMI ₹10,000 hai, to Goal Seek ke through kisi changing input—jaise loan amount ya tenure, depending on the model—ki required value find ki ja sakti hai.

Isliye Goal Seek financial planning mein bhi useful hai.

8. Goal Seek ki Important Features

• 🎯 Target value set kar sakte hain
• 🔢 Required input automatically find karta hai
• 📊 Formula-based calculations ke saath kaam karta hai
• 💰 Financial calculations mein useful
• 📈 Sales aur profit analysis mein useful
• 🎓 Marks/percentage calculations mein useful
• ⏱️ Trial-and-error calculation ka time bachata hai

9. Goal Seek ki Limitations

Goal Seek powerful hai, lekin kuch limitations hain:

• Ek time par sirf ek changing cell use karta hai.
• Formula wala Set Cell hona chahiye.
• Target value achieve karne ke liye calculation model properly set hona chahiye.
• Agar suitable solution possible nahi hai, Excel desired result nahi de payega.

🔄 Goal Seek vs Scenario Manager

⭐ Exam Points

• Goal Seek Excel ka What-If Analysis tool hai.
• Iska use target result achieve karne ke liye required input value find karne mein hota hai.
• Path: Data → What-If Analysis → Goal Seek
• Iske 3 main parts hain:
  1. Set Cell
  2. To Value
  3. By Changing Cell
• Set Cell mein generally formula/result hota hai.
• To Value mein desired target enter kiya jata hai.
• By Changing Cell mein input value hoti hai jise Excel change karta hai.
•