🔹 Pivot Table create karna kya hai?

Excel mein Pivot Table create karna ka matlab hai raw data ko ek summary report mein convert karna, jisse large data ko easily analyze aur compare kiya ja sake.

Example: Agar 500 sales records hain, to Pivot Table se hum quickly city-wise sales, product-wise sales ya salesperson-wise sales dekh sakte hain.

1. Example Data

Maan lijiye hamare paas ye sales data hai:

Ab hum City-wise Total Sales ki Pivot Table banayenge.

2. Pivot Table Create Karne ke Steps

Step 1 – Data Prepare Karein

Sabse pehle data properly arrange hona chahiye.

✅ Har column ka heading hona chahiye.

Salesperson | City | Product | Sales

❌ Beech mein unnecessary blank rows/columns avoid karein.

Step 2 – Data Select Karein

Data ke andar kisi bhi cell par click karein.

Agar complete data continuous hai, Excel usually data range automatically identify kar leta hai.

Step 3 – Insert Tab Open Karein

Excel Ribbon mein:

Insert → PivotTable

par click karein.

Step 4 – Table/Range Check Karein

PivotTable dialog box open hoga.

Yahan Excel selected data ka Table/Range show karega.

Example:

Table/Range:
A1:D6

Check karein ki complete data select hua hai.

Step 5 – Location Select Karein

Excel poochega Pivot Table kahan create karni hai:

New Worksheet

Pivot Table ko new worksheet mein create karta hai.

Existing Worksheet

Current workbook ki kisi existing location par Pivot Table create karta hai.

Beginners ke liye New Worksheet generally convenient hota hai.

Step 6 – OK par Click Karein

OK par click karte hi Excel ek new Pivot Table area create karega.

Right side mein PivotTable Fields panel दिखाई देगा.

3. Fields ko Areas mein Drag Karna

Ab humein fields ko correct areas mein place karna hai.

Agar humein City-wise Total Sales chahiye:

Rows:

City

Values:

Sales

Result:

4. Pivot Table ke 4 Main Areas

Example:

Rows       → City
Columns    → Product
Values     → Sales
Filters    → Salesperson

5. Product-wise Sales

Agar humein product ke according sales dekhni ho:

Rows → Product

Values → Sales

Result:

6. City + Product Analysis

Agar humein city aur product dono ka analysis chahiye:

Rows → City

Columns → Product

Values → Sales

Example:

Ye two-dimensional analysis ka basic example hai.

7. Values mein Calculation Change Karna

Default calculation Sum ho sakti hai, lekin requirement ke according calculation change kar sakte hain.

Value Field → Value Field Settings

Phir select kar sakte hain:

• Sum
• Count
• Average
• Max
• Min

Example:

Average of Sales

ya

Count of Sales

8. Pivot Table Create Karne ka Short Process

Yaad rakhne ke liye:

Data → Insert → PivotTable → Select Range → New Worksheet → OK → Fields Drag & Drop

9. Practical Applications

Pivot Table create karke hum:

• 🛒 Product-wise sales
• 🏙️ City-wise sales
• 👨‍💼 Employee-wise performance
• 🎓 Course-wise student count
• 📦 Product-wise stock
• 💰 Department-wise expenses
• 📅 Month-wise revenue
• 📈 Average marks

ka analysis kar sakte hain.

⭐ Important Points

• Source data properly organized hona chahiye.
• Har column ka unique heading hona chahiye.
• Blank headings avoid karein.
• Pivot Table create karne se pehle complete data range check karein.
• Fields ko Rows, Columns, Values aur Filters mein drag kiya jata hai.
• Original source data generally safe rehta hai.
• Source data change hone ke baad Refresh karna useful hota hai.

⭐ Exam Points

1. Pivot Table create karne ke liye Insert → PivotTable use kiya jata hai.
2. Source data ko properly arrange karna zaroori hai.
3. Pivot Table ko New Worksheet ya Existing Worksheet mein create kiya ja sakta hai.
4. Fields ko Rows, Columns, Values aur Filters areas mein place kiya jata hai.
5. Values mein Sum, Count, Average, Max aur Min jaise calculations kiye ja sakte hain.