.jpeg)
 |
| 10 useful Excel formulas for students |
Microsoft Excel is one of the most useful computer applications for students, teachers, employees and business professionals.
Excel mein formulas ka use calculations ko fast aur accurate banane ke liye kiya jata hai.
Aaj hum 10 important Excel formulas ko simple examples ke saath samjhenge.
Read More break
1. SUM Formula
Syntax
=SUM(A1:A10)
Example
Agar A1 se A5 mein numbers hain:
| A |
|---|
| 10 |
| 20 |
| 30 |
| 40 |
| 50 |
Formula:
=SUM(A1:A5)
Result:
150
2. AVERAGE Formula
Average calculate karne ke liye:
=AVERAGE(A1:A5)
Example:
10, 20, 30, 40, 50
Average = 30
3. COUNT Formula
Numbers ki counting ke liye:
=COUNT(A1:A10)
4. MAX Formula
Sabse badi value find karne ke liye:
=MAX(A1:A10)
5. MIN Formula
Sabse chhoti value ke liye:
=MIN(A1:A10)
6. IF Formula
Condition check karne ke liye:
=IF(B2>=40,"Pass","Fail")
Example:
Agar marks 40 ya usse zyada hain → Pass
Agar marks 40 se kam hain → Fail
7. COUNTIF Formula
Specific condition ke according counting:
=COUNTIF(B2:B20,"Pass")
8. SUMIF Formula
Condition ke according total:
=SUMIF(A2:A10,"Excel",B2:B10)
9. TODAY Formula
Current date ke liye:
=TODAY()
10. CONCAT / TEXTJOIN
Text ko combine karne ke liye useful.
Example:
=CONCAT(A2," ",B2)
Agar:
A2 = Javed
B2 = Ahmad
Result:
Javed Ahmad
PART 5 — Practical Example
Article ko sirf theory mat banana.
Ek proper table banao:
| Student | Marks | Result |
|---|---|---|
| Rahul | 78 | Pass |
| Aman | 35 | Fail |
| Javed | 85 | Pass |
| Arjun | 42 | Pass |
Phir IF formula:
=IF(B2>=40,"Pass","Fail")
Ye tumhari website ko practical learning platform banayega.
Conclusion
Excel formulas can save time, reduce manual calculations and improve accuracy. Students who regularly practise these basic formulas can gradually move towards advanced Excel functions, dashboards and data analysis.
Next Lesson
Coming Next: 20 Excel Keyboard Shortcuts Every Student Should Know
