GPTExcel

Video tutorials

Every GPTExcel tutorial video in one place, from your first analysis to pivot tables, slide decks, formulas and real work like sales, budget and HR analysis.

Short videos recorded in the real app with sample data, most under two minutes. They're all on our YouTube channel too, with captions and chapters.

Getting started

The whole app in under 3 minutes: one sales file, from upload to a shared slide deck.
Your first analysis: drop in a file, ask questions, follow suggestions, and check the Python behind an answer.

More in Getting started and the AI Chat guide.

Excel formulas

Formulas on your real columns, a lookup between sheets, a #N/A fixed, and the formulas written into your file.
A nested IF, VLOOKUP and IFERROR explained, walked through on a real row, checked on every row and rewritten with LET.
A slow workbook diagnosed and rewritten, with all 20,060 values matching the original.
The three lookups compared on a real price list, including the inserted column that silently breaks VLOOKUP.

More in the Formulas guide, How to speed up a slow Excel workbook and XLOOKUP vs VLOOKUP vs INDEX/MATCH.

Pivot tables and slide decks

A pivot table with a slicer from one sentence, then a chart and a timeline connected to it.
One sentence to a deck, with speaker notes, downloaded as PowerPoint or PDF.

More in the Pivot Builder and Slide Deck Builder guides.

Real work, start to finish

Growth, margin, slipping customers and a summary for your manager, from one sales export.
Where the money went, what to cancel, and a draft Q4 budget handed back as a spreadsheet.
Headcount, turnover by department, why one team keeps losing people, and pay within each level.

Each one is written up with every prompt and figure: sales, budget and HR.