excel-sikho.xlsx
Sheet1 · Basics
Sheet2 · Formulas
Sheet3 · Functions
Sheet4 · Shortcuts
Sheet5 · Practice ✏️
Sheet6 · 200+ Formulas 📚
Sheet1
Excel ka basic structure
Har spreadsheet ek grid hai — columns (A, B, C...) aur rows (1, 2, 3...). Jahan column aur row milte hain, wahan banta hai ek cell, jaise B4.
CELL
Cell Reference
Har cell ka apna address hota hai — column pehle, row baad me.
B4 = Column B, Row 4
RANGE
Cell Range
Ek se zyada cells ko colon (:) se jodkar range banti hai.
A1:A5 = A1 se A5 tak
TYPE
Data ke prakar
Cell me number, text, ya formula — teeno aa sakte hain.
42 "Hello" =A1+A2
SHEET
Worksheet vs Workbook
Ek file (workbook) ke andar kai sheets ho sakti hain — jaise iss page ke tabs.
Sheet1, Sheet2, Sheet3...
Sheet3
Thoda advanced — logic wale functions
Yeh functions decision lene aur data dhundhne me madad karte hain — office ke real kaam me sabse zyada use hote hain.
IF
=IF(condition, sahi, galat)
Agar condition sach hai to pehla jawab, warna dusra.
=IF(A1>50,"Pass","Fail")
COUNTIF
=COUNTIF(range, condition)
Range me kitni cells ek condition follow karti hain, gin deta hai.
=COUNTIF(A1:A20,">10")
VLOOKUP
=VLOOKUP(value, table, col, false)
Ek badi table me se ek value ko dhundh kar uske saath wali cell laata hai.
=VLOOKUP("Ravi",A2:C50,2,FALSE)
CONCAT
=CONCATENATE(a,b)
Do ya zyada text values ko jod deta hai.
=CONCATENATE(A1," ",B1)
Sheet4
Keyboard shortcuts jo time bachate hain
In shortcuts ko yaad kar liya to mouse ka use kaafi kam ho jayega.
| Kaam | Windows | Mac |
| Sab select karo | Ctrl+A | ⌘+A |
| Bold karo | Ctrl+B | ⌘+B |
| Undo | Ctrl+Z | ⌘+Z |
| Naya row/column insert | Ctrl++ | ⌘++ |
| Row/column delete | Ctrl+- | ⌘+- |
| Formula dikhao | Ctrl+` | ⌘+` |
| Sum turant lagao | Alt+= | ⌘+⇧+T |
Sheet5
Ab khud try karo — yeh asli spreadsheet hai
Kisi cell pe click karo, number ya formula type karo, aur Enter dabao. Neeche diye buttons se sample formulas bhi daal sakte ho.
A1
fx
Sheet6
0+ Excel Formulas
BEGINNER → INTERMEDIATE → ADVANCED → EXPERT tak, ek jagah
Beginner
Intermediate
Advanced
Expert
Kuch nahi mila 🙈 — spelling check karo ya filter hatao.