hermes
84 entries · 82 prompts, 1 personas, 1 rules

Spreadsheets

Formulas, pivot tables, cleaning and modelling in Excel or Google Sheets.

Start here 1

The general, start-from-zero entry for a need in this category: it works from a blank start, asks for what it needs and hands off to the specific entries. Example: Plan a trip.

Search and filter in Spreadsheets
  • Write a spreadsheet formula

    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.

Specific 78

One situation, audience, tool or format inside the category. Example: Plan a road trip with children.

  • Clean a messy spreadsheet

    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.

  • Convert data between formats

    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.

  • Spreadsheet expert

    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.

  • Build a pivot analysis

    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.

  • Build a tracker 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.

  • Debug a spreadsheet formula

    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.

  • Explain an inherited spreadsheet

    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.

  • Plan your spreadsheet learning

    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.

  • Write a spreadsheet automation

    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.

  • Extract tables from a PDF

    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.

  • Run a what-if 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.

  • Build a chart in a spreadsheet

    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.

  • Spreadsheet modelling rules

    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.

  • Build a timesheet calculator

    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.

  • Explain a spreadsheet formula

    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.

  • Group values into bands

    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.

  • Recover lost spreadsheet work

    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.

  • Summarise transactions by month

    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.

  • Write conditional formatting rules

    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.

  • Audit a spreadsheet model

    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.

  • Build a spreadsheet dashboard

    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.

  • Design a spreadsheet model

    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.

  • Build a loan amortisation schedule
    PromptSpreadsheetsMoney · safety checks

    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.

  • Build a job quote calculator

    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.

  • Write date and workday formulas

    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.

  • Fix a garbled CSV import

    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.

  • Translate a formula between spreadsheet languages

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

  • Write a custom number format

    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.

  • Build a sales commission calculator

    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.

  • Calculate project ROI, payback and NPV

    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.

  • Format a spreadsheet so others can read it

    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.

  • Set up a Google Form responses sheet

    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.

  • Set up a spreadsheet to print or export to PDF

    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.

  • Build a billable hours tracker

    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.

  • Build a payroll calculator spreadsheet
    PromptSpreadsheetsMoney · safety checks

    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.

  • Build a search and filter sheet

    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.

  • Build a sports league table spreadsheet

    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.

  • Calculate tiered and banded rates

    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.

  • Compare two lists in a spreadsheet

    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.

  • Practise formulas in a simulated spreadsheet

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

  • Import web data into a spreadsheet

    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.

  • Pull API data into a spreadsheet

    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.

  • Sanitise a workbook before sharing it

    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.

  • Simplify a long nested formula

    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.

  • Write a Google Sheets QUERY formula

    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.

  • Write Power Query (M) steps

    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.

  • Build a top-N ranking

    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.

  • Calculate growth rates correctly

    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.

  • Count multi-select survey answers

    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.

  • Build a Gantt chart in a spreadsheet

    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.

Showing 50 of 78. See them all in search

Advanced 5

Expert or deep work that assumes the user can judge expert output. Example: Plan croissant lamination.

  • Build a headcount cost plan
    PromptSpreadsheetsMoney · safety checks

    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.

  • Build a linked three-statement model
    PromptSpreadsheetsMoney · safety checks

    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.

  • Write a reusable LAMBDA function

    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.

  • Allocate shared costs across departments or products

    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.

  • Solve an optimisation problem with Excel Solver

    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.