Data & Spreadsheets
Sheets to Decisions: Data Analytics with Excel and Google Sheets
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