Skip to content
OnDemand Videos

Google Sheets Training Course


Course
Alicia Katz Pollock
Purchase for $29

Use the free Google Sheets instead of Microsoft Excel. Create spreadsheets, collaborate in real time, and import/export to other software.

Google Sheets Training Course Description

Google apps is an online web-based suite of business apps that parallel Microsoft Office. Sheets is Google’s spreadsheet, like Excel.  Take this class to learn how to use Sheets to create your own spreadsheets, share them with others, and import/export them with Excel.

 

Instructional Level

Beginner through Intermediate. 

Course Length

1.75 hours 

Course Credits

1.75 CPE, Certificate of Completion

Field of Study

Software

Delivery Method

QAS / Self Study 

Prerequisites 

A google account.

Who should take this Google Sheets class?

  • Business owners and employees who leverage Google Docs for their business documents.
  • People who are familiar with Excel but need to make the switch. 

     

What You’ll Learn 

  • Moving around in a spreadsheet
  • Entering data
  • AutoFill Handle
  • Formulas and Functions
  • Relative and Absolute Cell References
  • Formatting
  • Charts
  • Printing
  • Conditional Formatting
  • Plus, you’ll learn valuable tips and tricks to shave time off your daily tasks.
  •   Desktop Publishing
  •   Answer your specific questions.
  •   Plus, you’ll learn valuable tips and tricks to shave time off your daily tasks.

For more information regarding concerns, refunds, and program cancellation policies, visit our Terms and Conditions

 

Here is the course outline:

1. Download the Handout

Download the handout that goes with the course.

pageText Download the handout here

2. Watch the Videos: Google Sheets Spreadsheets

G Suite is Google's online web-based suite of business apps that parallel Microsoft Office. Sheets is Google’s spreadsheet, like Excel. Take this class to learn how to use Sheets to create your own spreadsheets, share them with others, and import/export them with Excel.

pageText Introduction to Google Sheets
pageText Google Drive Overview
pageText Creating New Files

3. The Interface and Toolbars

Watch these videos to learn about Google Sheets Interface and Tool bars.

pageText Exploring the Menu and Tool Bar
pageText The Spreadsheet Rows, Columns, and Cells

4. Entering Data

Once you've familiarized yourself with G-Sheet's Interface, let's take a closer look at how we enter data.

pageText Labels, Values, The Auto-Fill Handle, Copy/Paste
pageText Formulas and Functions

5. Formatting

These videos will you teach you the different types of formatting available for your spread sheet. Learn all about cell formatting, number formatting, and conditional formatting.

pageText Themes and Font Formatting
pageText Number Formatting
pageText Cell Formatting
pageText Conditional Formatting

6. Using Charts

These videos will show you how to create charts from the data within your spreadsheet. Learn about pie charts, bar graphs, and column charts.

pageText Column Charts
pageText Pie Charts

7. Intermediate Techniques

This section is dedicated to Absolute Cell Reference. This section is a little advanced, but with a little practice and understanding, you'll be well on your way to creating the most robust spreadsheets!

pageText Absolute Cell Reference

8. Printing and Sharing

These videos will go through the options for printing, sharing, and making your prized work available to the world!

pageText Printing on Paper
pageText Sharing and Collaborating
pageText Exporting to other Formats

9. Conclusion

Just a reminder, you can watch, re-watch, and watch again and again, until you have all these pro tips memorized. Don't forget to take the quiz for CPE credit. Alicia will conclude this course with some valuable information.

pageText Conclusion

10. Take the Quiz

Take this quiz to demonstrate your mastery of the material. Pass the quiz with an 80% or higher to complete the Course, earn your Certificate, and win points!

quiz Course Participation

Completion

The following certificates are awarded when the course is completed:

Royalwise Credit Certificate
Back to top