Early-stage product — exploratory, no guaranteed results.
A learnerinvited you
Excel + AI: From Basic to Boss Level
You'll know more than 71% on this topic
Lesson breakdown
Why VLOOKUP is where most self-taught users stop (column-index fragility, left-lookup blindness, silent breakage), and the two lookups that replace it. Ends with rewriting a VLOOKUP in your own file and explaining what changed. The free first lesson.
Structured tables and structured references, plus the layout rules (one row per record, no merged cells) that make everything downstream work. Then PivotTables on top of that structure: rows vs. columns vs. values vs. filters, and the mistakes that produce confidently wrong numbers.
Importing and reshaping messy data as a recorded step list, so next month’s file cleans itself with one refresh instead of an hour of manual repair. The biggest unlock in modern Excel and the one most daily users have never opened.
Both directions: describe your goal and your data’s shape to get a formula, then read it back line by line; and hand AI a broken or inherited formula to find what is actually causing a #REF! or a quietly wrong number. The course’s hard rule closes it out: never paste a formula you can’t explain.
About this study
“Excel + AI: From Basic to Boss Level” is a free, 4-lesson study on Excel from basic to advanced, with AI as your formula partner: XLOOKUP and INDEX-MATCH, structured tables, PivotTables, and repeatable data cleanup with Power Query at Intermediate level, created with soclever, a personal AI teacher. Each lesson takes a few minutes and ends with a check-in question; finish the curriculum and you can take a certificate test to earn a diploma. Starting is free and needs no account — or generate your own study on any topic.
What you'll learn
Past the VLOOKUP Ceiling: XLOOKUP and INDEX-MATCH. VLOOKUP breaks for a reason you can name: it finds your answer by counting columns, so its third argument is a number, not a meaning. Insert a column anywhere in that range and…
Structure First: Tables, and the PivotTables They Unlock. A PivotTable that reports confidently wrong numbers is almost always sitting on badly shaped data rather than a broken PivotTable. The shape that works is boring and strict: one…
Power Query: Clean It Once, Refresh It Forever. Power Query records your cleanup as an ordered list of steps and replays it on command, which turns an hour of monthly repair into a single refresh. Every fix you make is captured…
AI as Your Formula Partner (and the Rule That Keeps You Safe). AI returns a plausible formula from a vague description and a correct one from a precise description, and the whole difference is what you say about the shape of your data.…
Questions this study answers
Why can a VLOOKUP keep returning results without any error after someone inserts a column, and what specifically does XLOOKUP change about that?
What does a PivotTable actually do to your rows, and why does one stray piece of text in a numeric column change the answer it gives you?
Why does recording cleanup as a list of steps make a renamed source column safer to deal with than the same cleanup done by hand?
What do you have to tell an AI about your file before its formula is likely to work on the first try, and why does that matter more than describing the goal?
