Google Sheets Course online on September 24, 2024

Google Sheets Training Class

Tue, Sep 24 2024 - Tue, Sep 24 2024

Online Training

$249.00

Learn Google Sheets, the popular spreadsheet app from Google. This Google Sheets course teaches how to create sheets, work with data, apply formatting, share, and collaborate. Learn to manage text, numbers, perform calculations and use formulas. Find out how to create and edit charts using worksheet data and how to manage lists of data with sorting and filtering options, as well as how to share and collaborate. Learn to share content between Google Docs and Google Sheets.

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

See all Google Docs Training Classes

Why Google Docs classes at AGI are the best option for you

Hands-on learning: Learn Google Docs quickly with our proven teaching methods.
Exceptional curriculum: AGI has delivered Google Docs training to thousands over 25 years.
Expert instructors: Our instructors are Google Docs experts and skilled educators.
Small class sizes: Receive personalized attention with 10 or fewer participants per class.
Repeat for Free: If you need a refresher or miss a class day, retake the Google Docs class at no cost.

American Graphics Institute

All Google Docs classes include