Google Sheets Essential Training

Learn how to analyze and organize data in Sheets, the popular spreadsheet tool from Google.

Introduction

• Getting organized with Google Sheets
• Importing exercise files to Google Sheets

1. Getting Started with Google Sheets

• What is Google Sheets?
• Accessing Google Sheets with your account
• Navigating Google Sheets

2. Creating and Managing Spreadsheets

• Creating, naming, and saving a spreadsheet
• Copying and re-naming a spreadsheet
• Moving a spreadsheet
• Deleting a spreadsheet
• Importing spreadsheets from Excel and OpenOffice
• Importing data files

3. Editing Spreadsheets

• Entering and editing cell data
• Inserting, deleting, and clearing rows and columns
• Moving or copying rows, columns, and cells
• Editing with Find and Replace
• Working with multiple sheets
• Creating a series of numbers, letters, or dates
• Inserting images or hyperlinks

4. Viewing Spreadsheets

• Freezing rows and columns
• Hiding rows, columns, and sheets
• Using filters and creating filter views
• Sorting data on a spreadsheet

5. Formatting, Printing, and Publishing Spreadsheets

• Formatting cells, rows, and columns
• Using conditional formatting
• Printing a spreadsheet

6. Working with Spreadsheet Data

• See the Sum, Average, Min, Max, or Count
• Using formulas and functions
• Using IF and nested functions in formulas
• Creating charts and graphs
• Using pivot tables
• Using the VLOOKUP function

7. Collaborating with Google Sheets

• Sharing a spreadsheet with other people
• Collaborating and commenting on a spreadsheet
• Working with spreadsheet revisions

Conclusion

• Additional resources