Excel + AI: From Basic to Boss Level

A learner invited you

4 lessons · Beginner

Lesson 1 of 4

Past the VLOOKUP Ceiling: XLOOKUP and INDEX-MATCH

Lesson 2 of 4

Structure First: Tables, and the PivotTables They Unlock

Early-stage product — exploratory, no guaranteed results.

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, 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 once you sign in — or generate your own study on any topic.

What you'll learn

  1. 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…
  2. 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…
  3. 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…
  4. 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?

More studies to explore

Or browse all public studies.