Data & Spreadsheets

Sheets to Decisions: Data Analytics with Excel and Google Sheets

Beginner · 7 modules · 32 lessons · about 10 hours

Ready now. The full course is finished and available to members inside the portal.

From messy raw data to clean tables, correct formulas, pivot tables, honest charts, and a dashboard that supports a real decision. Every lesson works in both Excel and Google Sheets and carries an exercise with a full worked solution.

Members get this course included in membership ($19/month or $190/year). It is also sold on its own for $149.

Get this course with membership

Full syllabus

Module 1 — Start Right

  • What a spreadsheet really is
  • Enter data the right way
  • Move, select, and fill without fear
  • Format the display, never the value

Module 2 — Clean the Data

  • The safe cleaning pattern
  • Find and remove duplicates
  • Fix text — spaces, case, and split values
  • Fix dates and missing values
  • Numbers stored as text, and the ISNUMBER audit

Module 3 — Core Formulas That Must Be Right

  • Your first calculated column — net revenue
  • SUM, AVERAGE, COUNT, COUNTA, MIN, MAX
  • SUMIF and COUNTIF — totals with one condition
  • Absolute references — the $ that stops movement
  • Dates as numbers — month totals

Module 4 — Logic and Lookups

  • IF — make the sheet decide
  • SUMIFS and COUNTIFS — two or more conditions
  • VLOOKUP and XLOOKUP — bring data across tables
  • Errors — read them, trap them, fix the cause

Module 5 — Pivot Tables: Summaries in Minutes

  • Your first pivot table
  • Two dimensions — rows and columns
  • Show values as percents, ranks, and running totals
  • Filters, slicers, and clean pivot habits

Module 6 — Honest Charts

  • Pick the right chart
  • Build a clean column chart
  • The honesty rules — axes, scales, and labels
  • Line charts and trend claims

Module 7 — The Dashboard and the Decision

  • Plan the dashboard before you build it
  • Build the dashboard sheet
  • Check the work — the audit pass
  • Present the decision
  • Capstone — the full Northlight analysis
  • Final check and your next steps

The SkillWorkbench course format

Every course on SkillWorkbench follows one format, built to be easy to follow:

Self-paced throughout: no schedule, no live sessions, nothing expires while your membership is active.

Reviews

There are no reviews yet, because SkillWorkbench is new. We will not print invented praise. When members leave reviews, they will appear here in their own words.