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.

- 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
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
| A | B | C | |
|---|---|---|---|
| 1 | Kharcha | Rakam | Hissa |
| 2 | Kiraya | 8000 | |
| 3 | Ration | 4500 | |
| 4 | Bijli | 1200 | |
| 5 | Phone | 399 | |
| 6 | Petrol | 2500 | |
| 7 | Total | 16599 |
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
- A1 se B6 tak chuniye (Kharcha aur Rakam).
- Insert → Chart → Pie.
- Chart par click → Chart Elements (+) → "Data Labels" on → percentage dikhaiye.
- 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
- Apne asli kharchon par percentage lagaiye.
- Ek column chart banaiye.
- 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.



Comments