Online Class: Google Sheets

no certificate
with CEU Certificate*
-
16Lessons
-
18Exams &
Assignments -
2,367Students
have taken this course -
7Hours
average time -
0.7CEUs
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

Course Lessons
Lesson 1: Introduction to Google Sheets
Lesson 1 Video
Lesson discussions: Reasons for Taking this Course
Complete Assignment: Why this Course?
Assessment: Lesson 1 Quiz
Lesson 2: Navigating Google Sheets
Lesson 2 Video
Assessment: Lesson 2 Quiz
Lesson 3: Getting Started in Google Sheets
Lesson 3 Video
Assessment: Lesson 3 Quiz
Lesson 4: Spreadsheets and Workbooks
Lesson 4 Video
Assessment: Lesson 4 Quiz
Lesson 5: Entering Information into Google Sheets
Lesson 5 Video
Assessment: Lesson 5 Quiz
Lesson 6: Introduction to Working with Cells, Rows, and Columns
Lesson 6 Video
Assessment: Lesson 6 Quiz
Lesson 7: Formatting Data and Cells
Lesson 7 Video
Assessment: Lesson 7 Quiz
Lesson 8: Formatting Cells, Rows, and Columns
Lesson 8 Video
Assessment: Lesson 8 Quiz
Lesson 9: Introduction to Formulas and Calculations
Lesson 9 Video
Assessment: Lesson 9 Quiz
Lesson 10: Working with Formulas and Functions
Lesson 10 Video
Assessment: Lesson 10 Quiz
Lesson 11: Working with Data Using Pivot tables and Data Validation
Lesson 11 Video
Assessment: Lesson 11 Quiz
Lesson 12: Inserting Images into a Spreadsheet
Lesson 12 Video
Assessment: Lesson 12 Quiz
Lesson 13: Inserting Additional Elements into Google Sheets
Lesson 13 Video
Assessment: Lesson 13 Quiz
Lesson 14: Publishing and Printing Spreadsheets in Google Sheets
Lesson 14 Video
Assessment: Lesson 14 Quiz
Lesson 15: Sharing and Collaborating on Spreadsheets in Google Sheets
Lesson 15 Video
Assessment: Lesson 15 Quiz
Lesson 16: Other Helpful Tools in Google Sheets
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
Learning Outcomes
- 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

- 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

Choose Your Subscription Plan
No Certificate / No CEUs
This course only
Includes certificate | X |
Includes CEUs | X |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 6 months |
No. of courses | 1 course |
Certificate & CEUs
This course only
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 6 months |
No. of courses | 1 course |
Certificates & CEUs
Includes all 600+ courses
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 12 Months |
No. of courses | 600+ |
Certificates & CEUs
Includes all 600+ courses
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 24 Months |
No. of courses | 600+ |
Student Testimonials
- "This course was very helpful to me. I had never heard of google sheets and I learned a lot of principles." -- Carolyn W.
- "Helpful information. I like the mix of videos, readings and quizzes." -- Laura D.
Related Courses
-
45 hours 4.5 CEUs Ultimate Excel Training Bundle $125.00
-
7 hours 0.7 CEUs Google Slides $95.00
-
6 hours 0.6 CEUs Cybersecurity 101 $95.00
-
7 hours 0.7 CEUs PowerPoint 2021 $95.00
-
9 hours 0.9 CEUs Microsoft Project 2021 $95.00
-
8 hours 0.8 CEUs Quicken Tutorial: All Versions $95.00
-
17 hours 1.7 CEUs Introduction to SQL $95.00
-
6 hours 0.6 CEUs Microsoft Visio 2021 $95.00
-
8 hours 0.8 CEUs Microsoft Access 2019 $95.00
-
5 hours 0.5 CEUs SalesForce 101 $95.00
-
7 hours 0.7 CEUs Microsoft Word 2021 $95.00
-
5 hours 0.5 CEUs Outlook 2021 $95.00
-
6 hours 0.6 CEUs Google Docs $95.00
-
4 hours 0.4 CEUs Slack $95.00
-
6 hours 0.6 CEUs Computer Literacy Level 3 - Living and Working Online $95.00
-
14 hours 1.4 CEUs QuickBooks Online $95.00
-
5 hours 0.5 CEUs Windows 10 $95.00
-
6 hours 0.6 CEUs Computer Literacy Level 2 - Internet Basics $95.00
-
8 hours 0.8 CEUs MySQL $95.00
-
7 hours 0.7 CEUs Google Sheets $95.00
-
6 hours 0.6 CEUs Microsoft Publisher 2021 $95.00
-
8 hours 0.8 CEUs Learn HTML - Create Webpages Using HTML5 $95.00
-
7 hours 0.7 CEUs Computer Literacy Level 1 - Computer Basics $95.00