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
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 | |
|
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.
Google Workspace keyboard shortcuts
Get shortcuts for Google Workspace 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.
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.
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.
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
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
More resources
Visit the Sheets Help Center.
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.
