Aaj ke digital zamane mein agar aapko Computer ki knowledge hai lekin Microsoft Excel nahi aata, toh achi Naukri milna mushkil hai. Data Entry se lekar Data Analyst tak, har job mein Excel Formulas puche jate hain.
Is article mein hum aapke liye laye hain MS Excel All Formulas List in Hindi. Yahan humne un sabhi formulas ko explain kiya hai jo office work mein daily use hote hain.
1. Basic Math Formulas (Hisab-Kitab ke liye)
Ye wo formulas hain jo har beginner ko aane chahiye.
| Formula | Syntax (Example) | Kya Kaam Karta Hai? (Description) |
|---|---|---|
| SUM | =SUM(A1:A10) | Kisi bhi list ke numbers ko **Jodne (Add)** ke liye use hota hai. |
| AVERAGE | =AVERAGE(A1:A5) | Numbers ka **Ausat (Average)** nikalne ke liye. |
| MIN | =MIN(B1:B20) | List mein se sabse **Choti Sankhya** dhundhne ke liye. |
| MAX | =MAX(B1:B20) | List mein se sabse **Badi Sankhya** dhundhne ke liye. |
| COUNT | =COUNT(A1:A10) | Ginta hai ki kitne cells mein number likhe hain. |
2. Text Functions (Naam Sudharne ke liye)
Jab Data Entry mein spelling mistakes hoti hain, toh ye formulas kaam aate hain.
| Formula | Syntax | Hindi Description |
|---|---|---|
| UPPER | =UPPER(A1) | Saare aksharon ko **CAPITAL LETTER** mein badal deta hai. |
| LOWER | =LOWER(A1) | Saare aksharon ko **small letter** mein kar deta hai. |
| PROPER | =PROPER(A1) | Har shabd ka pehla akshar bada kar deta hai (Jaise: Rahul Kumar). |
| TRIM | =TRIM(A1) | Naam ke aage-piche se faltu **Spaces** ko hata deta hai. |
| CONCATENATE | =CONCATENATE(A1, " ", B1) | Do alag-alag cells ke data ko **Jodne** ke liye (Jaise: First Name + Last Name). |
🚀 Excel mein Expert Banna Hai?
Sirf formulas ratne se kaam nahi chalega. Agar aapko ₹25,000+ ki job chahiye, toh aapko **Advance Excel** aana chahiye. Ye book hazaron students use kar rahe hain.
Microsoft Excel 2019 - Data Analysis
Isme Pivot Table, VLOOKUP aur Macros sab kuch sikhaya gaya hai.
👉 Check Price on Amazon3. Advanced Formulas (Interview Special) 🔥
Ye formulas sabse zyada interview mein puche jate hain. Inhe dhyan se samjhein.
| Formula | Syntax | Hindi Description |
|---|---|---|
| VLOOKUP | =VLOOKUP(Value, Table, Col_Index, 0) | Bade data mein se kisi ek insaan ka data dhundhne ke liye. Yeh sabse important formula hai. |
| IF | =IF(A1>33, "Pass", "Fail") | Condition lagane ke liye. (Agar number 33 se zyada hai to Pass, nahi to Fail). |
| COUNTIF | =COUNTIF(A1:A10, "Present") | Ginta hai ki koi cheez kitni baar aayi hai (Jaise: Attendance count karna). |
| DROP DOWN | Data > Data Validation | Cell mein List banane ke liye jisse user select kar sake. |
= lagakar formula ka naam likhna shuru karein, Excel khud aapko suggestion de dega.
4. Date & Time Formulas
| Formula | Kaam (Usage) |
|---|---|
| =TODAY() | Aaj ki Tareekh (Date) dikhata hai. |
| =NOW() | Aaj ki Date aur Abhi ka Time dono dikhata hai. |
| =DATEDIF(Start, End, "Y") | Do tareekhon ke beech ka antar (Age Calculator) nikalne ke liye. |
Conclusion
Doston, ye thay Excel ke Top 20+ Formulas jo aapko aane hi chahiye. Agar aap inki practice daily karenge toh aap kabhi bhi office work mein nahi rukenge. Agar aapko VLOOKUP par alag se article chahiye toh comment mein zaroor batayein.