StepGleam logoStepGleam
Browse
Excel shelf

Excel guides.

Clean, calculate, and ship better spreadsheets.

3 guides
Excel clay illustration

Guides

CategoryAllExcelCoding
LevelAll levelsBeginnerIntermediateAdvanced
ToolAny toolExcel (Microsoft 365)Copilot in ExcelClaude CodeOpenAI API or Claude APIPython + openpyxl
Sort
NewestMost reliable
3 of 3 guides
Illustration for Clean a messy workbook: have Copilot flag issues, then decide yourselfExcel
ExcelBeginner25 min

Clean a messy workbook: have Copilot flag issues, then decide yourself

Use Copilot as an auditor rather than an autopilot. Ask it to flag anything that needs manual review on its own sheet, then fix the data with Excel features you control.

Illustration for Write complex Excel formulas with Copilot, then prove they workExcel
ExcelIntermediate30 min

Write complex Excel formulas with Copilot, then prove they work

How r/excel users actually use Copilot for formulas: describe each field, take the draft as a starting point, test it on awkward rows, and check every reference before filling down.

Illustration for Automate a recurring Excel report: deterministic Python, AI only for the fuzzy partsExcel
ExcelAdvanced90 min

Automate a recurring Excel report: deterministic Python, AI only for the fuzzy parts

The pattern practitioners recommend on r/AI_Agents and r/automation: scripts for ingest, transform and validate, an OpenAI or Claude API call only for fields that need interpretation, and a hard stop when totals don't reconcile.