📘 PIVOT TABLE (Excel)
1️⃣ എന്താണ് Pivot Table? (What is Pivot Table?)
Pivot Table എന്നത് MS Excel ലെ ഒരു data summary tool ആണ്. Large data എളുപ്പത്തിൽ summarize ചെയ്യാനും analyse ചെയ്യാനും ഉപയോഗിക്കുന്നു.
👉 Simple definition:
Pivot Table is a tool used to summarize and analyze large data easily.
2️⃣ എന്തിനാണ് Pivot Table ഉപയോഗിക്കുന്നത്? (Why we use Pivot Table?)
- Total കണ്ടെത്താൻ (Find Total)
- Average കണ്ടെത്താൻ (Find Average)
- Count കണ്ടെത്താൻ
- Product / Month / Class പ്രകാരം summary തയ്യാറാക്കാൻ
- Report തയ്യാറാക്കാൻ
3️⃣ Example 1 – Sales Data
| Date | Product | Salesman | Amount |
|---|---|---|---|
| Jan | Pen | Arun | 500 |
| Jan | Pencil | Arun | 300 |
| Feb | Pen | Manu | 700 |
| Feb | Pencil | Arun | 400 |
| Mar | Pen | Manu | 600 |
🎯 Question: Product പ്രകാരം Total കണ്ടെത്തുക
🪜 Steps:
- Full table select ചെയ്യുക
- Insert → Pivot Table click ചെയ്യുക
- OK click ചെയ്യുക
- Product → Rows area ലേക്ക് drag ചെയ്യുക
- Amount → Values area ലേക്ക് drag ചെയ്യുക
✅ Result:
| Product | Total Amount |
|---|---|
| Pen | 1800 |
| Pencil | 700 |
| Total | 2500 |
4️⃣ Important Areas of Pivot Table
| Area | Use |
|---|---|
| Rows | Category names (eg: Product) |
| Columns | Headings |
| Values | Calculation (Sum, Avg) |
| Filters | Data filter ചെയ്യാൻ |
🧪 Practical Lab Exercise
Exercise 1
Create the following table in Excel and make Pivot Table.
| Name | Class | Marks |
|---|---|---|
| Anu | A | 80 |
| Manu | A | 70 |
| Ravi | B | 90 |
| Meera | B | 60 |
Task:
- Class പ്രകാരം Average Marks കണ്ടെത്തുക
- Marks → Values
- Value Field Settings → Average തിരഞ്ഞെടുക്കുക
📝 5 Mark Question Answer
Q: What is Pivot Table? Explain its uses.
Pivot Table is an Excel tool used to summarize and analyze large amount of data easily. It helps to calculate total, average, count and compare data quickly. It is mainly used for report preparation and data analysis.
📝 8 Mark Question Answer
Q: Explain Pivot Table with steps and advantages.
Pivot Table is a data analysis tool available in MS Excel. It is used to summarize, organize and analyse large data easily.
Steps to create Pivot Table:- Select the data table.
- Click Insert tab.
- Select Pivot Table.
- Choose location and click OK.
- Drag fields into Rows, Columns and Values area.
- Easy calculation
- Saves time
- Automatic summary
- Useful for reports
- User friendly
📌 Short Exam Definition
Pivot Table is a tool in MS Excel used to summarize and analyze large data quickly and easily.