Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Google Sheets - Beginner
Introduction
Introduction (0:51)
Getting Started with Google Sheets
What is Google Sheets? (2:06)
Opening Google Sheets (2:43)
Importing and Converting Spreadsheets to Sheets (3:45)
Navigating the Sheets User Interface (5:21)
Understanding Sheet Components (3:27)
Using The File Menu (2:11)
Creating a Spreadsheet (2:05)
Saving a Spreadsheet (1:48)
Accessing Help (2:12)
Entering Data
Navigating a Spreadsheet by Mouse or Keyboard (4:32)
Working with Cell and Ranges (3:05)
Using Various Data Selection Techniques (3:37)
Working with Common Sheet Commands (2:23)
Working with Copy and Paste (4:05)
Understanding Data Types (2:22)
Formatting Values (2:37)
Using the Autofill Handle (3:16)
Inserting Links (3:42)
Understanding Formula Basics
What are Formulas and Functions? (4:41)
Understanding the Components of a Formula (6:58)
Understanding Calculation Hierarchy and the Order of Operations (3:53)
Creating Basic Formulas (5:30)
Working with Basic Functions and AutoSum (4:13)
Using Cell References (4:38)
Using Explore (2:28)
Formatting a Spreadsheet
Formatting and Aligning Data (3:38)
Modifying Columns and Rows (4:38)
Using Borders and Fill (4:41)
Using Paint Format (2:10)
Inserting Notes or Comments (2:58)
Inserting Checkboxes (2:09)
Applying a Theme (2:20)
Managing Spreadsheets
Using Zoom Tools (1:39)
Working with Sheets (1:40)
Working with Spreadsheet Tabs (3:11)
Hiding and Unhiding Spreadsheets (1:33)
Sorting Sheets Data (4:25)
Filtering Sheets Data (4:23)
Using Filter Views (3:55)
Using Freeze Panes (2:48)
Printing a Spreadsheet
Using Find and Replace (2:53)
Using Spell Check (2:09)
Preparing a Spreadsheet for Printing (4:28)
Changing Spreadsheet Settings (1:56)
Finalizing Printing (1:25)
Downloading and Emailing Files (2:06)
Sharing a Spreadsheet (3:20)
Creating Charts
Inserting a Chart (3:34)
Formatting a Chart (4:59)
Moving and Sizing a Chart (1:45)
Creating a Scorecard Chart (2:48)
Working with Graphics
Inserting Images (2:42)
Creating Drawing (3:01)
Conclusion
Course Recap (1:02)
Opening Google Sheets
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock