🔖 Want just the bare basics for Excel?  ·  See the study guide
🔖 BARE BASICS MODE — only the highlighted lessons below are your must-knows
LESSON 1

Your First Formula

Start here — build the habit of thinking in formulas.

1

Learn

0/12
lessons done

Practice

0/72
drills done

Cards

0/30
cards reviewed

Skill Readiness

0%

Read It Aloud — how every lesson works

Every formula is broken down argument by argument into plain language. Once you can say it out loud — in any language — you own it.

=VLOOKUP(A2, products!A:D, 3, FALSE)
A2→the value we're searching for
products!A:D→search in this table (first column gets searched)
3→return the value from the 3rd column of that range
FALSE→exact match only — no close guesses

Other Kits

Every tool interviewers test.

SQL Python Tableau Stats Interview Power BI Associate Data Analyst Simulator Final Exam ← All Kits

Lessons

12 lessons across three units. Each one ends with a short quiz, then drills.

Practice Drills

Six drill types, one per lesson. Mix them up or drill a specific skill.

Pivot Lab

Drag fields from the list into the zone you want. The table updates live — just like the real thing.

Field List

Rows

Columns

Values

Filters

PivotTable Result

Drop at least one Row field and one Value field to build your table.

Flashcards

Tap a card to flip it. Arrow through the deck.

Glossary