Course Syllabus

 

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
Universal Class is an IACET Accredited Provider
 

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.
 
 

Assessment Guide

Assessment Points
Why this Course? 1 points
Lesson 1 Quiz 10 points
Lesson 2 Quiz 10 points
Lesson 3 Quiz 10 points
Lesson 4 Quiz 10 points
Lesson 5 Quiz 10 points
Lesson 6 Quiz 10 points
Lesson 7 Quiz 9 points
Lesson 8 Quiz 9 points
Lesson 9 Quiz 10 points
Lesson 10 Quiz 9 points
Lesson 11 Quiz 10 points
Lesson 12 Quiz 8 points
Lesson 13 Quiz 10 points
Lesson 14 Quiz 10 points
Lesson 15 Quiz 9 points
Lesson 16 Quiz 10 points
The Final Exam 60 points
Google Slides
Google Slides
A Real World Example Using jQuery
A Real World Example Using jQuery
Ultimate Excel Training Bundle
Ultimate Excel Training Bundle
Communications Courses
Communications Courses
Microsoft Visio 2019
Microsoft Visio 2019
Business Writing Courses
Business Writing Courses
Google Docs
Google Docs
How to Make the Most of Pivot Tables in Excel 2019
How to Make the Most of Pivot Tables in Excel 2019
Microsoft Office 2021: Word, Excel, PowerPoint and Outlook
Microsoft Office 2021: Word, Excel, PowerPoint and Outlook
Operations Management Courses
Operations Management Courses
How to Create Tables with HTML5
How to Create Tables with HTML5
Microsoft Access 2019
Microsoft Access 2019
How to Organize Work in OS X Yosemite
How to Organize Work in OS X Yosemite
Microsoft Word Courses
Microsoft Word Courses
Learn How to Create a Slack Server
Learn How to Create a Slack Server
Microsoft Excel Courses
Microsoft Excel Courses
How to Use the IF Function in Excel 2019
How to Use the IF Function in Excel 2019
QuickBooks Courses
QuickBooks Courses