Online Class: Google Sheets


$50.00
no certificate
- OR -
$75.00
with CEU Certificate*
Start Right Now!
Taking multiple courses? Save with our platinum program.
 
  • 16
    Lessons
  • 17
    Exams &
    Assignments
  • 7
    Hours
    average time
  • 0.7
    CEUs
  • 167
    Students
    have taken this course
 
 
Search Button
 
 
 

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 many bells and whistles, but includes all the features you need to create professional spreadsheets.  

This course will 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.  

In this course, you'll learn 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 calculations
  • 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 will teach you all the 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.  With clear and concise step-by-step directions, beautifully illustrated lessons with screenshots, and HD Video tutorials, this Google Sheets online course will teach you everything you need to know to become a Google Sheets power user.

  • Completely Online
  • Self-Paced
  • Printable Lessons
  • Full HD Video
  • 6 Months to Complete
  • 24/7 Availability
  • Start Anytime
  • PC & Mac Compatible
  • Android & iOS Friendly
  • Accredited CEUs
Universal Class is an IACET Accredited Provider
 
 

Course Lessons

Average Lesson Rating:
4.9 / 5 Stars (Average Rating) 4.9 / 5 Stars (Average Rating) 4.9 / 5 Stars (Average Rating) 4.9 / 5 Stars (Average Rating) 4.9 / 5 Stars (Average Rating)
"Extraordinarily Helpful"
(484 votes)

Lesson 1: Introduction to Google Sheets

This first lesson will introduce this topic. 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. 10 Total Points
  • Lesson 1 Video
  • Review 3 Articles: Create Spreadsheets with Google Sheets; Google Sheets in iTunes App Store; How to use Google Sheets
  • Review Video: How to Open Google Sheet with Google Chrome
  • Complete: Lesson 1 Quiz

Lesson 2: Navigating Google Sheets

In this lesson, we are going to discuss how to start using Google Sheets. We will talk about navigating Google sheets on both a computer an Android device, then get started opening and importing files into the app. 10 Total Points
  • Lesson 2 Video
  • Review 2 Articles: Google Sheets 101: The Beginner's Guide to Online Spreadsheets; Chromebook: How To Navigate Google Sheets
  • Review Video: How to Use Google Sheets Mobile App | Open Spreadsheets on Your Phone or Tablet
  • Complete: Lesson 2 Quiz

Lesson 3: Getting Started in Google Sheets

This lesson will continue to focus on different uses for opening and beginning this program. 10 Total Points
  • Lesson 3 Video
  • Review 2 Articles: 11 of the Best Free Google Sheets Templates for 2018; How do I find templates in Google Drive?
  • Review 2 Videos: Google Sheets - Tutorial 03 - Template Gallery and Table Styles; How to download View only Google Sheet
  • Complete: Lesson 3 Quiz

Lesson 4: Spreadsheets and Workbooks

In this lesson, we'll learn all about spreadsheets and workbooks. 10 Total Points
  • Lesson 4 Video
  • Review 2 Videos: Combining Spreadsheets with Google Sheets; How to Link Google Spreadsheets : Google Applications
  • Complete: Lesson 4 Quiz

Lesson 5: Entering Information into Google Sheets

This lesson will focus on entering information into Google Sheets 10 Total Points
  • Lesson 5 Video
  • Review 2 Articles: Edit and format a spreadsheet; Sheets Cheat Sheet
  • Review Video: Google Spreadsheets - Enter Data in a Spreadsheet - Google Tools
  • Complete: Lesson 5 Quiz

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

This lesson will provide an introduction to working with Cells, Rows, and Columns 10 Total Points
  • Lesson 6 Video
  • Review 3 Articles: Tips for Using Copy and Paste; How to Copy a Formula Down an Entire Column in Google Sheets; How to Insert Multiple Rows in Google Sheets
  • Review Video: How to insert copied row or column in Google Spreadsheet
  • Complete: Lesson 6 Quiz

Lesson 7: Formatting Data and Cells

Formatting a spreadsheet can change the look and feel of it. 10 Total Points
  • Lesson 7 Video
  • Review 2 Videos: Changing Font in Google Sheets; Adding New Fonts to Google Sheets, Slides, or Docs
  • Complete: Lesson 7 Quiz

Lesson 8: Formatting Cells, Rows, and Columns

In addition to formatting data in a spreadsheet, Google Sheets also gives you the ability to apply formatting to cells, rows, and columns. 9 Total Points
  • Lesson 8 Video
  • Review 2 Articles: How to Vertically Center Cell Data in Google Sheets; Google Sheets: Modifying Columns, Rows, and Cells
  • Review 2 Videos: Changing Cell Background Colors in Google Sheets; How to Change Cell Color in Google Sheets
  • Complete: Lesson 8 Quiz

Lesson 9: Introduction to Formulas and Calculations

