Google Sheets Beginner Tutorial

This beginner course introduces Google Sheets for creating, calculating, formatting, organizing, and sharing spreadsheets. It covers basic formulas and functions, cell references, AutoFill, worksheets, templates, and publishing or emailing sheets.

Syllabus

Start
Introduction
Start Page
Interface
Search the Menus
Navigating and Selecting Cells
Entering and Editing Data
Explore
Performing Simple Calculations
Saving
Introduction to Google Drive
Building Basic Formulas
Using Simple Functions
Copying Formulas and Functions with AutoFill
Relative vs Absolute Reference
Inserting Rows and Columns
Moving, Copying, and Pasting Data
Using AutoFill to Complete a Series of Values
Cell Formatting - Align, Text Rotation, Text Wrapping
Formatting Worksheet Data and Using Cell Design
Using Sheets Templates
Inserting, Deleting, Renaming, Moving, and Copying Worksheets
Freeze Panes
Currency Formatting
Hiding Rows and Columns
Spell Check
Using the Full-Screen View
Printing
Download Options
Publishing Sheets to the Web
Sending Sheets as Emails
Conclusion