Kuest AI

Study anything, free

Start free

Master Excel 10x faster with AI

Formulas, lookups, PivotTables and charts. Paste your formula or describe your sheet and Kuest helps you see why it returns what it does.

4.87on iOS13,917,000+students already study with Kuest

topics
10
Covers
Microsoft Excel and Google Sheets
Core skills
Formulas, lookups, PivotTables, charts
Leads to
Data analysis, finance, accounting

See how Kuest teaches it

It asks before it tells, so you do the thinking and it sticks.

You: I wrote =B2*C1 in D2 to apply the tax rate in C1, but when I fill it down, D3 and below show 0. Why?
Kuest: Click D3 and read its formula. What do you think Excel changed it to when you filled down?
You: Oh, it says =B3*C2. C2 is empty.
Kuest: Right, both references moved down one row. Which of them should move, and which should stay fixed?
You: B should move, but C1 should stay. So =B2*$C$1?
Kuest: Exactly. The $ locks the column and row. Since only the row moves when you fill down, =B2*C$1 would work too.

References shift when you copy a formula; add $ to lock the part that must stay put.

Students who lock in with Kuest

students
13,917,000+
App Store rating
4.87
countries
100+
  • From a C to an A in chem

    “I stopped copying answers and started actually getting it. My chem grade went from a C to an A in one semester.”

    Junior, Texas
  • 3 hours → 40 minutes

    “My notes turn into a quiz in seconds. What used to take me all night now takes one episode of a show.”

    Sophomore, California
  • Finally ready for the SAT

    “The plan told me exactly what to do each day. I walked in calm for the first time ever.”

    Senior, New York
  • It never lets me skip a step

    “Annoying at first, lifesaver on test day. I could do every problem without it.”

    Freshman, Ohio
  • Better than my tutor

    “It's there at midnight, it's patient, and it costs less than one session with my old tutor.”

    College freshman, Florida
  • My streak is at 94 days

    “The quests are ten minutes. I do them on the bus. Somehow I'm now the one explaining bio to my friends.”

    Junior, Illinois
  • Spanish finally clicked

    “Talking out loud with the tutor fixed my pronunciation faster than a whole year of class.”

    Sophomore, Arizona
  • Found my gaps in one night

    “The gap check showed me I'd never understood moles. Fixed it in 15 minutes.”

    Junior, Georgia
  • Parent here: no more 9pm meltdowns

    “My son gets real help without me pretending I remember calculus, and I can see his progress every week.”

    Parent, Washington

The method

How to study Excel & spreadsheets with Kuest

Excel is learned by doing: build a small sheet, predict what a formula returns, then check. Focus on references and lookups first, since most errors come from them. Short practice with real data you care about, like a budget or class grades, sticks best.

  1. Paste your formulaTutor chat

    Share the formula, what's in the cells it uses and the result you got. Kuest asks what you expected and helps you find the mismatch.

  2. Snap your sheetSnap a photo

    Take a screenshot of the spreadsheet or error and Kuest starts from exactly what you see.

  3. Pick the right chartGraphs

    Kuest graphs your numbers a few ways so you can see why a line chart or a bar chart tells the story better.

  4. Predict the resultQuizzes

    Quizzes show a formula and a few cells and ask what it returns, including what happens when you fill it down.

  5. Remember functions and shortcutsFlashcards

    Spaced flashcards for XLOOKUP, SUMIFS, error codes like #REF! and #VALUE!, and keyboard shortcuts.

  6. Prepare for a certificationStudy plan

    Set a date for a class final or a Microsoft Office Specialist exam and Kuest builds a plan through each skill area.

What you'll cover

Tap a topic to learn it now.

  1. 01Cells, ranges and formulasEnter formulas, use ranges and read the order Excel calculates in.
  2. 02Relative and absolute referencesCopy formulas correctly with $ signs so the right cells stay locked.
  3. 03Core functionsUse SUM, AVERAGE, MIN, MAX, ROUND and COUNT with confidence.
  4. 04Logical functionsBuild decisions with IF, IFS, AND, OR and IFERROR.
  5. 05Conditional sums and countsSummarize data by criteria with SUMIFS, COUNTIFS and AVERAGEIFS.
  6. 06LookupsFind values with XLOOKUP, VLOOKUP and INDEX/MATCH and fix #N/A errors.
  7. 07Text and date functionsClean text with TRIM, LEFT and TEXTJOIN and calculate with dates.
  8. 08Tables, sorting and filteringTurn ranges into tables and sort, filter and remove duplicates.
  9. 09PivotTablesSummarize thousands of rows by category in a few clicks.
  10. 10Charts and dashboardsPick the right chart and build a clear one-page summary.

Try asking

Tap a question and Kuest starts teaching it, step by step.

Helps you prepare for

  • Microsoft Office Specialist: Excel Associate
  • Microsoft Office Specialist: Excel Expert
  • Business and accounting courses
  • Excel skills tests for jobs

A month of Kuest costs less than one hour with a tutor

Same patience, any hour, every subject. Or stay on the free plan for good.

Private tutor

$40–80for one hour

  • Booked days in advance
  • One subject per session
  • Stops when the hour ends

Kuest Plus

$10a month, billed yearly

  • Every subject and exam on this site
  • Any hour, as long as you need
  • Quizzes, flashcards, podcasts and mock exams

Study on any device

Phone, tablet or laptop. Your chats, plans and flashcards come with you.

Questions, answered

Your next study session starts here

Free forever plan. No card needed.

Start free