This lesson will provide an introduction to Formulas and Calculations 10 Total Points
  • Lesson 9 Video
  • Review 2 Articles: Google sheets function list; Comparison Operators in Google Sheets and Equivalent Functions
  • Review 2 Videos: Google Sheets: Creating Simple Formulas; Google Spreadsheet- Basic Calculations
  • Complete: Lesson 9 Quiz

Lesson 10: Working with Formulas and Functions

This lesson will focus on working with Formulas and Function. 9 Total Points
  • Lesson 10 Video
  • Review 2 Articles: Working with Functions; Types of Cell References
  • Review 3 Videos: Google Spreadsheets Functions Tutorial; Absolute and Relative References - Google Sheets; Google Sheets- Named Ranges
  • Complete: Lesson 10 Quiz

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

In this lesson, we are going to discuss the methods that Google Sheets gives you to filter, sort, and summarize data. 10 Total Points
  • Lesson 11 Video
  • Review 2 Articles: How to Sort and Filter Spreadsheet Data in Google Sheets; How to Create Filters in Google Sheets
  • Review 3 Videos: How to Filter and Sort Data in Google Sheets; Building Pivot Tables in Google Sheets; Create Pivot Tables and Charts in Google Sheets
  • Complete: Lesson 11 Quiz

Lesson 12: Inserting Images into a Spreadsheet

This lesson will discuss how to insert images into a Spreadsheet 8 Total Points
  • Lesson 12 Video
  • Review Article: Insert or delete images or videos
  • Review Video: Insert Images into Google Sheets Cells
  • Complete: Lesson 12 Quiz

Lesson 13: Inserting Additional Elements into Google Sheets

This lesson will focus on inserting additional elements in Google Sheets 10 Total Points
  • Lesson 13 Video
  • Review 2 Videos: Google Sheets: Duplicate the shape properties; Google Sheets - Insert Special Characters
  • Complete: Lesson 13 Quiz

Lesson 14: Publishing and Printing Spreadsheets in Google Sheets

This lesson will focus on the procedures for publishing and printing spreadsheets in Google. 10 Total Points
  • Lesson 14 Video
  • Review Article: Use conditional formatting rules in Google Sheets
  • Review 5 Videos: Using "Publish to the Web" with Google Sheets; Publish a Google Sheet as an HTML Webpage; Embed a Spreadsheet from Google Sheets into Google Docs; Embed a Spreadsheet from Google Sheets into Google Slides; Google Sheets - Tutorial 01 - Creating and Basic Formatting
  • Complete: Lesson 14 Quiz

Lesson 15: Sharing and Collaborating on Spreadsheets in Google Sheets

This lesson will focus on the process of sharing and collaborating on a Google Spreadsheet. 9 Total Points
  • Lesson 15 Video
  • Review 3 Articles: How to Share and Collaborate With Google Drive; How to Link Spreadsheets and Share Data in Google Sheets; How to stop sharing a file
  • Complete: Lesson 15 Quiz

Lesson 16: Other Helpful Tools in Google Sheets

This lesson will review other helpful tools in Google Sheets 70 Total Points
  • Lesson 16 Video
  • Take Poll: End of Course Poll
  • Take Survey: Course Comments
  • Complete: Lesson 16 Quiz
  • Complete: The Final Exam
215
Total Course Points
 

Additional Course Information

Online CEU Certificate
  • Document Your Lifelong Learning Achievements
  • Earn an Official Certificate Documenting Course Hours and CEUs
  • Verify Your Certificate with a Unique Serial Number Online
  • View and Share Your Certificate Online or Download/Print as PDF
  • Display Your Certificate on Your Resume and Promote Your Achievements Using Social Media
Document Your CEUs on Your Resume
 
Course Title: Google Sheets
Course Number: 9770571
Languages: English - United States, Canada and other English speaking countries
Category:
Course Type: How To (Self-Paced, Online Class)
CEU Value: 0.7 IACET CEUs (Continuing Education Units)
CE Accreditation: Universal Class, Inc. has been accredited as an Authorized Provider by the International Association for Continuing Education and Training (IACET).
Grading Policy: Earn a final grade of 70% or higher to receive an online/downloadable CEU Certification documenting CEUs earned.
Assessment Method: Lesson assignments and review exams
Instructor: UniversalClass Staff Instructors
Syllabus: View Syllabus
Duration: Continuous: Enroll anytime!
Course Fee: $50.00

Choose Your Subscription Plan

Course Only
One Course
No Certificate / No CEUs
$50
for 6 months
 
Billed once
This course only
Includes certificate X
Includes CEUs X
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Certificate Course
One Course
Certificate & CEUs
$75
for 6 months
 
Billed once
This course only
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Platinum Yearly
Best Value
ALL COURSES
Certificates & CEUs
$189
per year
You save 50%!
Billed once
Includes all 500+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 12 Months
No. of courses 500+
Platinum Monthly
ALL COURSES
Certificates & CEUs
$59 first month
$29.00 / each consecutive month thereafter
 
Billed monthly
Includes all 500+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete Monthly
No. of courses 500+