Pivot Tables

🔹 1. Introduction to Pivot Tables

• What is a Pivot Table?

• Importance and use cases of Pivot Tables

• When and why to use Pivot Tables

• Difference between raw data and pivot summary

________________________________________

🔹 2. Preparing Data for Pivot Tables

• Formatting your data as a table (Ctrl + T)

• Ensuring clean and structured data

• No blank rows/columns

• Unique column headers

________________________________________

🔹 3. Creating a Pivot Table

• Selecting the data range

• Inserting a Pivot Table (Insert → Pivot Table)

• Choosing where to place the Pivot Table (New Sheet or Existing Sheet)

• Layout of the Pivot Table Fields pane

________________________________________

🔹 4. Understanding Pivot Table Areas

• Rows – Categorizing data (e.g., Product Names)

• Columns – Creating comparison sections (e.g., Months)

• Values – Summarizing data (e.g., Total Sales)

• Filters – Filtering entire Pivot Table by specific criteria (e.g., Region)

________________________________________

🔹 5. Basic Pivot Table Operations

• Summarizing using SUM, COUNT, AVERAGE

• Changing the summary function (e.g., from SUM to COUNT)

• Sorting data in rows/columns

• Filtering data directly from the Pivot

________________________________________

🔹 6. Formatting Pivot Tables

• Changing number formats (currency, %, etc.)

• Pivot Table styles and design

• Renaming row/column labels for clarity

________________________________________

🔹 7. Grouping Data

• Grouping dates into months, quarters, or years

• Grouping numeric values (e.g., age ranges)

• Grouping text items (e.g., cities into regions)

________________________________________

🔹 8. Pivot Table Filters and Slicers

• Using built-in filters

• Adding Slicers for visual filtering

• Using Timeline slicers for dates

________________________________________

🔹 9. Drill Down & Show Details

• Double-clicking values to explore underlying data

• “Show Details” feature to analyze specific values

________________________________________

🔹 10. Refreshing Pivot Tables

• What happens when source data changes?

• Refreshing data manually or automatically

• Refresh All vs Refresh selected

________________________________________

🔹 11. Multiple Pivot Tables

• Using one data source for multiple Pivot Tables

• Connecting multiple Pivots to one Slicer

• Handling dynamic data ranges with Excel Tables

________________________________________

🔹 12. Pivot Charts

• Creating charts directly from Pivot Tables

• Types of charts: Column, Line, Pie, etc.

• Interacting with Pivot Charts and Slicers

________________________________________

🔹 13. Calculated Fields and Items

• Creating new formulas within Pivot Tables

• Using Calculated Fields for custom metrics

• Calculated Items for working within categories

________________________________________

🔹 14. Common Scenarios to Practice

• Monthly sales summary by product

• Attendance analysis by student and date

• Expense report by category and month

• Employee count by department and location