Course overview

This course builds a practical Excel analysis workflow. You will structure workbooks, calculate reliably, join data, clean messy inputs, summarize with PivotTables, and present results in clear dashboards that stakeholders can maintain.

Complete curriculum

Every chapter and lesson

40 lessons total

01
Chapter 1 · 4 lessons
Workbook Setup
Set up Excel worksheets, tables, names, and input zones so recurring business analysis stays readable, auditable, and safe to update.
Why it matters
A clean workbook structure prevents broken formulas, duplicate edits, and confusion during reviews.
By the end, you will be able to
- Create a repeatable workbook layout with raw data, calculations, and outputs separated.
- Use Excel Tables and named ranges to keep formulas stable as data grows.
- Apply consistent formatting and sheet conventions for team collaboration.
1. 1.1
  Workbook architecture
  Separate inputs, transforms, and presentation sheets.
2. 1.2
  Structured tables
  Convert ranges to Excel Tables and use structured references.
3. 1.3
  Naming standards
  Name key ranges and sheets with clear, durable conventions.
4. 1.4
  Protection basics
  Lock formula cells while keeping input cells editable.
Study chapter 1 in detail
02
Chapter 2 · 4 lessons
Formulas and Functions
Use core Excel formulas correctly, with relative and absolute references, logic, and error handling.
Why it matters
Reliable formulas are the base layer for every metric, forecast, and management decision built in Excel.
By the end, you will be able to
- Choose relative, absolute, and mixed references for copy-safe formulas.
- Use SUMIFS, COUNTIFS, IF, and nested logic for business rules.
- Wrap formulas with clear error handling using IFERROR or equivalent checks.
1. 2.1
  Reference behavior
  Control what moves and what stays fixed when filling formulas.
2. 2.2
  Conditional aggregation
  Calculate totals and counts by one or more criteria.
3. 2.3
  Decision formulas
  Model policy logic with IF, AND, OR, and simple nesting.
4. 2.4
  Error-safe calculations
  Handle missing values and divide-by-zero cases clearly.
Study chapter 2 in detail
03
Chapter 3 · 4 lessons
Lookup Strategies
Join related datasets with modern lookup methods and choose the right pattern for performance and clarity.
Why it matters
Business analysis often depends on matching IDs, categories, or dates across separate source files.
By the end, you will be able to
- Use XLOOKUP for exact and approximate matches with clear fallback behavior.
- Apply INDEX and MATCH when flexible lookup direction is needed.
- Detect and diagnose missing keys and duplicate key problems.
1. 3.1
  Exact-key joins
  Map dimension fields into fact tables with robust key checks.
2. 3.2
  Two-way lookups
  Retrieve values by both row and column criteria.
3. 3.3
  Approximate lookups
  Use sorted thresholds for tiered pricing or scoring.
4. 3.4
  Lookup QA
  Audit unmatched rows and duplicate keys before publishing results.
Study chapter 3 in detail
04
Chapter 4 · 4 lessons
Data Cleaning
Standardize Excel text, numbers, dates, blanks, and duplicate records so source data becomes consistent and ready for trustworthy analysis.
Why it matters
Dirty data causes wrong groupings, broken joins, and misleading KPIs.
By the end, you will be able to
- Normalize text casing, whitespace, and hidden characters.
- Convert mixed-format dates and numeric text into true date and number values.
- Flag duplicates, blanks, and invalid categories with repeatable checks.
1. 4.1
  Text normalization
  Use TRIM, CLEAN, and case functions to standardize labels.
2. 4.2
  Type correction
  Turn text-like numbers and dates into real typed values.
3. 4.3
  Duplicate control
  Identify and handle repeated records safely.
4. 4.4
  Validation rules
  Apply data validation to prevent future input errors.
Study chapter 4 in detail
05
Chapter 5 · 4 lessons
Conditional Formatting
Highlight Excel outliers, overdue work, trends, and business thresholds with clear conditional rules that support fast, consistent review.
Why it matters
Good visual cues help teams find risk, opportunity, and exceptions without reading every row.
By the end, you will be able to
- Build formula-based rules for dynamic highlighting.
- Use data bars, icon sets, and color scales with business-safe thresholds.
- Avoid misleading formatting by controlling rule order and overlap.
1. 5.1
  Rule fundamentals
  Apply cell and formula rules to target meaningful conditions.
2. 5.2
  Threshold design
  Set red, amber, and green logic around business cutoffs.
3. 5.3
  Rule precedence
  Manage rule order and stop-if-true behavior to avoid conflicts.
