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,879
    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.56 / 5 Stars (Average Rating)
"Extraordinarily Helpful"
(1,572 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: How to Open Google Sheet with Google Chrome; Google Sheets in iTunes App Store; How to use Google Sheets; Create Spreadsheets with 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

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: How to download View only Google Sheet; Several of the Best Free Google Sheets Templates for ; Google Sheets
  • 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: Google Sheets; Combining Spreadsheets with Google Sheets; How to Link Google Spreadsheets : Google Applications
  • 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; Google Spreadsheets; Sheets Cheat Sheet
  • 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: How to Insert Multiple Rows in Google Sheets; Tips for Using Copy and Paste; How to insert copied row or column in Google Spreadsheet; How to Copy a Formula Down an Entire Column in Google Sheets
  • 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: Google Sheets: Modifying Columns, Rows, and Cells; Changing Cell Background Colors in Google Sheets; How to Vertically Center Cell Data in Google Sheets; How to Change Cell Color 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: Google sheets function list; Google Spreadsheet- Basic Calculations; Comparison Operators in Google Sheets and Equivalent Functions; Google Sheets: Creating Simple Formulas
  • 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 Spreadsheets Functions Tutorial; Google Sheets- Named Ranges; Working with Functions; Types of Cell References; Absolute and Relative References
  • 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: Building Pivot Tables in Google Sheets; How to Sort and Filter Spreadsheet Data in Google Sheets; How to Create Filters in Google Sheets; Create Pivot Tables and Charts 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: Use conditional formatting rules in Google Sheets; Embed a Spreadsheet from Google Sheets into Google Slides; Using Publish to the Web with Google Sheets; Embed a Spreadsheet from Google Sheets into Google Docs; Publish a Google Sheet as an HTML Webpage; Google Sheets
  • 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 Share and Collaborate With Google Drive; How to stop sharing a file
  • 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

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.56 / 5 Stars (1,572 votes)
Languages: English - United States, Canada and other English speaking countries
Availability: Accessible from any state in the U.S., this course covers key areas such as California, Texas, Florida, New York, Pennsylvania, Illinois, Ohio, and Georgia. The course is also offered in English-speaking nations like Australia, Canada, 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
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.