Skip to content
QuickBooks® Training Library: The KnOWLedge Base

Google Sheets Training Course


Course
Quantity
For someone else
Alicia Katz Pollock
Quantity
For someone else
Purchase for $54 or enter access code

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.

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.

Introduction to Google Sheets
Google Drive Overview
Creating New Files

3. The Interface and Toolbars

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

Exploring the Menu and Tool Bar
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.

Labels, Values, The Auto-Fill Handle, Copy/Paste
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.

Themes and Font Formatting
Number Formatting
Cell Formatting
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.

Column Charts
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!

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!

Printing on Paper
Sharing and Collaborating
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.

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!

Course Participation

Completion

The following certificates are awarded when the course is completed:

Royalwise CPE Certificate
Back to top