Theoretical Questions

a) What is a Pivot Table? A Pivot Table is an interactive Excel tool that summarizes, analyzes, and explores large datasets by allowing users to rearrange (pivot) rows and columns dynamically without altering the original data.

b) Advantages of Using Pivot Table

1. Quickly summarizes thousands of rows into a compact report
2. No complex formulas required — drag-and-drop interface
3. Allows grouping, filtering, and sorting of data easily
4. Supports dynamic updates when source data changes (Refresh)
5. Can calculate Sum, Count, Average, Max, Min, etc. automatically
6. Enables cross-tabulation (rows vs. columns analysis)

c) Four Main Areas of Pivot Table Layout

d) Steps to Create a Pivot Table

1. Click any cell inside the dataset
2. Go to Insert → Pivot Table
3. Choose New Worksheet or Existing Worksheet
4. Drag fields into the four areas (Filters, Columns, Rows, Values)
5. Excel automatically calculates the summary

---

Practical Task

Sample Dataset (Employee Multi-Location Data)

---

Pivot Table A: Number of Nationality per Location

• Rows: Location
• Columns: Nationality
• Values: Count of EmpID

Pivot Table B: Number of Department / Location / Client

• Rows: Location, Department
• Columns: Client
• Values: Count of EmpID

Pivot Table C: Number of Client / Location / Nationality

• Rows: Location, Client
• Columns: Nationality
• Values: Count of EmpID