Jarvis AI logoJarvis AI
Get Started

Skills & Professional

Google Sheets tutoring with a curriculum-aware AI tutor

Google Sheets tutoring — formulas, QUERY, ARRAYFORMULA, Apps Script and dashboards.

Try AI Free — 3-day trial View pricing

Try Jarvis on a real Google Sheets question

Tap a question and get a full step-by-step answer — free, no card, 3-day Premium trial included.

About Google Sheets

Microsoft Excel is the world's most widely used business tool — from finance and consulting to marketing analytics and operations. Jarvis AI teaches Excel as a working analyst would: every answer includes a realistic sample dataset, the exact formula (with cell references), a step-by-step breakdown of how it works, common pitfalls and the best-practice alternative. Coverage spans everything from beginner formulas (SUM, AVERAGE, IF) to advanced modelling (XLOOKUP, INDEX-MATCH, dynamic arrays, LET, LAMBDA), pivot tables and Power Query, dashboards and charts, macros and VBA, and full three-statement financial models used by investment banks and corporates.

Subjects & topics covered

Formulas & Functions
  • Math & logic (IF, IFS, SUMIF, COUNTIF)
  • Text (LEFT, RIGHT, MID, TEXT, TEXTSPLIT)
  • Date & time
  • Lookup (XLOOKUP, VLOOKUP, INDEX-MATCH)
  • Dynamic arrays (FILTER, SORT, UNIQUE, SEQUENCE)
  • LET & LAMBDA
Key formulas: =XLOOKUP(lookup, array, return, if_not_found) · =INDEX(range, MATCH(lookup, range, 0)) · =SUMIFS(sum_range, criteria_range1, criteria1, …)
Pivot Tables & Analysis
  • Creating pivots
  • Calculated fields
  • Slicers & timelines
  • GETPIVOTDATA
  • Power Pivot & DAX basics
Power Query
  • Importing data
  • Cleaning & transforming
  • Merging & appending queries
  • Refreshing automatically
Charts & Dashboards
  • Chart selection
  • Combo charts
  • Sparklines
  • Conditional formatting
  • Interactive dashboards with slicers
Macros & VBA
  • Recording macros
  • VBA basics
  • Loops & conditionals
  • UserForms
  • Automating reports
Financial Modelling
  • Three-statement models
  • DCF valuation
  • Scenario & sensitivity analysis
  • LBO basics
  • Best practices: colour coding, error checks

Everything you need to prepare for Google Sheets

AI Tutor

Step-by-step, curriculum-aware explanations for every topic.

Past Papers

Authentic past papers with board-accurate solutions.

Mock Exams

Timed, exam-style mocks that mirror the real thing.

Mark Schemes

Marking that follows the official command words and rubric.

Study Planner

Personalised revision schedule counting down to your exam.

Flashcards

Smart spaced-repetition flashcards for every subject.

Exam structure

Excel is a skills-based subject — Jarvis measures mastery by task completion rather than exam papers, and can prepare you for Microsoft Office Specialist (MOS) Excel Associate and Excel Expert certification exams.

Grading & scoring

Each Excel task is scored against: correctness (does it produce the right result?), robustness (does it handle edge cases?), efficiency (is it the best formula?) and clarity (are the references and structure clean?).

Exam strategy & time management

  • 1Prefer XLOOKUP over VLOOKUP — it's simpler, safer and searches left-to-right or right-to-left.
  • 2Use named ranges and Excel Tables so formulas remain readable as data grows.
  • 3Break long formulas into helper columns first; combine only after you're sure each step is correct.
  • 4Colour-code inputs (blue), formulas (black) and links (green) in financial models — the banking standard.
  • 5Learn keyboard shortcuts — Ctrl+Shift+L (filter), Ctrl+T (table), F4 (absolute references) will save hours.

Common mistakes to avoid

  • ✕Using VLOOKUP with a hard-coded column index — breaks when columns move. Use XLOOKUP or INDEX-MATCH.
  • ✕Forgetting absolute references ($) when copying formulas down or across.
  • ✕Building giant nested IF statements instead of using IFS, SWITCH or a lookup table.
  • ✕Merging cells — it breaks sorting, filtering and pivots. Use 'Center Across Selection' instead.
  • ✕Storing data in charts (formatted tables) instead of clean tabular data with one row per record.

Google Sheets FAQ

Does Jarvis explain formulas step by step?

Yes — every formula answer includes the exact formula, a sample dataset, a step-by-step breakdown, common pitfalls, and the best-practice alternative.

Can Jarvis help me build a financial model?

Yes. Jarvis coaches full three-statement models, DCF valuations and scenario analysis, following investment-banking colour-coding and error-check conventions.

Does Jarvis cover Power Query and Power Pivot?

Yes — Power Query for data cleaning and Power Pivot / DAX for advanced analytics are fully supported.

Can Jarvis write VBA macros?

Yes. Jarvis writes commented VBA, explains each block, and highlights when a formula-based solution would be simpler.

Does this work for Google Sheets too?

Yes — Google Sheets is fully supported, including QUERY, ARRAYFORMULA and Apps Script.

Related skills & professional

Or browse all supported curricula.

Ready to ace your Google Sheets exams?

Start free with daily AI tutoring, or upgrade for unlimited practice, mock exams and predicted grades.

Try AI Free — 3-day trial Compare plans