Google Sheets training and help

Want to get more out of Google apps at work or school?  Sign up for a free Google Workspace trial

Sheets lets you handle task lists, create project plans, analyze data with charts and filters, and more.

Get Sheets: Web (sheets.google.com), Android, or iOS 

Sheets basics

Cheat sheets

Productivity guides

Tips

More resources

 

Learn Sheets basics

To take an online course on Sheets, enroll in Getting Started with Google Sheets through Coursera.

What online spreadsheet provider did you use before Google Workspace?

If you previously used...	Read this guide...
Microsoft Excel	Switching to Sheets from Microsoft Excel
Other online spreadsheet providers, or are new to cloud storage	Get started with Sheets What you'll learn: Create or import Add content Share and collaborate Print and download Access your calendar, notes, and tasks

Cheat sheets

Sheets cheat sheet

Need a quick reference for the Sheets basics you've learned? Download this cheat sheet.

Google Workspace keyboard shortcuts

Get shortcuts for Google Workspace products such as Chrome Browser, Gmail, Calendar, and Drive.

Templates

Project plan template

Try Sheets by copying and customizing this project plan template.

Productivity guides

Create dynamic project plans with Sheets

Need a quick way to divide work, assign tasks, track due dates, and receive status updates on a project? Track, update, and collaborate on project tasks with your team in a shared spreadsheet using Google Sheets.

Plan and hold meetings from anywhere

Learn how to prepare for, hold, and follow up after team meetings by using Google Workspace tools such as Calendar and Drive together.

Use AppSheet in your organization

Create dynamic mobile and web apps from Google Sheets.

Work with SAP data in Sheets

Find out how to export ERP data from SAP to Sheets.

10 Google Workspace tips to analyze data

Quickly gain insights into your data with tools such as Explore, pivot tables, rules, and more.

10 Google Workspace tips to clean up data

Reduce data-entry errors and find out how to prepare data for analysis.

10 Google Workspace tips for finance

Learn how to manage financial information, build financial models, work on proposals, and more.

10 Google Workspace tips to onboard team members

Organizations need to train and onboard new team members effectively. Use Google Workspace to create a simple way for employees to orient themselves on your projects and become productive fast.

10 Google Workspace tips to work with remote teams

If you work on a team that’s spread across the globe, use Google Workspace to keep people connected and to collaborate seamlessly.

10 Google Workspace tips for brainstorming

Whether you need a name for a new product or a different place for lunch, Google Workspace makes it easy to share ideas, get feedback fast, and collaborate with your team.

10 Google Workspace tips to go paperless

Reduce printing expenses and share more easily by moving your organization's tasks and processes online.

Get started with Tasks

Keep track of your daily to-do list, organize multiple lists, and track important deadlines with Google Tasks.

Google Workspace Solutions Gallery

Get ideas for solving common business challenges with Google Apps Script.

Switching to Google Workspace from SharePoint

Use Google Workspace solutions to collaborate with people.

Tips

Expand all  |  Close all & go to top

Level 1—Beginner tips

1. Access stored Drive files offline
2. Create document templates
3. See changes to Drive files and folders
4. Switch to a different version of your file
5. Share “Make a copy” links to your files
6. Share links to PDF versions of your files
7. Work with Microsoft Office files
8. Use shortcuts to create new files
9. Add checkboxes to spreadsheets
10. Get instant insights into your data

Level 2—Intermediate

1. Add images to spreadsheets
2. Add flowcharts and diagrams to files
3. Summarize your data with charts
4. Insert and edit charts in presentations
5. Present during a video meeting
6. Share content with multiple people
7. Email collaborators
8. Filter data in a spreadsheet
9. Protect content in a spreadsheet
10. See data changes with conditional formatting
11. Get notified about spreadsheet changes
12. Mark a shared file as final
13. Restrict sharing options on Drive files
14. Set an expiration date for file access
15. Transfer ownership of a file

Level 3—Advanced

1. Import data from another spreadsheet
2. Link to data in a spreadsheet
3. Move Analytics data to a spreadsheet
4. Use currencies in your spreadsheet
5. Add financial data to a spreadsheet
6. Search for data in a sheet with QUERY
7. Create and edit pivot tables
8. Automate tasks with macros
9. Split data into columns
10. Space table rows and columns evenly
11. Share a file publicly
12. Publish files as web pages
13. Manage large events in Calendar
14. Create digital sign-in sheets for events
15. Do more with add-ons and scripts

 

More resources

Visit the Sheets Help Center.

Sheets accessibility

How Google handles user information in the app

 

Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.