Learn aur earn

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

Excel mini-course ka doosra din: kharche ka percentage nikaalna, absolute reference ($), sort karna, aur pie chart banana. Day 1 wali sheet par hi practice.

Sandeep Mittal 1 min read

Excel Day 2: percentage, $ ka jaadu aur pehla chart (free mini-course)
Short mein
  • Percentage formula: =B2/$B$7, phir % format lagaiye.
  • $ lagane se formula kheenchne par cell ka pata nahi badalta*.
  • Data chun kar Insert → Chart se 10 second mein chart.
Is post mein
  1. Shuruaat: Day 1 wali sheet
  2. 1. Percentage formula
  3. 2. $ ka jaadu (absolute reference)
  4. 3. Sort: sabse bada kharcha upar
  5. 4. Pehla chart
  6. Homework

Excel mini-course ka doosra din. Day 1 mein humne mahine ke kharche ki sheet banayi thi aur SUM lagaya tha. Aaj usi sheet mein: har kharcha kitne percent hai, aur uska chart.

Shuruaat: Day 1 wali sheet

ABC
1KharchaRakamHissa
2Kiraya8000
3Ration4500
4Bijli1200
5Phone399
6Petrol2500
7Total16599

1. Percentage formula

C2 mein likhiye: =B2/$B$7 aur Enter. 0.48 jaisa number aayega. Ab C2 chun kar Home → % button dabaiye: 48%.

2. $ ka jaadu (absolute reference)

C2 ke kone ke dot ko C6 tak kheenchiye. Har row mein formula apne aap badalta hai: C3 mein =B3/$B$7, C4 mein =B4/$B$7. B wala hissa badla, par $B$7 nahi badla. $ lagane se Excel us cell ko "pakad" kar rakhta hai. $ ke bina total wala cell bhi neeche khisak jaata aur galat jawab aata.

Shortcut: formula likhte waqt B7 par cursor rakh kar F4 dabaiye; $ apne aap lag jaata hai.

3. Sort: sabse bada kharcha upar

A1 se C6 tak chuniye (Total row nahi) → Data → Sort → "Rakam", "Largest to Smallest". Ab sabse bada kharcha sabse upar.

4. Pehla chart

  1. A1 se B6 tak chuniye (Kharcha aur Rakam).
  2. Insert → Chart → Pie.
  3. Chart par click → Chart Elements (+) → "Data Labels" on → percentage dikhaiye.
  4. Title badal kar likhiye: "November ka kharcha".

Kharche ki tulna ke liye pie theek hai; mahine-dar-mahine badlaav ke liye "Column" ya "Line" chart behtar hai.

Homework

  1. Apne asli kharchon par percentage lagaiye.
  2. Ek column chart banaiye.
  3. Ek naya column "Zaroorat / Shauk" jodiye; yeh Day 3 mein kaam aayega.

Day 3 mein: VLOOKUP/XLOOKUP aur IF, jisse Excel khud faisle lene lagta hai. Excel Day 3 padhiye.

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 1: rows, columns aur pehla formula (free mini-course)

Excel Day 1: rows, columns aur pehla formula (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