4. 5.4
  Executive scan view
  Build a quick-review table for exceptions and priorities.
Study chapter 5 in detail
06
Chapter 6 · 4 lessons
PivotTables
Summarize large datasets with PivotTables, grouping, filters, and calculated views for stakeholder questions.
Why it matters
PivotTables let analysts answer new questions quickly without rewriting core formulas.
By the end, you will be able to
- Build PivotTables from clean tables with stable field names.
- Group dates and categories for monthly and segment-level views.
- Use slicers and value settings to present accurate summaries.
1. 6.1
  Pivot setup
  Create a PivotTable from a structured source table.
2. 6.2
  Grouping and drill-down
  Aggregate data by month, quarter, and category.
3. 6.3
  Slicers and filters
  Add interactive controls for stakeholder self-service.
4. 6.4
  Summary accuracy
  Select correct aggregations and verify totals against source data.
Study chapter 6 in detail
07
Chapter 7 · 4 lessons
KPI Charts
Create Excel chart types that match each KPI question and make trends, comparisons, target gaps, and unusual changes easy to interpret.
Why it matters
Executives act on what they can read quickly, so chart choice directly affects decisions.
By the end, you will be able to
- Match line, column, combo, and variance charts to KPI questions.
- Design clear axes, labels, and target markers without clutter.
- Show actual versus plan and trend context in one view.
1. 7.1
  Chart selection
  Choose visuals based on comparison, trend, or composition questions.
2. 7.2
  Target lines and bands
  Add benchmarks that clarify whether performance is on track.
3. 7.3
  Variance storytelling
  Explain gaps between actual and goal using concise visuals.
4. 7.4
  Readability checks
  Reduce clutter and enforce consistent number formatting.
Study chapter 7 in detail
08
Chapter 8 · 4 lessons
What-If Analysis
Model scenarios with Goal Seek, data tables, and scenario comparisons to support planning decisions.
Why it matters
Leaders need to understand best case, expected case, and risk case before committing resources.
By the end, you will be able to
- Use Goal Seek to solve for required input values.
- Build one-variable and two-variable data tables for sensitivity checks.
- Compare scenarios with clear assumptions and output deltas.
1. 8.1
  Goal Seek basics
  Back-solve a target metric by changing one driver.
2. 8.2
  Sensitivity tables
  Evaluate output changes across parameter ranges.
3. 8.3
  Scenario manager
  Store and compare assumption sets for planning discussions.
4. 8.4
  Decision framing
  Present assumptions and confidence limits clearly.
Study chapter 8 in detail
09
Chapter 9 · 4 lessons
Power Query
Use Power Query to import, transform, and refresh repeat data pipelines without manual cleanup steps.
Why it matters
Automated data shaping reduces recurring errors and saves analyst time every reporting cycle.
By the end, you will be able to
- Connect to CSV, workbook, and folder sources for recurring imports.
- Apply common transforms such as split, merge, type assign, and unpivot.
- Refresh and document query steps so others can maintain them.
1. 9.1
  Query connections
  Load data from repeat sources with stable connectors.
2. 9.2
  Transform step design
  Chain deterministic cleanup steps in the query editor.
3. 9.3
  Append and merge
  Combine monthly files and reference tables with key-based joins.
4. 9.4
  Refresh operations
  Publish reliable refresh workflows for routine reporting.
Study chapter 9 in detail
10
Chapter 10 · 4 lessons
Dashboard Design and Handoff
Assemble an executive-ready dashboard and hand it off with instructions, controls, and maintenance notes.
Why it matters
A good dashboard is only valuable if decision-makers can trust it and teammates can maintain it after handoff.
By the end, you will be able to
- Design a focused dashboard layout around audience decisions.
- Add interaction controls, refresh notes, and clear metric definitions.
- Package workbook handoff documentation for reliable ownership transfer.
1. 10.1
  Audience-first layout
  Prioritize top decisions and place high-value KPIs first.
2. 10.2
  Interactive controls
  Use slicers and selectors to support guided exploration.
3. 10.3
  Definition layer
  Document metric formulas, filters, and source assumptions.
4. 10.4
  Handoff checklist
  Deliver a maintainable dashboard package with owner notes.
Study chapter 10 in detail

Excel for Business Analysis

Course overview

Every chapter and lesson

Workbook Setup

Formulas and Functions

Lookup Strategies

Data Cleaning

Conditional Formatting

PivotTables

KPI Charts

What-If Analysis

Power Query

Dashboard Design and Handoff

Learn this with an AI teacher that starts from what you already know.