Google Sheets training and help
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
Learn Sheets basics
What online spreadsheet provider did you use before G Suite?
| If you previously used... | Read this guide... |
|---|---|
| Microsoft® Excel® | |
|
Other online spreadsheet providers, or are new to cloud storage |
What you'll learn:
|
Cheat sheets
Need a quick reference for the Sheets basics you've learned? Download this cheat sheet.
Get shortcuts for G Suite products such as Chrome Browser, Gmail, Calendar, and Drive.
Templates
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.
Learn how to prepare for, hold, and follow up after team meetings by using G Suite tools like Calendar and Drive together.
Find out how to export ERP data from SAP to Sheets.
10 G Suite tips to analyze data
Quickly gain insights into your data with tools like Explore, pivot tables, rules, and more.
10 G Suite tips to clean up data
Reduce data-entry errors and find out how to prepare data for analysis.
Learn how to manage financial information, build financial models, work on proposals, and more.
10 G Suite tips to onboard team members
Organizations need to train and onboard new team members effectively. Use G Suite to create a simple way for employees to orient themselves on your projects and become productive fast.
10 G Suite tips to build virtual teams
If you work on a team that’s spread across the globe, use G Suite to keep people connected and to collaborate seamlessly.
10 G Suite tips for brainstorming
Whether you need a name for a new product or a different place for lunch, G Suite makes it easy to share ideas, get feedback fast, and collaborate with your team.
10 G Suite tips to go paperless
Reduce printing expenses and share more easily by moving your organization's tasks and processes online.
Keep track of your daily to-do list, organize multiple lists, and track important deadlines with Google Tasks.
Tips
Level 1—Beginner
- Access stored Drive files offline
- Create document templates
- See changes to Drive files and folders
- Switch to a different version of your file
- Share “Make a copy” links to your files
- Share links to PDF versions of your files
- Work with Microsoft Office files
- Use shortcuts to create new files
- Add checkboxes to spreadsheets
- Get instant insights into your data
Level 2—Intermediate
- Add images to spreadsheets
- Add flowcharts and diagrams to files
- Summarize your data with charts
- Insert and edit charts in presentations
- Present during a video meeting
- Share content with multiple people
- Email collaborators
- Filter data in a spreadsheet
- Protect content in a spreadsheet
- See data changes with conditional formatting
- Get notified about spreadsheet changes
- Mark a shared file as final
- Restrict sharing options on Drive files
- Set an expiration date for file access
- Transfer ownership of a file
Level 3—Advanced
- Import data from another spreadsheet
- Link to data in a spreadsheet
- Move Analytics data to a spreadsheet
- Use currencies in your spreadsheet
- Add financial data to a spreadsheet
- Search for data in a sheet with QUERY
- Create and edit pivot tables
- Automate tasks with macros
- Split data into columns
- Space table rows and columns evenly
- Share a file publicly
- Publish files as web pages
- Manage large events in Calendar
- Create digital sign-in sheets for events
- Do more with add-ons and scripts
Need more help?
Visit the Sheets Help Center.
