MS Excel Guidelines (Hindi/Urdu)

MS Excel Kya Hai? Full Guide with Examples

📌 Excel Kya Hai?

Microsoft Excel ek powerful spreadsheet software hai jo calculations, data analysis aur reports banane ke liye use hota hai.

✨ Excel Ke Main Uses

• Data Entry & Organization
• Mathematical Calculations
• Graphs aur Charts
• Invoices, Budgets, Attendance Sheets

✅ Popular Excel Functions with Examples

1. SUM Function
=SUM(A1:A5) – A1 se A5 ka total.
=SUM(10, 20, 30) → 60
=SUM(A1, A3, A5)

2. SUMIF Function
=SUMIF(A2:A6, ">50", B2:B6)
=SUMIF(C2:C10, "Paid", D2:D10)
=SUMIF(B2:B6, "<100 b2:b6="" code="">

3. COUNT Function
=COUNT(A1:A5)
=COUNT(1,2,3,4,5)
=COUNT(A1, A3, A5)

4. COUNTIF Function
=COUNTIF(A2:A10, ">100")
=COUNTIF(B2:B10, "Female")
=COUNTIF(C2:C10, "<=60")

5. MAX Function
=MAX(A2:A10)
=MAX(10, 90, 70, 30)
=MAX(B1:B5)

6. MIN Function
=MIN(A1:A10)
=MIN(20, 5, 10)
=MIN(C2:C5)

🧮 BODMAS Rule in Excel

Excel math rules follow karta hai jaise:

• Brackets
• Orders (powers)
• Division
• Multiplication
• Addition
• Subtraction

=(10+5)*2 → Result: 30

🔍 Functions vs Formulas

Formula	Function
=A1+A2+A3	=SUM(A1:A3)
Custom logic	Built-in command

📘 MS Excel Summary

Software Name	Microsoft Excel
Developer	Microsoft
File Extension	.xls, .xlsx
Used For	Data entry, analysis, calculations
Key Tools	Cells, Charts, Tables, Formulas
Available Versions	Excel 2010, 2013, 2016, 2019, 365

🎯 Conclusion

MS Excel ek powerful tool hai har kisi ke liye. Is post mein aapne seekha Excel kya hai, key functions, formulas, aur Excel ke rules. Excel seekhna aaj ke zamane mein ek zarurat hai!

👍 Share this with friends & start your Excel journey today!