Yes. You can start learning on Learnr for free. Learnr Pro unlocks higher daily limits and extra features.

Learn Google Sheets

Build spreadsheets that calculate, update and collaborate on their own.

Free to start. Built from a single prompt. No credit card.

Google Sheets is a free, browser-based spreadsheet built for collaboration, with live multi-person editing, comments, version history and easy sharing. It covers the familiar spreadsheet core of formulas, references, sorting, filtering, pivot tables and charts, and adds functions that are especially strong in Sheets, like QUERY for SQL-style questions, IMPORTRANGE for pulling data between files, and ARRAYFORMULA for applying one formula to a whole column. Apps Script lets you automate tasks with JavaScript. Learnr builds a personalized Google Sheets course and teaches it through short interactive lessons based on everyday tasks.

How to learn Google Sheets, step by step

Learn references and basic functions. Practice SUM, AVERAGE, COUNTIF and IF, and understand how $ locks a row or column when you copy formulas. Build a simple budget or habit tracker as your first sheet so every function has a purpose.
Structure data so functions can use it. Keep one header row, one record per row, consistent data types in each column and no merged cells. Use data validation dropdowns so collaborators enter categories consistently.
Learn lookups and cross-file data. Use XLOOKUP or VLOOKUP to pull matching values from another tab, and IMPORTRANGE to bring data in from a separate spreadsheet after granting access once.
Master FILTER, UNIQUE, SORT and QUERY. These functions return whole ranges that spill automatically. QUERY uses a SQL-like language, for example selecting columns where a condition holds and grouping by a category, which lets one formula replace many manual steps.
Summarize, visualize and highlight. Build pivot tables, insert charts tied to live data, and use conditional formatting rules, including custom formulas, to flag overdue dates or values over a limit. Short daily Learnr lessons help you remember function syntax.
Collaborate safely and automate. Use comments, assigned action items, protected ranges and version history to work with others without losing data. Then record a macro or write a short Apps Script to automate a repetitive task.

What you'll learn

Write formulas with relative and absolute references and core functions
Look up and combine data with XLOOKUP, VLOOKUP and IMPORTRANGE
Filter, sort and summarize with FILTER, UNIQUE, QUERY and pivot tables
Keep data clean with data validation and conditional formatting
Share, protect and automate sheets with permissions and Apps Script

What's inside your Google Sheets course

A sample path Learnr builds for Google Sheets. Your real course adapts to your goal and level.

1. The Sheets interface, sharing and version history
2. Formulas, references and everyday functions
3. Lookups and connecting multiple sheets
4. FILTER, QUERY, ARRAYFORMULA and pivot tables
5. Charts, conditional formatting and data validation
6. Collaboration, protection and Apps Script automation

How long does it take to learn Google Sheets?

Everyday Google Sheets, including formulas, lookups, pivot tables and charts, takes about 2 to 4 weeks at a few hours a week. Comfort with QUERY, array formulas and Apps Script typically takes another 1 to 2 months, faster if you already know Excel.

What you need before you start

A free Google account and basic arithmetic. Experience with Excel helps, since most functions and concepts carry over closely.

Common mistakes to avoid

Sharing a sheet with edit access to everyone with the link, then losing work to accidental edits. Use view or comment access and protected ranges.
Copying a formula down thousands of rows when a single ARRAYFORMULA or a spilling FILTER would keep the sheet lighter and consistent.
Mixing text and numbers in one column, such as "5 units" next to 5, which breaks sums, sorting and QUERY results.

How Learnr builds your course

Type your topic

Tell Learnr you want to learn Google Sheets, or get as specific as you like.

Get a personalized course

Learnr instantly builds a full Google Sheets course tailored to your goal and skill level.

Learn and level up

Move through bite-sized lessons and interactive practice, earning XP and keeping your streak.

Google Sheets questions, answered

Is Google Sheets as good as Excel?

For most everyday work, including formulas, pivot tables, charts and collaboration, Sheets is fully capable and easier to share. Excel offers more for very large datasets, advanced modeling and tools like Power Query and Power Pivot.

What is the QUERY function in Google Sheets?

QUERY lets you write a SQL-like statement over a range, selecting columns, filtering rows, grouping, sorting and aggregating in one formula. It is one of the most useful functions specific to Sheets.