Tech & Data · 18 prompts

The Spreadsheet Wizard

Formulas, dashboards and clean data without the headache.

18 prompts for Excel and Google Sheets users: writing and explaining formulas, cleaning messy data, pivot tables, charts, dashboards, templates and simple automations. For office workers, freelancers and small business owners.

What's inside

Every prompt in the PDF, listed by section.

Formulas

  1. 01Plain-English formula
  2. 02Explain this formula
  3. 03Lookup helper
  4. 04Conditional totals
  5. 05Fix my error

Clean data

  1. 06Clean messy data
  2. 07Remove duplicates smartly
  3. 08Data validation

Analyse

  1. 09Pivot table plan
  2. 10Chart choice
  3. 11Quick insight

Build

  1. 12Dashboard layout
  2. 13Template builder
  3. 14Conditional formatting

Automate

  1. 15Google Apps Script / macro
  2. 16Import and refresh
  3. 17Spreadsheet audit
  4. 18Teach me one function

Sample prompts

Three of the 18, so you can see how specific they are. The PDF has the rest, plus a short introduction.

Formulas

Plain-English formula

In [Excel/Google Sheets], my data has columns [headers]. Write a formula that [goal]. Explain how it works and how to copy it down.

Formulas

Explain this formula

Explain this formula step by step and suggest a simpler version if one exists: [formula].

Formulas

Lookup helper

I want to pull [value] from sheet [name] where [match condition]. Give me an XLOOKUP (or INDEX/MATCH) solution and handle missing matches.

Related packs

Tech & DataThe Developer's Copilot Pack18 prompts · $24Tech & DataThe Research Assistant15 prompts · Coming soonTech & DataThe No-Code Automation Assistant17 prompts · Coming soon