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.

Adds last-edited timestamps and a who-changed-what log to a shared Google Sheet or Excel workbook, using built-in history, Apps Script or VBA, and states what each method cannot capture.

Allocates overheads such as rent, IT and admin across departments, products, sites or clients by sensible drivers in a spreadsheet, with checks that allocations reconcile to the cost pools.

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 time log in Excel or Google Sheets by client and project with rates, billable and non-billable time, rounding, unbilled work, retainer burn and an invoice-ready monthly summary.

Builds a business workbook that maps a ledger export to budget lines and shows monthly and year-to-date budget, actual and variance with thresholds flagged, refreshed by pasting each month's export.

Builds a monthly or yearly calendar grid in Excel or Google Sheets driven by a year and month selector, with weekends, holidays and events from a list shown on their dates.

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 sales pipeline tracker in Excel or Google Sheets with deal stages, stage probabilities, a weighted forecast by month, next actions and flags for overdue follow-ups and stale or slipped deals.

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 an employee expense claim form in Excel or Google Sheets with categories, receipt references, mileage, currency conversion, reclaimable sales tax, policy limit flags and approval totals.

Builds a fixed asset register in Excel or Google Sheets with straight-line or reducing-balance depreciation by month, disposals, net book value and a period summary that ties to the ledger.

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 month-by-month staff cost plan in Excel or Google Sheets from start and leave dates, FTE, pay rises, bonuses, employer on-costs and open vacancies, with totals by team and FTE per month.

Builds a reusable invoice template in Excel or Google Sheets - line items, tax by rate, discounts, due date, invoice numbering and a register of issued invoices with paid status.

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.

Builds a staff annual leave tracker in Excel or Google Sheets - pro-rata allowances, carry-over, bookings in days or hours, public holidays, remaining balance and a team calendar view.

Builds a spreadsheet that turns hours, salaries and rates into gross pay, deductions and net pay per employee, using tax and contribution rules you supply, with checks and a pay summary.

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 project budget tracker in Excel or Google Sheets with original budget, approved changes, committed, actual and forecast to complete per cost line, a change log and contingency drawdown.

Builds a spreadsheet that allocates people to projects week by week, showing hours booked against each person's real capacity, overloads, free time and unstaffed project demand.

Builds a search page in Excel or Google Sheets where users type a word or pick dropdowns and a FILTER-based results list updates instantly, without touching or sorting the source data.

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.

Builds a league standings table in Excel or Google Sheets from a results list - played, won, drawn, lost, scores for and against, points and tiebreakers - plus a round-robin fixture list.

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 linked income statement, balance sheet and cash flow model in Excel or Google Sheets that balances every period, driven by revenue, cost, working-capital, capex and financing assumptions.

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.

Builds a ranked top-N list overall or per group that updates automatically and handles ties honestly, using RANK, SORTBY, SORTN, LARGE or FILTER for your Excel or Sheets version.

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 month-on-month, year-on-year, CAGR and percentage-point changes in a spreadsheet, handling zero or negative bases, partial periods and averaged rates without misleading numbers.

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.

Writes running total, month-to-date, year-to-date, fiscal YTD, rolling 12-month and same-period-last-year formulas that stay right when rows are sorted, filtered or months are missing.

Builds spreadsheet formulas for tier and bracket calculations such as tax bands, tiered shipping or volume discounts, whole-band or progressive, from a rate table with boundary tests.

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.

Consolidates monthly files or tabs with the same layout into one table, handling header drift, a source column and new files arriving, using Power Query, VSTACK, array literals or a script.

Compares two lists to show what is in both, only in A and only in B, catching false misses from spaces, case, numbers stored as text, long IDs and wildcard characters.

Finds every added, deleted and changed row or cell between two versions of the same sheet, keyed by ID rather than row position, and produces a change summary someone can review.

Connects Excel or Google Sheets to a SQL database or warehouse with Power Query, ODBC, Connected Sheets or Apps Script, using a read-only query, a refresh plan and safe credentials.

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.

