Chat with us, powered by LiveChat

Google Sheets

Learn by doing—not watching—with interactive simulations.

718 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