Copilot · Data

Copilot spreadsheet helper

Spreadsheet formulas and steps.

All topics / Copilot prompts

Prompt shell

Replace highlighted brackets, then copy.

In Excel/Sheets, help with [task]. Provide formula, where to place it, and a short example table.
How to use
  • task - replace the bracketed field with your info
Provide (Inputs)
  • Task
  • Tool (Excel/Sheets)
  • Range
  • Constraints
Expected output (Outputs)
  • Formula
  • Placement
  • Example
Tips
  • Use absolute/relative refs correctly.
  • Keep formula readable.
  • Note compatibility (Excel vs Sheets).
Related prompts
More Copilot prompts Ask the encyclopedia