Log in Join for free

Topics

AI prompts for Excel formulas and spreadsheet work

Excel prompt templates for formulas, lookups, data cleaning, workbook design, analysis, charts, validation, and troubleshooting

Spreadsheet outputs can look correct while referencing the wrong field, hiding missing matches, or breaking on blanks. These recipes start from the real workbook layout and require representative tests before a result is trusted.

How to use this collection

Provide exact sheet names, headers, cell references, data types, and representative rows.
Test normal, blank, duplicate, unmatched, and error cases before filling down.

Choose a recipe

40 recipes

Spreadsheet insights

Excel & spreadsheets 7 min setup

Compare segment performance in Excel

Compare groups using consistent metrics, denominators, coverage, and minimum sample rules

Spreadsheet insights

Excel & spreadsheets 8 min setup

Combine similar Excel worksheets safely

Append recurring sheets after auditing schema drift, provenance, duplicates, types, and totals

Spreadsheet insights

Excel & spreadsheets 5 min setup

Combine Excel columns with explicit blank rules

Join fields without stray separators, lost zeroes, collapsed distinctions, or silently changed missing values

Spreadsheet insights

Excel & spreadsheets 7 min setup

Choose mean, median, or quantiles for a spreadsheet metric

Match the summary statistic to the decision, metric scale, distribution, weighting, and tail risk

Spreadsheet insights

Excel & spreadsheets 6 min setup

Choose between VLOOKUP, XLOOKUP, and INDEX/MATCH

Select a lookup pattern from workbook compatibility, match behavior, layout, maintainability, and data risk

Spreadsheet insights

Excel & spreadsheets 6 min setup

Clean Excel dates and calculate a duration

Normalize mixed date inputs before calculating calendar or working time

Spreadsheet insights

Excel & spreadsheets 5 min setup

Choose the right chart for spreadsheet data

Match the comparison task and data shape to a chart without distorting scale or uncertainty

Spreadsheet insights

Excel & spreadsheets 7 min setup

Calculate period and cumulative change in Excel

Compare complete periods with explicit baselines, denominators, and missing-period rules

Spreadsheet insights

Excel & spreadsheets 5 min setup

Build an XLOOKUP between Excel sheets

Join two sheets with an explicit key, match rule, and no-match behavior

Spreadsheet insights

Excel & spreadsheets 5 min setup

Build an Excel conditional summary formula

Create a SUMIFS, COUNTIFS, or AVERAGEIFS formula from explicit criteria

Spreadsheet insights

Excel & spreadsheets 5 min setup

Build a multi-condition Excel IF formula

Turn ordered business rules into a formula with explicit precedence and edge cases

Spreadsheet insights

Excel & spreadsheets 7 min setup

Audit Excel headers, field definitions, and data types

Compare a workbook with its intended schema before import, analysis, or automation