Instructor for this course
more

Google Sheets offers users a robust, powerful solution for creating and organizing information in everyday work and life. The program provides working professionals multiple routes to organize complex sources of data, then distill telling and informative insights.

Google Sheets has grown in both popularity and functionality over the last several years. It presents several advantages over competing spreadsheet programs like Excel, and at no cost.

This introductory Google Sheets course is designed for professionals in any industry or discipline. It also assumes you have little to no experience with Google Sheets. Whether you're a spreadsheet master or have never opened the program, you can dig right in and begin learning with ease. By the end, you’ll have a solid, working knowledge of how to get around in the program and use its power-packed fundamental functionality.

Learning Objectives

  • Discover how to navigate Google Sheets, including the creation of spreadsheets to understanding the program’s user-friendly interface
  • Identify multiple ways to keep your Sheets organized within a Google Drive account
  • Explore a variety of text formatting options within your Sheets, including text & cell colors, text wrap, and more
  • Discover how to manipulate rows, columns and cells
  • Explore additional formatting tools, including the Format Painter, the “Freeze Tool” and more
  • Recognize how to save and share your work, collaborate with other users, as well as limit editing access to others 
Last updated/reviewed: November 8, 2019

6 Reviews (21 ratings)Reviews

5
Member's Profile
I know the description was spreadsheet basics but I assumed the class would assume we all knew Excel and it would teach the basic differences between Excel & Google Sheets. As such, it was quite a bit more basic than I needed but I still learned a few things.
5
Anonymous Author
I have been using Google Sheets for years now, but was not aware of many basic functions in it until now, and they were explained well. A definite recommend.
5
Anonymous Author
Great course and very informative! The presenter does a good job tackling all the basics for google sheets.
4
Member's Profile
Very Basic Review of google sheets but helpful if new to google sheets. Most items were similar to excel.
4
Member's Profile
A little too basic; video was sometimes blurry, and the length requirement for a review was annoying
5
Member's Profile
This is a good course for individuals that want to learn another spreadsheet tool besides Excel.

Prerequisites

Course Complexity: Foundational

Please make sure you have a Google account. This is free (as is the use of Google Sheets). You can open a new Google account at www.Google.com. If you already have a Google or Gmail account, make sure you have the login and password to access it/them.

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Syllabus
INTRODUCTION AND OVERVIEW
  1:14Introduction and Meet your Instructor
  8:05Opening a Google Account
  8:19Simple Walkthrough of Google Sheets
  2:16Keeping Google Sheets Organized
  3:13Understanding Rows and Columns
  4:59Formatting Text
  2:00Text Wrapping
  1:42Fixing Mistakes
  4:35Changing Sizes
  2:03Merging Cells
  5:48Borders
  3:37Format Painter
  1:50Changing Cell Colors
  3:28Alternating Colors Tool
  1:59Freezing Rows and Columns
  5:11Sharing Your Sheets
CONTINUOUS PLAY
  1:00:28Master Spreadsheet Basics in 60 Minutes or Less Full Videos
SUPPORTING MATERIALS
  PDFMaster Spreadsheet Basics in 60 Minutes or Less Glossary/Index
REVIEW AND TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM