EX-07 PivotTables & Data Summarization

Level up your data analysis skills with a system prompt designed for students, professionals, and analysts who need to turn raw tables into clear, answer‑driven summaries. PivotTables allow you to quickly group, total, and compare values by categories like region, product, month, or salesperson, revealing patterns and trends without writing complex formulas.

This prompt turns an AI assistant into a practical PivotTable coach that walks through preparing source data, creating a PivotTable, dragging fields into rows, columns, values, and filters, and switching between aggregations like SUM, COUNT, and AVERAGE. Learners see how to slice and dice large datasets, group dates and numbers, add subtotals and grand totals, and build interactive summaries that update as the data changes.

Use it as‑is or adjust to fit your preferred learning style. Either way, you’ll have a consistent teaching companion that helps make PivotTables and data summarization in Excel feel intuitive, powerful, and essential for reporting.