Converts plain data ranges in a workbook to Excel Tables and rewrites the formulas, lookups, charts, pivots and validation that use them to structured references, so ranges grow on their own.

Turns comma-separated checkbox answers from a form export into per-option counts and percentages with the right denominator, plus cross-tabs by group, in Excel or Google Sheets.

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.

Draws random winners or an audit sample without repeats in Excel or Google Sheets, optionally weighted or stratified, then freezes and documents the draw so it cannot change on recalculation.

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.

Explains a pasted Excel or Google Sheets formula piece by piece in plain words, evaluates it on a worked example row, and lists the inputs where it silently breaks or returns the wrong answer.

Splits and extracts parts of text cells (names, emails, codes, numbers, dates) with TEXTSPLIT, REGEXEXTRACT or LEFT/FIND, tested against your messiest sample rows.

Finds and repairs broken links to other workbooks,

Fixes and prevents CSV import damage in Excel or Google Sheets - lost leading zeros, long IDs in scientific notation, swapped day and month, broken accents and wrong delimiters - at the cause.

Formats a working Excel or Google Sheets file for other readers - number formats, alignment, freeze panes, input versus formula colours, table styles and an index tab - without changing values.

Groups numbers such as ages, prices, sizes or days overdue into bands with a band table and formulas or pivot grouping, clear boundary rules, honest labels and a frequency table.

Pulls tables, lists, prices or exchange rates from web pages into a sheet with IMPORTHTML, IMPORTXML, GOOGLEFINANCE or Excel Get Data from Web, with refresh limits and breakage checks.

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 a Google Form responses spreadsheet so lookups, calculated columns and a summary tab keep working as new responses arrive, without editing or sorting the raw responses tab.

Pulls data from a REST API into Google Sheets with Apps Script or into Excel with Power Query, keeping the API key out of the sheet, paging through results and refreshing on a schedule.

Walks you through recovering an overwritten, unsaved, deleted or corrupted Excel or Google Sheets file using version history, AutoRecover, backups and repair, in the order most likely to work.

Unpivots a crosstab with months or products across the columns into a flat table ready for pivots and charts, and back again, by formula or Power Query, with row-count checks.

Checks an Excel or Google Sheets file before it goes outside the team for hidden sheets and rows, metadata, comments, external links, version history and pivot caches that still hold data.

Sets up scheduled email reminders for due or expiring items listed in Google Sheets or Excel, marking each reminder as sent so nobody is emailed twice, with quota limits and a dry run.

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.

Sets up a sheet to print or save as PDF cleanly in Excel or Google Sheets - print area, repeated header rows, fit to width, page breaks, orientation, and headers and footers with page numbers.

Rewrites a working but unreadable nested IF or copy-pasted formula into LET, IFS, SWITCH or a lookup table, with test rows proving the new version returns identical results.

Sets up Excel Solver, or a solver add-on in Google Sheets, for allocation, product mix, staffing or shipping problems, with objective, constraints and method, and explains failed or odd results.

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.

Splits one sheet into separate files or tabs per region, client or manager with VBA, Apps Script or formulas, keeping formats, leaking no other group's data, with an optional email-out step.

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.

Builds a live category-by-month summary from a transaction list with SUMIFS or dynamic arrays that keeps working as rows are added, with a check that the summary adds back to the raw total.

Converts formulas between English and localised Excel or Google Sheets function names, argument separators, decimal commas and format codes so they paste and work.

Turns a shared sheet into a simple no-code app with forms, lists and permissions using AppSheet, Power Apps or a form, after fixing the data structure the app needs.

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 custom number format codes for K and M abbreviations, negatives in brackets, leading zeros, durations over 24 hours, units and conditional colours, with what each code displays.

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 an Office Script in TypeScript for Excel on the web or a shared workbook where VBA cannot run, optionally called from Power Automate on a schedule, with a test plan and the platform's limits.

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 Google Sheets QUERY formula with select, where, group by, pivot and label clauses for your range, handling mixed-type columns, date literals and cell-driven filters.

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.