Spreadsheets

Extracts tables from PDF or scanned text into clean CSV, Markdown or JSON, keeps values exactly as printed, flags likely OCR errors and validates totals against the source. Use before analysis.

Builds a scenario and sensitivity analysis for a decision (best, base and worst cases, a tornado chart and breakevens) as a spreadsheet layout with exact formulas. Use before committing to a plan.

Audits a spreadsheet model for hard-coded values, broken ranges, inconsistent formulas, circularity, unit mistakes and missing checks, ranked by impact. Use before relying on someone else's sheet.

Builds a loan amortisation schedule in a spreadsheet with payment formulas, extra-payment scenarios and total interest, explaining each column. Use to see how a loan or mortgage pays down.

Builds a sales commission calculator with tiers, accelerators, caps and clawbacks from a written plan, with test cases that prove the formulas. Use when turning a comp plan into a spreadsheet.

Builds a formatted Excel workbook from data with a script, with live-formula summaries, pivot-style tables, charts and a documentation tab, and checks it recalculates. Use for reusable Excel reports.

Builds a Gantt timeline in Excel or Google Sheets with task, start and duration columns, dependency formulas, conditional-format bars and a today marker. Use to plan a project without a PM tool.

Builds a teacher's gradebook with weighted categories, dropped lowest scores, late penalties and letter grades, with the exact formulas. Use when setting up a course gradebook in a spreadsheet.

Builds a job quote calculator for a trade or service business with materials, labour, markup, overheads and tax, producing a customer-ready total. Use to price jobs consistently and protect margin.

Designs a pivot table that answers one specific business question and gives exact click-by-click setup steps for Excel or Google Sheets. Use when you have a flat table and a question about it.

Builds a working dashboard inside Excel or Google Sheets with a data tab, summary formulas, charts, slicers or dropdowns and refresh steps. Use when the team lives in spreadsheets, not a BI tool.

Gives exact click-by-click steps to lay out data for, build and format a chart in Excel or Google Sheets that carries one message. Use when you know the point and need the chart built right.

Builds a timesheet with hours worked, breaks, overtime rules and shifts that cross midnight, with formulas that handle time arithmetic correctly. Use when tracking hours and pay in a spreadsheet.

Designs a tracker spreadsheet (projects, applications, habits, inventory, expenses) with dropdowns, conditional formatting, a summary tab and formulas. Use to organise recurring work in a sheet.

Writes date formulas for working days with holidays, ages, due dates, fiscal periods and week numbers in Excel or Google Sheets, with examples for each. Use when date arithmetic comes out wrong.

Calculates ROI, payback and NPV for a proposed project or investment with explicit assumptions, scenarios and a spreadsheet layout to reproduce it. Use when building or checking a business case.

Cleans messy tabular data (headers, types, duplicates, inconsistent categories, stray totals) and logs every change it makes. Use before analysing an export or a hand-maintained sheet.

Converts tabular or nested data between CSV, TSV, JSON, Markdown and XML, preserving every value exactly and flagging ambiguous fields. Use when data must move between tools without silent changes.

Converts a workbook's formulas, features and VBA macros between Excel and Google Sheets with Apps Script, flagging anything without an equivalent. Use before migrating a working file.

Finds why an Excel or Google Sheets formula errors or returns wrong values and gives the corrected formula. Use for #N/A, #VALUE!, wrong totals, or results that break when copied down.

Designs a spreadsheet model for a business calculation with separate inputs, calculations, outputs, checks and named ranges. Use before building a pricing, capacity or unit-economics model.

Simulates a spreadsheet grid where the learner types values and formulas into cells, recalculates dependents, shows errors such as

Explains an inherited workbook sheet by sheet, how data flows, what the key formulas do in plain words, where it is fragile, and how to use it. Use when you take over someone else's spreadsheet.

Builds a personalised spreadsheet learning plan from the learner's current level toward a job goal, with self-made practice datasets, graded tasks and checks. Use to get better at Excel or Sheets.

Sets up data validation, dependent dropdowns, input messages and protected ranges so a shared sheet stays clean, with step-by-step instructions. Use before handing a sheet to other people.

Diagnoses why an Excel or Google Sheets workbook is slow (volatile functions, full-column references, excess formatting, lookups) and gives fixes in order of impact. Use when a file lags or freezes.

Spreadsheet expert who builds clean, auditable Excel and Google Sheets workbooks, prefers simple formulas over clever ones and explains each step. Use as a standing spreadsheet helper.

Rules for building or editing spreadsheets, covering separate inputs, calculations and outputs, no hard-coded numbers, consistent units, checks and a notes tab. Load for spreadsheet work.

Writes conditional formatting rules with exact custom formulas to highlight overdue items, duplicates, thresholds or whole rows in Excel or Google Sheets. Use when presets fall short.

Writes a reusable Excel LAMBDA or named function for a repeated calculation, with parameters, LET for readability, examples and edge cases. Use when the same long formula is copied across a workbook.

Writes Power Query (M) steps that import, clean, combine and reshape data with refresh-safe logic, explaining each step. Use in Excel or Power BI to automate data prep you redo by hand.

Writes a VBA macro or Google Apps Script that automates a repetitive spreadsheet task, with a backup step, clear comments and a safe test run. Use when you repeat the same clicks every week.

Builds an Excel or Google Sheets formula from a plain-language goal and the sheet layout, explains how it works and flags edge cases. Use when you know the result you want but not the formula.