Excel Boot Camp — Business Survival Skills

Please log in to access your purchased courses.

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 Excel

Drill 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 Analysis

Drill 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 Excel

Drill 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.

Lessons

Drill 5 — Variance Reporting
Drill 1 – How to Make a Bar Chart in Excel
Scroll to Top