Online Class: Google Sheets

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.

$95.00
no certificate

- OR -

$120.00
with CEU Certificate*

Start Right Now!

$120.00 (with CEU Certificate)

Taking multiple courses? Save with our platinum program.

16

Lessons
18

Exams &
Assignments
2,927

Students
have taken this course
7

Hours
average time
0.7

CEUs

Course Description

Mastering the Art of Google Sheets: Unleashing the Power of Spreadsheets

In today's digital age, data management and analysis have become paramount. Enter Google Sheets, the contemporary and highly accessible cousin of Microsoft Excel. Crafted by Google, this spreadsheet tool is not only intuitive but also designed for the modern user, ensuring access from any corner of the world as long as there's an internet connection. While Google Sheets might not parade every single feature found in traditional spreadsheet tools, it triumphs with its sleek simplicity, laser-focused on delivering impactful, professional results without the clutter.

Embark on a transformative journey with our comprehensive course that delves deep into the universe of Google Sheets. From its foundational bricks to the soaring towers of advanced functionalities, we've got you covered. For those new to the Google ecosystem, fret not! We'll initiate with the essentials of setting up your Google account and seamlessly traversing the mobile application.

Our curriculum promises a rich tapestry of skills:

Crafting meticulous spreadsheets
Aesthetically formatting for data clarity
Seamless data input
Unraveling the magic of formulas and functions
Visualizing data with dynamic charts
Building interactive forms
Harnessing the power of pivot tables & charts
Exploring the world of ready-to-use templates
...and a treasure trove of features waiting to be unveiled.

Each module is articulated with precision, accompanied by vibrant illustrations, ensuring you grasp every nuance. Our lessons are not mere lectures but immersive experiences, walking with you, hand-in-hand, through every procedure. Whether you're a novice with no prior spreadsheet exposure or someone looking to switch from another platform, our course is tailored for all. With our meticulously crafted modules, illustrative screenshots, and HD video guides, you're set to elevate your skills and emerge as a Google Sheets maestro. Dive in and watch your data dance to your tunes!

Courses Frequently Bought Together:

Microsoft Excel Level 1

Microsoft Office: Word, Excel, PowerPoint and Outlook

QuickBooks 101

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:

"Extraordinarily Helpful"

(1,592 votes)

Lesson 1: Introduction to Google Sheets

11 Points

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: Google Sheets in iTunes App Store; How to use Google Sheets; Create Spreadsheets with Google Sheets; How to Open Google Sheet with Google Chrome

Lesson 1 Video
Lesson discussions: Reasons for Taking this Course
Complete Assignment: Why this Course?
Assessment: Lesson 1 Quiz

Lesson 2: Navigating Google Sheets

10 Points

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

Lesson 2 Video
Assessment: Lesson 2 Quiz

Lesson 3: Getting Started in Google Sheets

10 Points

This lesson will continue to focus on different uses for opening and beginning this program. Additional lesson topics: 11 of the Best Free Google Sheets Templates for ; Google Sheets; How to download View only Google Sheet

Lesson 3 Video
Assessment: Lesson 3 Quiz

Lesson 4: Spreadsheets and Workbooks

10 Points

In this lesson, we'll learn all about spreadsheets and workbooks. Additional lesson topics: Combining Spreadsheets with Google Sheets; How to Link Google Spreadsheets : Google Applications; Google Sheets

Lesson 4 Video
Assessment: Lesson 4 Quiz

Lesson 5: Entering Information into Google Sheets

10 Points

This lesson will focus on entering information into Google Sheets Additional lesson topics: Edit and format a spreadsheet; Sheets Cheat Sheet; Google Spreadsheets

Lesson 5 Video
Assessment: Lesson 5 Quiz

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

10 Points

This lesson will provide an introduction to working with Cells, Rows, and Columns Additional lesson topics: Tips for Using Copy and Paste; How to Insert Multiple Rows in Google Sheets; How to Copy a Formula Down an Entire Column in Google Sheets; How to insert copied row or column in Google Spreadsheet

Lesson 6 Video
Assessment: Lesson 6 Quiz

Lesson 7: Formatting Data and Cells

9 Points

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

Lesson 7 Video
Assessment: Lesson 7 Quiz

Lesson 8: Formatting Cells, Rows, and Columns

