Universal Class: Over 500 Online Certificate Courses

Online Class: Google Sheets

no certificate
- OR -
with CEU Certificate*
Start Right Now!
Taking multiple courses? Save with our platinum program.

Course Description

Google Sheets is a spreadsheet app that is Google's answer to Microsoft Excel. Because Google Sheets can be accessed on any device for which you have Internet access, it makes it more convenient for users.   That said, Google Sheets does not contain all the features that you would find in Microsoft Excel.   Instead, it is a basic spreadsheet program that leaves out the bells and whistles, but includes all the features you need to create professional spreadsheets.  

This course was developed to teach you how to access and use Google Sheets, starting with the basics before working its way into the more advanced features.   It includes instructions for setting up a Google account, as well as navigating the mobile app.  

This course will teach you how to:

·    Create a spreadsheet

·    Format cells, rows, columns, and entire worksheets so they fit and match your data

·    Enter data into a spreadsheet

·    Use formulas and functions for calcualations

·    Create formulas and functions

·    Calculate data

·    Create charts for your data

·    Create forms

·    Create pivot tables and pivot charts.

·    Work with templates

·    And much more

This course was designed to teach you skills you'll need to successfully use Google Sheets.   Each lesson contains instructions and illustrations to show you how to use the features, then walks you through step-by-step so you can see how everything is done. You don't need previous experience with Google Sheets or any other spreadsheet program to be able to complete this course.  What's more, you do not need to be able to access Google Sheets. However, it is highly recommended.   

Course Requirements

This course will not require you to have previous experience in any particular area, but you should have a high school reading level. No books will be required

Course Topics

Lesson 1: Introduction to Google Sheets

Lesson 2: Navigating Google Sheets

Lesson 3: Getting Started in Google Sheets

Lesson 4: Spreadsheets and Workbooks

Lesson 5: Entering Information into Google Sheets

Lesson 6: Introduction to Working with Cells, Rows, and Columns

Lesson 7: Formatting Data and Cells

Lesson 8: Formatting Cells, Rows, and Columns

Lesson 9: Introduction to Formulas and Calculations

Lesson 10: Working with Formulas and Functions

Lesson 11: Working with Data Using Pivot tables and Data Validation

Lesson 12: Inserting Images into a Spreadsheet

Lesson 13: Inserting Additional Elements into Google Sheets

Lesson 14: Publishing and Printing Spreadsheets in Google Sheets

Lesson 15: Sharing and Collaborating on Spreadsheets in Google Sheets

Lesson 16: Other Helpful Tools in Google Sheets

Course Materials

All course material will be provided in the lessons and netlinks. There are no required materials to purchase before taking the class.

Grading Policy

Each lesson will include a lesson review quiz. Students will successfully complete this course by mastering all learning outcomes with 70% or higher overall grade.

Learning Outcomes

By successfully completing this course, students will be able to:
  • Define what a spreadsheet is and what Google Sheets capabilities are.
  • Demonstrate navigating google sheets.
  • Demonstrate entering information into google sheets.
  • Demonstrate working with cells, rows, and columns.
  • Demonstrate formatting cells, rows, and columns.
  • Demonstrate creating and using formulas and calculations.
  • Demonstrate working with Data Using Pivot tables and Data Validation.
  • Demonstrate inserting images into a spreadsheet.
  • Demonstrate publishing and printing spreadsheets.
  • Demonstrate sharing and collaborating on spreadsheets in Google Sheets, and
  • Demonstrate mastery of lesson content at levels of 70% or higher.

Assessment Guide

Assessment Points
Lesson 1 Quiz10
Lesson 2 Quiz10
Lesson 3 Quiz10
Lesson 4 Quiz10
Lesson 5 Quiz10
Lesson 6 Quiz10
Lesson 7 Quiz9
Lesson 8 Quiz9
Lesson 9 Quiz10
Lesson 10 Quiz9
Lesson 11 Quiz10
Lesson 12 Quiz8
Lesson 13 Quiz10
Lesson 14 Quiz10
Lesson 15 Quiz9
Lesson 16 Quiz10
The Final Exam60
Total Points:214

Related Articles

Follow Us Online
  • Follow us on FaceBook Follow us on Twitter Follow us on YouTube
© Copyright 1999-2020 Universal Class™ All rights reserved.