CONTENTS

Lesson library

Browse every lesson by skill group. Search by lesson name or expand and collapse folders to navigate the full library.

Create your first spreadsheetBeginner Understand rows, columns and cellsBeginner Format numbers and currencies in Google SheetsBeginner Sort data in Google SheetsBeginner Filter a spreadsheetBeginner Freeze rows and columnsBeginner Share a Google Sheet safelyBeginner Protect ranges and sheetsBeginner Create a dropdown listBeginner Use conditional formattingBeginner Build your first chartBeginner Import CSV filesBeginner Print and export a sheetBeginner Understand cell referencesBeginner Navigate the Sheets toolbarBeginner Use the formula bar and name boxBeginner Rename duplicate and color sheet tabsBeginner Move and copy rows and columnsBeginner Insert and delete cells safelyBeginner Resize and auto-fit columnsBeginner Wrap text and align cellsBeginner Merge cells without losing dataBeginner Apply alternating colors to tablesBeginner Create checkboxes for task listsBeginner Use protected sheets for templatesBeginner Use smart chips in a spreadsheetIntermediate Find and replace spreadsheet valuesIntermediate Use keyboard shortcuts efficientlyIntermediate Undo restore and version historyIntermediate Create named rangesIntermediate Use relative absolute and mixed referencesIntermediate Use fill handle and autofillIntermediate Create custom number formatsIntermediate Enter dates and times correctlyIntermediate Use data validation for clean entryIntermediate Add notes and comments to cellsIntermediate Resolve comments and assign tasksIntermediate Use filter views with collaboratorsIntermediate Group and ungroup rowsIntermediate Hide and unhide rows and columnsIntermediate Use named functions safelyIntermediate Make a copy of a spreadsheetIntermediate Download as Excel and PDFIntermediate Import Excel workbooksIntermediate Organize spreadsheets in Google DriveIntermediate Use offline mode and understand limitsIntermediate Set spreadsheet locale and time zoneIntermediate Use right-to-left sheet layoutIntermediate Make spreadsheets accessibleIntermediate Use dropdown chips for project statusIntermediate Create a simple data entry formAdvanced Understand spreadsheet calculation errorsAdvanced Check file ownership before sharingAdvanced Use the Explore panel where availableAdvanced Create a table with consistent headersAdvanced Use table formatting and referencesAdvanced Prepare a spreadsheet for printingAdvanced Create a simple budget from scratchAdvanced Audit a beginner spreadsheet checklistAdvanced

Apply formatting and freeze headers in Personal budgetBeginner Set up a clean sheet for Personal budgetBeginner Design headers and data types for Personal budgetAdvanced Add safe dropdowns to Personal budgetAdvanced Sort and filter entries in Personal budgetAdvanced Share a read-only copy of Personal budgetAdvanced

Set up a clean sheet for Weekly study planAdvanced Design headers and data types for Weekly study planAdvanced Add safe dropdowns to Weekly study planAdvanced Apply formatting and freeze headers in Weekly study planAdvanced Filter entries in Weekly study planAdvanced Share a read-only copy of Weekly study planAdvanced

Google Sheets for BeginnersBeginner

SUM functionBeginner AVERAGE functionBeginner COUNT and COUNTABeginner COUNTIF functionBeginner COUNTIFS functionBeginner SUMIF functionBeginner SUMIFS functionBeginner IF functionBeginner IFS functionBeginner IFERROR functionBeginner AND and OR functionsBeginner FILTER functionBeginner SORT functionBeginner UNIQUE functionBeginner QUERY functionBeginner

Combine data from multiple sheetsBeginner Find duplicates in a columnBeginner Remove blank rowsBeginner Extract first and last namesBeginner Calculate running totalsBeginner Create a dynamic dashboardBeginner Calculate working daysBeginner Track overdue tasksBeginner Compare two listsBeginner Lookup values across tabsBeginner

Monthly budget templateBeginner Weekly task plannerBeginner Inventory trackerBeginner Simple CRM spreadsheetBeginner Invoice trackerBeginner Project timelineBeginner Content calendarBeginner Habit trackerBeginner Expense trackerBeginner Sales dashboardBeginner

Fix formula parse errorsBeginner Fix circular dependency errorsBeginner Fix IMPORTRANGE permission errorsBeginner Fix incorrect date formatsBeginner Fix slow spreadsheetsBeginner Fix #REF! errorsBeginner Fix #VALUE! errorsBeginner Fix #N/A errorsBeginner Fix #DIV/0! errorsBeginner Fix #NAME? errorsBeginner Fix #NUM! errorsBeginner Fix #ERROR! messagesBeginner Fix array result expansion errorsIntermediate Fix wrong formula separatorsIntermediate Fix text-formatted numbersIntermediate Fix dates imported as textIntermediate Fix leading zeros disappearingIntermediate Fix decimal and currency locale issuesIntermediate Fix FILTER returning no matchesIntermediate Fix QUERY column name errorsIntermediate Fix QUERY date syntaxIntermediate Fix VLOOKUP wrong match resultsIntermediate Fix XLOOKUP missing valuesIntermediate Fix ARRAYFORMULA size mismatchesIntermediate Fix data validation rejecting entriesIntermediate Fix dropdown options not appearingIntermediate Fix filters hiding expected rowsIntermediate Fix frozen row problemsIntermediate Fix protected cell edit errorsIntermediate Fix spreadsheet sharing access errorsIntermediate Fix Google Sheets copy permission errorsAdvanced