Google Sheets Beginner Tutorial - 2023 Update

A beginner course on using Google Sheets to create, edit, format, calculate with, and share spreadsheets. It covers basic formulas, autofill, cell references, and working with Google Drive.

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