Chat with us, powered by LiveChat

Google Sheets

Learn by doing—not watching—with interactive simulations.

853 users

Course Includes

  • Custom-branding Certificate of Achievement
  • Custom-branding Interactive Tutorials
  • Custom-branding Skills Assessments
  • Custom-branding Student manual, instructor guide, & practice files

What you'll learn

  • Understand how to use spreadsheets to calcuate information.
  • Learn the basics of entering and formatting data and numbers.
  • Build simple formulas to calculate totals and averages.
  • Upload and convert existing Microsoft Excel files to Google Docs.

Try sample lessons in the course outline shown below!

Proven Learning Method

Learning Method Diagram
Skill Assess Learn Verify Improvement

Google Sheets

Complete Course to Display Score

Sheets Fundamentals demo

Create Spreadsheets Click To Try Not Started Not Started Not Started
Open a Spreadsheet Not Started Not Started Not Started
Navigate Spreadsheets Not Started Not Started Not Started
File Management Not Started Not Started Not Started
Print Spreadsheets Not Started Not Started Not Started
Get Help Not Started Not Started Not Started

Edit Spreadsheets lock Subscribe to unlock

Select Cells and Ranges
Edit Cell Data
Cut, Copy, and Paste Data
Undo, Redo, and Repeat
Use Paste Special
Insert and Move Cells
Delete Cells
Hide Rows and Columns
Find and Replace Text
Check Spelling

Format Spreadsheets lock Subscribe to unlock

Format Text
Align and Merge Cells
Cell Borders and Background Colors
Format Numbers and Dates
Adjust Row Height and Column Width
Freeze Rows and Columns
Copy Formatting
Apply Conditional Formatting

Formulas and Functions lock Subscribe to unlock

Formula Basics
Autofill
Sums and Averages
MIN and MAX
COUNT
Insert Functions
Absolute and Relative Cell References
Cell Range Names

Manage Sheets and Data lock Subscribe to unlock

Insert, Rename, and Delete Sheets
Duplicate, Move, and Hide Sheets
Sort Data
Filter Data
Data Validation
Protect Spreadsheets

Insert Objects lock Subscribe to unlock

Insert a Chart
Customize a Chart
Insert Images
Insert Links

Share, Collaborate, and Convert lock Subscribe to unlock

Upload and Convert Spreadsheets
Download and Email Spreadsheets
Share Spreadsheets
Collaborate
Work with Versions
Add-Ons