Excel Day 1: rows, columns aur pehla formula (free mini-course)
Excel bilkul zero se: cell, row, column kya hain, data kaise bharein, aur SUM, AVERAGE jaise pehle formule. 30 minute ka pehla din, practice ke saath.

- Har cell ka ek pata hota hai, jaise B3 (column B, row 3).
- Har formula = (barabar) se shuru hota hai.
- Aaj ke 3 formule: SUM, AVERAGE aur MAX/MIN.
Is post mein
Office ki lagbhag har naukri mein Excel aata hai ya nahi, yeh poochha jaata hai. Achhi baat: basic Excel seekhne mein bas kuch din lagte hain. Yeh hamare free mini-course ka pehla din hai. Excel na ho to Google Sheets (free) mein bhi yahi sab chalta hai.
Cell, row aur column
- Column upar se neeche jaate hain, naam A, B, C…
- Row baayen se daayen, number 1, 2, 3…
- Cell woh chhota dabba jahan row aur column milte hain. Iska pata column + row hota hai, jaise B3.
Practice: mahine ka kharcha
Ek nayi sheet kholiye aur yeh bhariye:
| A | B | |
|---|---|---|
| 1 | Kharcha | Rakam |
| 2 | Kiraya | 8000 |
| 3 | Ration | 4500 |
| 4 | Bijli | 1200 |
| 5 | Phone | 399 |
| 6 | Petrol | 2500 |
Tip: numbers mein ₹ ya comma khud mat likhiye, sirf number. Format baad mein laga sakte hain.
Pehla formula: SUM
Cell A7 mein "Total" likhiye, aur B7 mein:
=SUM(B2:B6)
Enter dabaiye: 16599. B2:B6 ka matlab hai "B2 se B6 tak saare cells". Ab kisi rakam ko badaliye; total apne aap badal jaayega. Yahi Excel ki taaqat hai.
Teen aur formule
- =AVERAGE(B2:B6): ausat kharcha
- =MAX(B2:B6): sabse bada kharcha
- =MIN(B2:B6): sabse chhota
Teen shortcut jo aaj hi yaad kariye
- Ctrl + Z: galti undo
- Ctrl + S: save
- Alt + =: chune hue cells ke neeche AutoSum
Homework
- Apne asli mahine ke 8-10 kharche likhiye.
- SUM, AVERAGE, MAX aur MIN lagaiye.
- Rakam ke column ko chuniye aur Home → Number format se ₹ (currency) lagaiye.
Day 2 mein: kharche ko percentage mein dekhna aur pehla chart. Google Sheets pasand hai to padhiye: Google Sheets basics.



Comments