Universal Class: Over 500 Online Certificate Courses

Course Syllabus: Google Sheets

Microsoft Excel Courses Picture
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.

Assessment Guide

Lesson 1 Quiz10
Lesson 2 Quiz10
Lesson 3 Quiz10
Lesson 4 Quiz10
Lesson 5 Quiz10
Lesson 6 Quiz10
Lesson 7 Quiz10
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:215
Show More

Related Articles