Skip to content
Tutorials Center
My learning

Topics

Google Sheets Tutorial

Learn Google Sheets step by step: 29 lessons in 7 chapters with examples, quizzes, diagrams and projects.

Start learning →

of lessons completed

Getting Started

  1. 1 What Is Google Sheets? Learn what Google Sheets is, how a spreadsheet is built from cells, rows, columns and tabs, how files live in Drive, and how Sheets compares with Excel.
  2. 2 A Tour of the Interface Tour the Google Sheets screen: menus, toolbar, formula bar, name box, sheet tabs, zoom and frozen rows, with stand-ins for ranges and freezing.
  3. 3 Entering and Editing Data Type, edit and autofill data in Google Sheets, learn how Sheets decides whether an entry is text, a number or a date, and fix surprises quickly.
  4. 4 Formatting Cells Format cells in Google Sheets: number, currency, percent and date formats, fonts, colors, borders, alignment, wrapping and merging, and why formats don't change values.

Formulas and Functions

  1. 5 Your First Formulas Write your first Google Sheets formulas: the equals sign, operators, order of operations, cell references and the first error messages you will meet.
  2. 6 Relative, Absolute and Mixed References Understand relative, absolute and mixed references in Google Sheets, what happens when you copy a formula, plus named ranges and references to other sheets.
  3. 7 SUM, AVERAGE, MIN, MAX and COUNT Summarize ranges in Google Sheets with SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTBLANK and the ROUND family, and learn what each one ignores.
  4. 8 Working with Text Clean and reshape text in Google Sheets with LEFT, RIGHT, MID, LEN, TRIM, UPPER, PROPER, CONCAT, TEXTJOIN, SUBSTITUTE and SPLIT, with live stand-ins.
  5. 9 IF, AND, OR and IFS Make Google Sheets decide with IF, nested IF, IFS, SWITCH, AND, OR, NOT and IFERROR. Learn how conditions work, with live stand-ins to try.
  6. 10 Understanding Formula Errors Learn what #DIV/0!, #N/A, #REF!, #VALUE!, #NAME? and circular reference errors mean in Google Sheets, and how to trace and fix each one.

Lookups and Dates

  1. 11 VLOOKUP, HLOOKUP and Their Limits Learn VLOOKUP and HLOOKUP in Google Sheets: exact versus approximate match, the column index trap, the left-lookup limit, with Python stand-ins.
  2. 12 XLOOKUP, INDEX and MATCH Replace VLOOKUP with XLOOKUP, or INDEX and MATCH, in Google Sheets: look left, return many columns, do two-way and multi-criteria lookups.
  3. 13 Dates and Times Learn how Google Sheets stores dates as serial numbers and use TODAY, DATE, EDATE, DATEDIF, NETWORKDAYS, WEEKDAY and TEXT to calculate with them.

Working with Data

  1. 14 Sorting and Filtering Data Sort ranges and sheets, use filters and filter views, and build live results with the SORT and FILTER functions in Google Sheets.
  2. 15 Group and Hide Rows and Columns Group and ungroup rows and columns in Google Sheets, collapse sections, hide versus filter, and total only visible rows with SUBTOTAL, with fixes for common problems.
  3. 16 Conditional Formatting Highlight cells automatically in Google Sheets with conditional formatting: single-color rules, color scales, custom formulas and duplicate checks.
  4. 17 Data Validation and Dropdowns Control what people can type in Google Sheets: dropdown lists, checkboxes, number and date limits, custom formula rules and how to protect input.
  5. 18 SUMIF, COUNTIF, AVERAGEIF and Friends Add, count and average only the rows that match: SUMIF, COUNTIF, AVERAGEIF, SUMIFS and COUNTIFS in Google Sheets, with criteria, wildcards and dates.
  6. 19 Pivot Tables Summarize thousands of rows in seconds with Google Sheets pivot tables: rows, columns, values, filters, date grouping and calculated fields.
  7. 20 Charts and Sparklines Build charts in Google Sheets: pick the right chart type, customize axes and colors, draw SPARKLINE mini charts in cells, and publish or embed a chart.

Advanced Formulas

  1. 21 Array Formulas and ARRAYFORMULA Learn array formulas in Google Sheets: ARRAYFORMULA for whole-column results, plus MAP, BYROW, LAMBDA and LET for clean, powerful formulas.
  2. 22 The QUERY Function Master the Google Sheets QUERY function: SQL-like select, where, group by, order by, limit and label clauses, with clear examples you can adapt.
  3. 23 Importing Live Data Pull live data into Google Sheets with IMPORTRANGE, IMPORTDATA, IMPORTHTML, IMPORTXML and GOOGLEFINANCE, and learn their limits and common errors.

Automation and Collaboration

  1. 24 Sharing, Comments and Version History Collaborate in Google Sheets: share with the right permissions, comment and assign tasks, protect ranges, and restore earlier versions from history.
  2. 25 Automating with Apps Script Start automating Google Sheets with Apps Script: write custom functions, read and write ranges, add menus and set up triggers, with safe examples.

Projects, Practice and Interviews

  1. 26 Real-World Projects Build four real Google Sheets projects: a budget tracker, a gradebook, an invoice generator and an inventory dashboard, with formulas and checks.
  2. 27 Practice Exercises with Solutions Practice Google Sheets with exercises on formulas, lookups, SUMIFS, QUERY and pivot tables. Try each one yourself, then compare with the solution.
  3. 28 Interview Questions Prepare for Google Sheets interviews: common questions with clear answers on formulas, lookups, QUERY, pivots, errors and Excel differences.
  4. 29 Google Sheets Cheat Sheet A quick Google Sheets cheat sheet: keyboard shortcuts, the most useful formulas, reference rules and fixes for common errors, on one page.