All Google Docs classes include
Free retakes
Detailed curriculum
Live instructor
Flexible rescheduling
Certificate of Completion
Google Sheets Training Class
Google Sheets Training Class
This Google Sheets course teaches when, why, and how to use Google Sheets. Learn to enter and manage text, dates, numbers and currency. Discover how to perform calculations on data by creating custom formulas and using built in functions available within Google Sheets. Learn to format data and cells using formatting options. Discover how to create and edit charts based on worksheet data. Manage large lists of data by sorting and filtering the list. Print or share as PDF the completed worksheet and add headers, footers and change margins.
Questions about this Google Sheets class? Interested in a private or customized Google Sheets training? Call to speak with a training consultant: 781-376-6044.
This course is available individually or as part of these certificate programs:
Please call 800-851-9237 or 781-376-6044 to schedule a course.
Getting Started with Google Sheets
- Navigating Google Sheets
- Entering data – text, dates, numbers, currency, numbers as text
- Using keyboard shortcuts
- Saving a file
- Star a file
- Opening a file
- Accessing templates
Using Google Sheets Editing Features
- Using cut, copy and paste
- Undo and redo
- AutoFill handle
Performing Calculations in Google Sheets
- Creating formulas
- Understanding order of operations
- Relative vs. absolute references
- Using functions – SUM, AVERAGE, COUNT, COUNTA, TODAY, PMT
Modifying a Sheet
- Formatting cells
- Using paint format
- Aligning cell contents
- Adding borders and shading
- Inserting/deleting a row/column
- Resizing a column/row
- Using Conditional formatting
Using Google Sheets Tools
- Using spellcheck
- Working with substitutions
Working with Lists in Google Sheets
- Working with a list
- Sorting the list by one or more columns
Creating Charts in Google Sheets
- Creating a column chart
- Editing a chart
- Creating a pie chart
- Using chart options
Managing and Sharing Sheets
- Deleting a sheet
- Sharing and collaborating on sheets
- Using search to find a file
- Creating folders
- Using version history
- Sending a sheet through Gmail
Google Sheets Print amd Export Options
- Using page layout options
- Adjusting margins
- Adding headers and footers
- Saving a sheet as a pdf
We recommend that you have the the relevant software before starting this class.
You will receive comprehensive course materials for this class developed by the instructors at AGI.