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,646
    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!

  • 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,551 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; Google Sheets in iTunes App Store; How to Open Google Sheet with Google Chrome; 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: How to download View only Google Sheet; Google Sheets; 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 Copy a Formula Down an Entire Column in Google Sheets; How to Insert Multiple Rows 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; How to Change Cell Color in Google Sheets; Google Sheets: Modifying Columns, Rows, and Cells; 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; Comparison Operators in Google Sheets and Equivalent Functions; Google Spreadsheet- Basic Calculations; 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: Absolute and Relative References; Working with Functions; Types of Cell References; Google Sheets- Named Ranges; 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; How to Create Filters in Google Sheets; Create Pivot Tables and Charts 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: Embed a Spreadsheet from Google Sheets into Google Slides; Publish a Google Sheet as an HTML Webpage; Embed a Spreadsheet from Google Sheets into Google Docs; Google Sheets; Using Publish to the Web with Google Sheets; Use conditional formatting rules in 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
Lessons Rating: 4.6 / 5 Stars (1,551 votes)
Languages: English - United States, Canada and other English speaking countries
Availability: This course is online and available in all 50 states including: California, Florida, Georgia, Illinois, New York, Pennsylvania, Ohio, Texas, and Washington.
Last Updated: July 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
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
 
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
$120
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
ALL COURSES
Certificates & CEUs
$189
per year
 
Billed once
Includes all 600+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 12 Months
No. of courses 600+
Platinum 2 Years
ALL COURSES
Certificates & CEUs
$299
for 2 years
You save $79.00!
Billed once
Includes all 600+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
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.