Which tool fits your problem?
Each tool on this site handles one spreadsheet task. None of them needs an account, and the interactive tools work on what you type or select in the page rather than on an uploaded workbook. The short guide below matches common situations to the right tool.
If a cell shows a code such as #N/A, #VALUE! or #SPILL!, start with the Error Decoder. It explains what the code means and the order in which to check the likely causes. If the formula itself is the problem, because it is long, nested, or written by someone else, paste it into the Formula Explainer to see each part described in plain English and the order Excel evaluates it.
If you are about to write a lookup, the Lookup Function Chooser asks about your Excel version and your data, then recommends VLOOKUP, XLOOKUP, INDEX/MATCH, HLOOKUP or FILTER. This matters when a workbook will be opened in Excel 2019 or earlier, where XLOOKUP and FILTER are not available.
For summaries, the Pivot Table Planner helps you decide which fields go in Rows, Columns, Values and Filters before you build the PivotTable, and warns about layouts that will not work. For highlighting, the Conditional Formatting Builder writes rule formulas with the dollar signs in the right places, including rules that colour an entire row.
When moving between programs, the Formula Converter rewrites the functions that differ between Excel and Google Sheets and tells you when there is no direct equivalent.
To practise on a real file, download the sample workbook. It shows inputs, data, calculations and a dashboard on separate sheets, so you can try each tool on formulas that already work.
About each tool
Formula Explainer
Paste a formula you inherited or found online and the Formula Explainer splits it into its parts: each function, its arguments, the cell references, and the order Excel evaluates them. Use it when a nested IF, a lookup wrapped in IFERROR, or a long SUMIFS is hard to read at a glance.
Excel Error Decoder
Type or select an error such as #N/A, #VALUE!, #REF!, #DIV/0! or #SPILL! and the Error Decoder explains what Excel is reporting, the usual causes, and the checks to run in order. Use it when a cell shows an error code and you are not sure where to start.
Lookup Function Chooser
Answer six yes-or-no questions about your Excel version and your data, and the Lookup Function Chooser recommends VLOOKUP, XLOOKUP, INDEX/MATCH, HLOOKUP or FILTER with a formula you can adapt. Use it before writing a lookup, especially when the workbook will be opened in an older version of Excel.
Pivot Table Planner
List the columns in your data, mark each as text, number or date, and assign it to Rows, Columns, Values or Filters. The Pivot Table Planner returns the build steps and warns about layouts that will not work, such as summing a text field. Use it before you insert a PivotTable on a dataset you have not summarised before.
Conditional Formatting Builder
Pick a condition such as greater than, contains text, duplicate, date in the past, weekend, or highlight the whole row, and the Conditional Formatting Builder writes the formula for Excel's Use a formula to determine which cells to format option. Use it when the built-in presets do not cover your rule.
Excel and Google Sheets Formula Converter
Paste a formula from Excel or Google Sheets and the converter rewrites the functions that differ between them, such as SPLIT and TEXTSPLIT, JOIN and TEXTJOIN, ARRAYFORMULA, and regional semicolon separators. It also states when there is no direct equivalent, as with QUERY. Use it when moving a workbook between the two programs.