Excel में ये 3 गलतियाँ मत करना | Advanced Excel Course in Sikar
Excel Mein Calculation Galat Kyon Aati Hai? 3 Common Mistakes Aur Unke Solutions
Excel mein data enter karna aur formula lagana aana achhi baat hai. Lekin kya aapne kabhi notice kiya hai ki formula lagane ke baad bhi Total galat aa jata hai?
Kai baar formula technically sahi hota hai, lekin selected range, cell format ya calculation method ki wajah se result galat milta hai.
Aaj Microseft Computer & Typing Center, Sikar ki taraf se hum Excel ki 3 common mistakes aur unke practical solutions samjhenge.
1. Wrong Range Selection – Jab SUM Formula Mein Cell Chhoot Jaye
Maan lijiye aapke paas kuch products ki sales values hain:
| Product | Amount |
|---|---|
| Keyboard | 5000 |
| Mouse | 1600 |
| Monitor | 22500 |
| Printer | 8400 |
| Laptop | 28500 |
Aapne formula lagaya:
=SUM(B2:B5)
Result: 37,500
Lekin actual Total 66,000 hai.
Galti kya hui?
Aapne B6 cell ko formula mein include hi nahi kiya.
Correct Formula:
=SUM(B2:B6)
Correct Result: 66,000
Practical Tip: SUM Formula lagane ke baad selected range ko ek baar zaroor check karein.
2. Number Stored as Text – Jab Number Calculation Mein Include Na Ho
Excel mein kai baar numbers dikhne mein bilkul normal lagte hain, lekin woh Text format mein stored hote hain.
Aise numbers ko SUM jaise functions calculation mein ignore kar sakte hain.
Is problem ko kaise pehchanein?
Cell ke corner mein green warning triangle dikh sakta hai.
Number left-aligned ho sakta hai.
Calculation expected result nahi de rahi hoti.
Solution:
Affected cells select karein, warning icon par click karein aur Convert to Number option choose karein.
Dhyan rahe, sirf cell ka format Number kar dene se pehle se stored text hamesha convert nahi hota.
3. Wrong Formula – Jab Total Ki Jagah Average Nikal Jaye
Excel mein SUM aur AVERAGE dono useful functions hain, lekin dono ka kaam alag hai.
Agar aap formula lagate hain:
=AVERAGE(B2:B6)
Result: 13,200
Yeh values ka Average hai, Total nahi.
Agar aapko sabhi products ki amount ka Total chahiye, toh formula hoga:
=SUM(B2:B6)
Result: 66,000
Isliye formula use karne se pehle decide karein ki aapko Total, Average, Count ya koi doosri calculation chahiye.
4. Advanced Excel Mein Practical Learning Kyon Zaroori Hai?
Office work mein Excel ka use data entry, billing, sales reports, stock records aur calculations ke liye hota hai.
Sirf formulas yaad karne se kaam nahi chalega. Aapko yeh bhi samajhna hoga ki formula kab use karna hai aur result galat aane par mistake kaise identify karni hai.
Microseft Computer & Typing Center mein Advanced Excel ki practical training ke through students ko formulas, calculation checking aur spreadsheet working skills samjhayi jaati hain.
Agar aap Sikar mein Advanced Excel seekhna chahte hain, toh course details aur practical training ki jankari ke liye center visit kar sakte hain.
Advanced Excel Training in Sikar – Contact Details
Microseft Computer & Typing Center
Address: Opp. Krishana College, Near Ghanta Ghar, Chandpol, Sikar
Phone: 095096 80333
Excel seekhne ka sahi tareeka hai: Formula samjho, practical karo aur result verify karo.
Q1. Excel mein SUM Formula galat result kyon deta hai?
Agar formula ki range mein koi required cell include nahi hai ya kuch numbers text format mein stored hain, toh result expected total se alag aa sakta hai.
Q2. Excel mein Number Stored as Text ko kaise correct karein?
Cell select karke warning menu mein Convert to Number option use kar sakte hain. Zarurat padne par VALUE function bhi useful hota hai.
Q3. Excel mein SUM aur AVERAGE mein kya difference hai?
SUM selected numeric values ko add karta hai, jabki AVERAGE unka arithmetic mean calculate karta hai.
Q4. Sikar mein Advanced Excel ki practical training kahan seekhein?
Microseft Computer & Typing Center, Near Ghanta Ghar, Sikar mein Advanced Excel course ki jankari aur practical training ke liye sampark kar sakte hain.
Advanced Excel Course in Sikar, Excel Formula Training Sikar, Excel Calculation Mistakes, Excel SUM Formula Error, Wrong Range Selection in Excel, Number Stored as Text, SUM vs AVERAGE Formula, Excel Practical Training Sikar, Excel Calculation Errors and Solutions, Excel Tips and Tricks, Excel Spreadsheet Mistakes, Microseft Computer & Typing Center Sikar
#AdvancedExcelSikar #ExcelFormula #ExcelMistakes #ExcelTips #MicroseftSikar
टिप्पणियाँ
एक टिप्पणी भेजें