Micro Free Course — 100% Free Learning
All lessons in this module are free to learn. Sign in with Google to save your progress.
EXCEL PIVOT TABLES
Summarize large datasets without formulas using Pivot Tables, Slicers, and Timelines.
Module Content
Pivot Table Basics
Learn how to create and configure Pivot Tables to summarize large datasets. Note: Always right-click your PivotTable and click Refresh to pull in new source data updates!
Interactivity
Adding Slicers and Timelines to filter your data
Conditional Formatting & Charts
Apply conditional formatting rules to highlight key data patterns, and create Pivot Charts (bar and line) to visualize pivot table summaries.
GUIDE: Report Connections, Date Grouping & Formatting
Learn how to connect Slicers to multiple Pivot Tables, group date fields by Month/Year, and apply persistent conditional formatting.
QUIZ: Pivot Tables
SUBMISSION: Pivot Tables
Using the provided dataset, create a Pivot Table report in Excel: 1) Build a Pivot Table summarizing sales/revenue by at least two dimensions (e.g., region and product). 2) Add a Slicer for one dimension and a Timeline for date filtering. 3) Create a Pivot Chart from your table. 4) Format the report with clear headers and number formatting. Submit your completed .xlsx file.