Google Sheets Training Class

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 and Export Options

• Using page layout options
• Adjusting margins
• Adding headers and footers
• Saving a sheet as a pdf