Aaj ki class mein hum Microsoft Excel ke 5 basic aur important formulas ke baare mein practical way mein samjhenge.
Ye formulas beginners ke liye bahut important hain aur Excel mein basic calculations karne ke liye frequently use hote hain.
Aaj hum ye 5 formulas padhenge:
- SUM
- AVERAGE
- COUNT
- MAX
- MIN
Hum in sabhi formulas ko examples ke saath practically samjhenge.
Excel Formulas Ka Basic Use
Excel mein agar humein kisi data ka calculation karna ho, to formulas ka use karke hum seconds mein result nikal sakte hain.
यदि आप Data Analyst Course सीखना चाहते हैं तो हमारी Technical Team से बात कर सकते हैं!
(HR: 9034756711 | MD: 9017940459)
Example
Maan lijiye students ke marks hain:
- 50
- 60
- 70
- 80
- 90
Ab humein alag-alag calculations karni hain:
- Total Marks → SUM
- Average Marks → AVERAGE
- Total Numeric Entries → COUNT
- Highest Marks → MAX
- Lowest Marks → MIN
Yaani ye basic formulas daily Excel work mein bahut useful hain.
Practical Excel Table
Sabse pehle Excel mein ek simple table create karte hain.
| Name | Course | Marks |
| Ram | BAP | 60 |
| Sohan | C | 70 |
| Mohan | C++ | 80 |
| Raju | HTML | 50 |
| Sonu | Java | 90 |
Table ko readable banane ke liye aap:
- Headers ko Bold kar sakte hain
- Text ko Center Align kar sakte hain
- Column width adjust kar sakte hain
- Font size change kar sakte hain
1. SUM Formula
What is SUM Formula?
Complete Lesson in This Video; So Watch Completely!! 👇 👇 👇
SUM formula ka use multiple numbers ka total calculate karne ke liye hota hai.
Syntax
=SUM(range)
Example
Agar Marks column mein values 60, 70, 80, 50, 90 hain, to hum likhenge:
=SUM(C2:C6)
Iska result hoga:
350
Calculation
60 + 70 + 80 + 50 + 90 = 350
Yaani students ke total marks 350 hain.
SUM Formula Ka Real-Life Use
SUM formula sirf students ke marks ke liye nahi hai.
Ye use ho sakta hai:
- Monthly Sales
- Yearly Sales
- Employee Salary Data
- Expenses
- Revenue
- Product Quantity
- Total Orders
Example
Agar January se December tak sales data diya hai, to SUM formula se poore year ki total sales quickly calculate ki ja sakti hai.
2. AVERAGE Formula
What is AVERAGE Formula?
AVERAGE formula ka use numbers ka mathematical average calculate karne ke liye hota hai.
Basic Concept
Agar total marks 350 hain aur total students 5 hain:
350 ÷ 5 = 70
Isliye average marks 70 hain.
Excel Formula
=AVERAGE(C2:C6)
Result:
70
AVERAGE Formula Ka Real-Life Use
AVERAGE formula ka use bahut saare areas mein hota hai.
For example:
- Students ke average marks
- Employees ki average salary
- Average sales
- Average performance
- Average revenue
- Average rating
Agar data bahut large hai, to manually calculation karne ke bajay Excel formula se seconds mein average nikala ja sakta hai.
3. COUNT Formula
What is COUNT Formula?
COUNT formula ka use kisi range mein available numeric values ki counting karne ke liye hota hai.
Syntax
=COUNT(range)
Example
Agar C2 se C6 tak marks diye gaye hain:
=COUNT(C2:C6)
Result:
5
Kyuki range mein 5 numeric values available hain.
COUNT Sirf Numbers Ko Count Karta Hai
Ye point bahut important hai.
COUNT formula sirf numeric values ko count karta hai.
Agar range mein:
- Numbers hain → Count honge
- Text/Name hai → Count nahi hoga
Example
Agar data mein ye values hain:
60, 70, 80, 50, 90, Sonu
To COUNT ka result hoga:
5
Sonu ek text value hai, isliye COUNT usko ignore kar dega.
COUNT Formula Ka Real-Life Use
COUNT ka use kiya ja sakta hai:
- Total numeric entries
- Number of marks entered
- Sales entries
- Employee numeric records
- Transaction data
- Numerical datasets
4. MAX Formula
What is MAX Formula?
MAX formula ka use kisi range mein available highest value find karne ke liye hota hai.
Digital Thinker Help – Best IT Company in Yamunanagar
Syntax
=MAX(range)
Example
Agar marks hain:
60, 70, 80, 50, 90
To formula:
=MAX(C2:C6)
Result:
90
Kyuki 90 sabse highest value hai.
MAX Formula Ka Real-Life Use
MAX formula ka use karke hum identify kar sakte hain:
- Highest Marks
- Highest Sales
- Highest Salary
- Highest Revenue
- Highest Performance
- Maximum Quantity
Example
Agar monthly sales ka data hai aur aapko find karna hai ki kis month mein maximum sales hui, to MAX formula useful hoga.
5. MIN Formula
What is MIN Formula?
MIN formula ka use kisi range mein available lowest value find karne ke liye hota hai.
Ye MAX formula ka opposite hai.
Syntax
=MIN(range)
Example
Agar marks hain:
60, 70, 80, 50, 90
To formula:
=MIN(C2:C6)
Result:
50
Kyuki 50 sabse lowest value hai.
MIN Formula Ka Real-Life Use
MIN formula ka use kiya ja sakta hai:
- Lowest Marks
- Lowest Sales
- Lowest Salary
- Lowest Revenue
- Minimum Quantity
- Lowest Performance
Excel Ke 5 Basic Formulas – Quick Revision
| Formula | Use | Example Result |
| SUM | Total calculate karna | 350 |
| AVERAGE | Average calculate karna | 70 |
| COUNT | Numeric entries count karna | 5 |
| MAX | Highest value finds karna | 90 |
| MIN | Lowest value finds karna | 50 |
Ek Simple Example Se Sabhi Formulas Samjhein
Maan lijiye marks hain:
60, 70, 80, 50, 90
SUM
=SUM(C2:C6)
Result → 350
AVERAGE
=AVERAGE(C2:C6)
Result → 70
COUNT
=COUNT(C2:C6)
Result → 5
MAX
=MAX(C2:C6)
Result → 90
MIN
=MIN(C2:C6)
Result → 50
Data Analytics Mein In Formulas Ki Importance
Ye 5 formulas Data Analysis ke fundamentals mein important role play karte hain.
Agar aap Excel mein Data Analytics seekhna chahte hain, to sabse pehle basic formulas aur calculations ko properly understand karna important hai. In formulas ki help se large datasets ke basic calculations quickly perform kiye ja sakte hain.
Digital Thinker Help – Data Analytics Course
Digital Thinker Help ke Data Analytics course mein Excel ke saath different data-related concepts par bhi learning focus kiya ja sakta hai.
Course mein topics jaise:
- Data Analytics Fundamentals
- Advanced Microsoft Excel
- SQL
- Database Management
- Statistics
- Data Visualization
- Excel Dashboards
- SQL Projects
- Power BI
- Tableau
- Python
jaise areas cover kiye ja sakte hain.
Practical learning ke through Excel aur Data Analytics concepts ko understand karne par focus kiya jaata hai.
Final Thoughts
Aaj ki class mein humne Excel ke 5 basic formulas ko practically samjha:
SUM
Multiple numbers ka total calculate karta hai.
AVERAGE
Numbers ka average calculate karta hai.
COUNT
Sirf numeric values ki counting karta hai.
MAX
Sabse highest value find karta hai.
MIN
Sabse lowest value find karta hai.
Ye formulas Excel aur Data Analytics ke fundamentals ke liye bahut important hain. Agar aap in basic formulas ko properly samajh lete hain, to aage ke advanced Excel aur Data Analytics concepts ko learn karna easier ho jaata hai.
Baaki Excel ke aur bhi formulas hain, jinhe hum step-by-step aage ki classes mein samajh sakte hain.
Practice karte rahiye aur Excel ko practical way mein seekhiye.
If this content is valuable for you, then please share it along with your friends, family members, pet lovers or relatives over social media platforms like as Facebook, Instagram, LinkedIn, Twitter, and more.
Do you have any experience, tips, tricks, or query regarding on this? You can drop a comment!