Learn aur earn

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.

Sandeep Mittal 1 min read

Excel Day 1: rows, columns aur pehla formula (free mini-course)
Short mein
  • 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
  1. Cell, row aur column
  2. Practice: mahine ka kharcha
  3. Pehla formula: SUM
  4. Teen aur formule
  5. Teen shortcut jo aaj hi yaad kariye
  6. Homework

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:

AB
1KharchaRakam
2Kiraya8000
3Ration4500
4Bijli1200
5Phone399
6Petrol2500

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

  1. Apne asli mahine ke 8-10 kharche likhiye.
  2. SUM, AVERAGE, MAX aur MIN lagaiye.
  3. 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.

Share karein

Comments

Be the first to comment

Comments appear after review. For advice on your own situation, please contact us directly.

Aur padhein

Excel Day 2: percentage, $ ka jaadu aur pehla chart (free mini-course)

Excel Day 2: percentage, $ ka jaadu aur pehla chart (free mini-course)

Excel Day 3: VLOOKUP, XLOOKUP aur IF, interview mein poochhe jaane wale formule

Excel Day 3: VLOOKUP, XLOOKUP aur IF, interview mein poochhe jaane wale formule

Professional email kaise likhein: 5 niyam aur 4 ready templates

Professional email kaise likhein: 5 niyam aur 4 ready templates