🔄 LEVEL 7: PIVOT TABLES

🔹 PART 1: What is a Pivot Table?

📌 Simple Meaning

A Pivot Table is a tool that helps you:

• Summarize large data quickly
• Calculate totals, averages, counts
• Analyze data without writing formulas

👉 You can change views by drag & drop.

📌 Used by:

• Teachers (marks analysis)
• Accountants (expenses)
• Data analysts (reports)
• Management (dashboards)

🔹 PART 2: Sample Data (Very Important)

First, type this data exactly in Excel:

📌 Rule:

• No blank rows