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
  • 18
    Exams &
    Assignments
  • 1,435
    Students
    have taken this course
  • 7
    Hours
    average time
  • 0.7
    CEUs
 
 

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.6 / 5 Stars (Average Rating)
"Extraordinarily Helpful"
(1,238 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. Additional lesson topics: How to use Google Sheets; How to Open Google Sheet with Google Chrome; Google Sheets in iTunes App Store; Create Spreadsheets with Google Sheets 11 Total Points
  • Lesson 1 Video
  • Lesson discussions: Reasons for Taking this Course
  • Complete Assignment: Why this Course?
  • Assessment: 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. Additional lesson topics: Chromebook: How to Navigate Google Sheets; Google Sheets 101: The Beginner's Guide to Online Spreadsheets 10 Total Points
  • Lesson 2 Video
  • Assessment: 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. Additional lesson topics: Google Sheets; How to download View only Google Sheet; How do I find templates in Google Drive?; Several of the Best Free Google Sheets Templates for 10 Total Points
  • Lesson 3 Video
  • Assessment: Lesson 3 Quiz

Lesson 4: Spreadsheets and Workbooks

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

Lesson 5: Entering Information into Google Sheets

This lesson will focus on entering information into Google Sheets Additional lesson topics: Sheets Cheat Sheet; Edit and format a spreadsheet; Google Spreadsheets 10 Total Points
  • Lesson 5 Video
  • Assessment: 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 Additional lesson topics: How to insert copied row or column in Google Spreadsheet; How to Insert Multiple Rows in Google Sheets; How to Copy a Formula Down an Entire Column in Google Sheets; Tips for Using Copy and Paste 10 Total Points
  • Lesson 6 Video
  • Assessment: Lesson 6 Quiz

Lesson 7: Formatting Data and Cells

Formatting a spreadsheet can change the look and feel of it. Additional lesson topics: Changing Font in Google Sheets; Adding New Fonts to Google Sheets, Slides, or Docs 9 Total Points
  • Lesson 7 Video
  • Assessment: 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. Additional lesson topics: How to Vertically Center Cell Data in Google Sheets; Google Sheets: Modifying Columns, Rows, and Cells; How to Change Cell Color in Google Sheets; Changing Cell Background Colors in Google Sheets 9 Total Points
  • Lesson 8 Video
  • Assessment: Lesson 8 Quiz

Lesson 9: Introduction to Formulas and Calculations

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

Lesson 10: Working with Formulas and Functions

This lesson will focus on working with Formulas and Function. Additional lesson topics: Types of Cell References; Absolute and Relative References; Google Sheets- Named Ranges; Working with Functions; Google Spreadsheets Functions Tutorial 9 Total Points
  • Lesson 10 Video
  • Assessment: 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. Additional lesson topics: Building Pivot Tables in Google Sheets; Create Pivot Tables and Charts in Google Sheets; How to Create Filters in Google Sheets; How to Sort and Filter Spreadsheet Data in Google Sheets 10 Total Points
  • Lesson 11 Video
  • Assessment: Lesson 11 Quiz

Lesson 12: Inserting Images into a Spreadsheet

This lesson will discuss how to insert images into a Spreadsheet Additional lesson topics: Insert or delete images or videos 8 Total Points
  • Lesson 12 Video
  • Assessment: Lesson 12 Quiz

Lesson 13: Inserting Additional Elements into Google Sheets

This lesson will focus on inserting additional elements in Google Sheets Additional lesson topics: Google Sheets: Duplicate the shape properties; Google Sheets 10 Total Points
  • Lesson 13 Video
  • Assessment: 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. Additional lesson topics: Google Sheets; Embed a Spreadsheet from Google Sheets into Google Slides; Use conditional formatting rules in Google Sheets; Embed a Spreadsheet from Google Sheets into Google Docs; Publish a Google Sheet as an HTML Webpage; Using Publish to the Web with Google Sheets 10 Total Points
  • Lesson 14 Video
  • Assessment: 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. Additional lesson topics: How to stop sharing a file; How to Link Spreadsheets and Share Data in Google Sheets; How to Share and Collaborate With Google Drive 9 Total Points
  • Lesson 15 Video
  • Assessment: 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
  • Lesson discussions: End of Course Poll; Course Comments; Program Evaluation Follow-up Survey (End of Course)
  • Assessment: Lesson 16 Quiz
  • Assessment: The Final Exam
215
Total Course Points
 

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.
  • Demonstrate mastery of lesson content at levels of 70% or higher.
 

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
Course Requirements: View Course Requirements
Lessons Rating: 4.6 / 5 Stars (1,238 votes)
Languages: English - United States, Canada and other English speaking countries
Course Type: 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
Syllabus: View Syllabus
Course Fee: $75.00 U.S. dollars

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
 
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
$69 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+