How-to do: CHARTS, SUMMARIES, PIVOT-TABLES, PARETO ANALYSIS, and VARIANCE REPORTS.

Drill 2 — How to Sort and Filter Data
This module turns a plain spreadsheet into a working analysis tool. Students learn to move through the data, isolate what matters, and prepare it for summaries, charts, PivotTables, and business decisions.
Lessons
Drill 2 — How to Sort and Filter Data in ExcelDrill 3 — How to Create PivotTables
Use PivotTables to summarize a larger spreadsheet without writing formulas for every question.
Lessons
Drill 3 — How to Use PivotTables for Business AnalysisDrill 4 — How to Use Pareto Charts
In this module, students learn how to use Excel to identify the few problems causing most of the damage.
Lessons
Drill 4 — How to Create a Pareto Chart in ExcelDrill 5 — Variance & Quarterly Reporting
This module teaches students how to build a simple variance report using sales, expenses, and profit data. The goal is to propel from spreadsheet calculations to business interpretation -> what changed, how much it changed, and why it matters.