9 Points

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

Lesson 8 Video
Assessment: Lesson 8 Quiz

Lesson 9: Introduction to Formulas and Calculations

10 Points

This lesson will provide an introduction to Formulas and Calculations Additional lesson topics: Comparison Operators in Google Sheets and Equivalent Functions; Google Sheets: Creating Simple Formulas; Google sheets function list; Google Spreadsheet- Basic Calculations

Lesson 9 Video
Assessment: Lesson 9 Quiz

Lesson 10: Working with Formulas and Functions

9 Points

This lesson will focus on working with Formulas and Function. Additional lesson topics: Google Sheets- Named Ranges; Google Spreadsheets Functions Tutorial; Types of Cell References; Absolute and Relative References; Working with Functions

Lesson 10 Video
Assessment: Lesson 10 Quiz

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

10 Points

In this lesson, we are going to discuss the methods that Google Sheets gives you to filter, sort, and summarize data. Additional lesson topics: Create Pivot Tables and Charts in Google Sheets; How to Sort and Filter Spreadsheet Data in Google Sheets; Building Pivot Tables in Google Sheets; How to Create Filters in Google Sheets

Lesson 11 Video
Assessment: Lesson 11 Quiz

Lesson 12: Inserting Images into a Spreadsheet

8 Points

This lesson will discuss how to insert images into a Spreadsheet Additional lesson topics: Insert or delete images or videos

Lesson 12 Video
Assessment: Lesson 12 Quiz

Lesson 13: Inserting Additional Elements into Google Sheets

10 Points

This lesson will focus on inserting additional elements in Google Sheets Additional lesson topics: Google Sheets: Duplicate the shape properties; Google Sheets

Lesson 13 Video
Assessment: Lesson 13 Quiz

Lesson 14: Publishing and Printing Spreadsheets in Google Sheets

10 Points

This lesson will focus on the procedures for publishing and printing spreadsheets in Google. Additional lesson topics: Using Publish to the Web with Google Sheets; Use conditional formatting rules in Google Sheets; Embed a Spreadsheet from Google Sheets into Google Slides; Google Sheets; Embed a Spreadsheet from Google Sheets into Google Docs; Publish a Google Sheet as an HTML Webpage

Lesson 14 Video
Assessment: Lesson 14 Quiz

Lesson 15: Sharing and Collaborating on Spreadsheets in Google Sheets

9 Points

This lesson will focus on the process of sharing and collaborating on a Google Spreadsheet. Additional lesson topics: How to Link Spreadsheets and Share Data in Google Sheets; How to stop sharing a file; How to Share and Collaborate With Google Drive

Lesson 15 Video
Assessment: Lesson 15 Quiz

Lesson 16: Other Helpful Tools in Google Sheets

70 Points

This lesson will review 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

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

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

Course Title: Google Sheets

Course Number: 9770571

Lessons Rating: 4.5 / 5 Stars (1,592 votes)

Languages: English - United States, Canada and other English speaking countries

Availability: You can take this course online in every U.S. state including California, Texas, Florida, New York, Pennsylvania, Illinois, Ohio, and Georgia. International availability includes English-speaking countries like Canada, Australia, the UK, and South Africa.

Last Updated: December 2023

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

Instructor: UniversalClass Instructional Team

Syllabus: View Syllabus

Course Fee: $120.00 U.S. dollars

Choose Your Subscription Plan

Course Only

One Course
No Certificate / No CEUs

$95

for 6 months

Add to Cart

Billed once
This course only

Includes certificate	X
Includes CEUs	X
Self-paced
Instructor support
Time to complete	6 months
No. of courses	1 course

Certificate Course

One Course
Certificate & CEUs

$120

for 6 months

Add to Cart

Billed once
This course only

Includes certificate
Includes CEUs
Self-paced
Instructor support
Time to complete	6 months
No. of courses	1 course

Platinum Yearly

ALL COURSES
Certificates & CEUs

$189

per year

Start Now

Billed once
Includes all 600+ courses

Includes certificate
Includes CEUs
Self-paced
Instructor support
Time to complete	12 Months
No. of courses	600+

Platinum 2 Years

ALL COURSES
Certificates & CEUs

$299

for 2 years

You save $79.00!

Start Now

Billed once
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.