Google Sheets Full Course Tutorial

Learn to use Google Sheets to create, format, calculate with, analyze, chart, and share spreadsheets. Topics include formulas and functions, sorting and filtering, pivot tables, VLOOKUP, and real-time collaboration.

Syllabus

Start
Introduction
Accessing Google Sheets
Navigating in Cells and Menus
Keyboard Shortcuts
Editing Cell Contents
Templates
Using Explore
Opening and Saving Sheets
Using Google Drive with Google Sheets
Showing and Using the Formula Bar and Gridlines
Basic Formulas
Using Autofill to Copy Formulas
Using Autofill to Create Redundant Data
Simple Formulas
Formulas with Absolute References
Cut, Copy, and Paste
Inserting Rows and Columns
Wrapping Text, Rotating, and Aligning Cells
Cell Formatting
Hiding Rows and Columns
Freeze Panes and Full Screen View
Spell Check and Printing
Sharing and Emailing Sheets
Publishing to Web
Conclusion
Introduction
List, Format, and Sort
Multi-Column Sort
Filters
Conditional Filters and Filtered Views
Creating Charts
Editing Charts
Removing and Deleting Chart Data
Sparklines
Formatting with Alternating Row Colors
Pivot Tables
Pivot Charts
Named Ranges
IF Functions
Nested Functions
VLOOKUP
SUMIF and AVERAGEIF
SUMIFS
AVERAGEIFS
IFERROR
LEFT and RIGHT
CONCATENATE
Sharing Files
Real-Time Authoring
Google Sheets Add-Ons
Introduction to Google Apps Scripts
Conclusion