Online Class: Google Sheets
no certificate
with CEU Certificate*
-
16Lessons
-
18Exams &
Assignments -
1,988Students
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
- 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 Slides $95.00
- 5 hours 0.5 CEUs Windows 10 $95.00
- 17 hours 1.7 CEUs Introduction to SQL $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
- 9 hours 0.9 CEUs Microsoft Project 2021 $95.00
- 6 hours 0.6 CEUs Microsoft Visio 2021 $95.00
- 5 hours 0.5 CEUs SalesForce 101 $95.00
- 7 hours 0.7 CEUs PowerPoint 2021 $95.00
- 5 hours 0.5 CEUs Outlook 2021 $95.00
- 7 hours 0.7 CEUs Microsoft Word 2021 $95.00
- 8 hours 0.8 CEUs Learn HTML - Create Webpages Using HTML5 $95.00
- 6 hours 0.6 CEUs Cybersecurity 101 $95.00
- 6 hours 0.6 CEUs Microsoft Publisher 2021 $95.00
- 8 hours 0.8 CEUs Microsoft Access 2019 $95.00
- 14 hours 1.4 CEUs QuickBooks Online $95.00
- 6 hours 0.6 CEUs Google Docs $95.00
- 8 hours 0.8 CEUs Quicken Tutorial: All Versions $95.00
- 7 hours 0.7 CEUs Computer Literacy Level 1 - Computer Basics $95.00
- 7 hours 0.7 CEUs Google Sheets $95.00