Column Harbor
COLUMN HARBOR / EXCEL ACADEMY

Learn the sheet.
Understand the work.

A practical path from your first cell to a repeatable report. Learn the idea, work through an example, then check your answer.

24 lessons6 modulesFree · In English
Start learning

Find your way around a workbook, cells, and ranges

0 of 24 lessons marked completeSaved in this browser. Completion is your own checklist, not a qualification.
THE CURRICULUM

One useful skill at a time.

Follow the order, or find the lesson you need today.

24 lessons
01 / Beginner

Get comfortable in Excel

Understand the grid, enter reliable data, format values and find the rows you need.

  1. 01Find your way around a workbook, cells, and rangesAbout 15 min · Example + practice
  2. 02Enter and correct data without changing its meaningAbout 15 min · Example + practice
  3. 03Format numbers without confusing display and valueAbout 15 min · Example + practice
  4. 04Sort complete records and filter a focused viewAbout 15 min · Example + practice
02 / Beginner

Make formulas work for you

Build calculations you can explain, copy safely and check against a known answer.

  1. 05Build your first formulas from cell referencesAbout 15 min · Example + practice
  2. 06Copy formulas while keeping shared inputs fixedAbout 20 min · Example + practice
  3. 07Choose the right total, average, and countAbout 20 min · Example + practice
  4. 08Turn clear rules into IF, AND, and OR formulasAbout 20 min · Example + practice
03 / Intermediate

Build dependable worksheets

Give your data a structure, control inputs and clean text and dates deliberately.

  1. 09Turn an order range into a growing Excel tableAbout 18 min · Example + practice
  2. 10Guide data entry with dropdowns and number limitsAbout 18 min · Example + practice
  3. 11Clean hidden spaces without losing the original textAbout 16 min · Example + practice
  4. 12Build dates and calculate elapsed hours safelyAbout 20 min · Example + practice
04 / Intermediate

Connect and summarize data

Answer questions across rows and sheets without losing sight of missing and duplicate keys.

  1. 13Answer the same business question with a sum and a countAbout 18 min · Example + practice
  2. 14Look up a product with an explicit exact matchAbout 18 min · Example + practice
  3. 15Build an exact lookup with INDEX and MATCHAbout 20 min · Example + practice
  4. 16Create a filtered report that spills into empty cellsAbout 22 min · Example + practice
05 / Advanced

Turn data into decisions

Build summaries and charts, highlight exceptions and explore a controlled what-if question.

  1. 17Build a PivotTable and prove that its totals are rightAbout 20 min · Example + practice
  2. 18Create a chart that answers one clear questionAbout 15 min · Example + practice
  3. 19Highlight rows with a rule you can explainAbout 20 min · Example + practice
  4. 20Use Goal Seek, then check whether the answer makes senseAbout 20 min · Example + practice
06 / Advanced

Make the work repeatable

Import carefully, transform with Power Query and assemble a monthly report you can reconcile.

  1. 21Import CSV without damaging identifiersAbout 20 min · Example + practice
  2. 22Turn one CSV import into a repeatable queryAbout 25 min · Example + practice
  3. 23Append orders, merge customer names, and check the row countAbout 30 min · Example + practice
  4. 24Build a monthly report with a repeatable import and a reconciliationAbout 40 min · Example + practice

Bring a blank workbook and a little curiosity.

The main path uses English formula names and Windows desktop menu labels. Each lesson notes its version requirements. Modern lookup and array functions need a supported Excel version; Power Query and What-If menus vary by platform.

Examples use synthetic data. Practice in a separate .xlsx workbook, keep original files, and compare your result with the worked answer. This course covers core Excel and advanced data workflows; VBA, DAX and certification training are outside this edition.