Top 15 Excel Basic Tips and Tricks for Beginners
💻 Excel kya hai?
Microsoft Excel ek powerful spreadsheet software hai jiska use data entry, calculation, report banane aur analysis ke liye kiya jata hai. Chahe aap student ho, teacher ho, accountant ho ya office employee — Excel seekhna har kisi ke liye ek zaroori skill ban chuka hai.
Is blog me hum jaanenge Excel ke basic tips and tricks, jinse aapka kaam fast aur easy ho jayega.
🔥 1. Quick Sum, Average aur Count
Excel me kisi range (e.g. A1:A10) ko select karte hi, niche status bar me automatically Sum, Average aur Count show hota hai.
Shortcut: Alt + = → instantly SUM formula lagata hai.
⚙️ 2. AutoFill Feature
Kisi cell me “Monday” likh kar uska corner drag karein — Excel automatic “Tuesday, Wednesday…” fill karega.
Numbers (1, 2, 3…) aur formulas ke liye bhi kaam karta hai.
🧾 3. Paste Special ka Magic
Kisi value ko copy karke Ctrl + Alt + V dabayein.
Yahan se aap choose kar sakte ho:
Sirf Values paste karni hai
Sirf Formulas paste karni hai
Ya formatting copy karni hai
🔍 4. Find and Replace Shortcut
Ctrl + F → Find text
Ctrl + H → Find & Replace text
Example: “Marks” ko replace karke “Student Marks” likhna ho to ye best hai.
📌 5. Freeze Panes
Agar heading scroll karne par chhup jati hai, to:
View → Freeze Panes → Freeze Top Row
isse heading hamesha visible rahegi.
🎨 6. Conditional Formatting
Data ko attractive aur readable banane ke liye:
Home → Conditional Formatting → Highlight Cell Rules
Example: Marks > 40 → Green, Marks < 40 → Red.
📊 7. Instant Chart Banaye
Data select karke Alt + F1 dabayein — Excel turant chart bana dega.
Manual option: Insert → Recommended Charts
⌨️ 8. Excel Shortcuts List
Action Shortcut
New File Ctrl + N
Save Ctrl + S
Bold / Italic / Underline Ctrl + B / I / U
Insert Row Ctrl + Shift + +
Delete Row Ctrl + -
Select Column Ctrl + Space
Select Row Shift + Space
Next Sheet Ctrl + Page Down
Previous Sheet Ctrl + Page Up
✅ 9. IF Function
Agar aapko result check karna ho:
=IF(A2>=40,"Pass","Fail")
A2 me agar marks 40 ya zyada hain to “Pass”, warna “Fail”.
🔗 10. Sheet Linking
Ek sheet ka data dusri sheet me dikhana ho:
=Sheet1!A1
Ye Sheet1 ke A1 cell ka data current sheet me dikhayega.
🕒 11. Date and Time Functions
Function Use
=TODAY() Aaj ki date
=NOW() Aaj ki date + time
🧹 12. Remove Duplicates
Duplicate data hatane ke liye:
Data → Remove Duplicates
🧩 13. Text to Columns
Ek hi cell me likha “First Last” ko separate karne ke liye:
Data → Text to Columns → Space → Finish
🔢 14. Sort aur Filter
Data ko arrange karne ke liye:
Sort A to Z / Z to A
Ctrl + Shift + L → Filter enable
🔒 15. Protect Sheet
Agar kisi sheet ko edit hone se bachana ho:
Review → Protect Sheet → Password lagayein
🎯 Conclusion
Excel ke ye basic tips aur tricks aapke daily kaam ko 5x fast bana sakte hain. Agar aap student ya office employee hain, to Excel ki practice roz karein — kyunki har job me Excel ka use hota hai.
📘 Related Topics:
Excel ke Basic Formulas
Advanced Excel Tips
Excel IF, AND, OR Functions
Data Analysis with Excel
💬 Pro Tip:
Agar aap Excel ko practically seekhna chahte hain, to KAiSH Computer Institute me join karein — yahan par Excel ke saath aapko Computer Basics, MS Office aur Data Analysis ka professional training milta hai.
📞 Call: 7348033936
🌐 Visit: www.kaishclasses.com