Sheets: Beginner tips
Learn these beginner tips for Google Sheets.
- Access stored Drive files offline
- Create document templates
- See changes in Drive files & folders
- Check or revert to earlier file versions
- 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
Sheets: Intermediate tips
Learn these intermediate tips for Google Sheets.
- Add images to spreadsheets
- Add flowcharts and diagrams to files
- Summarize your data with charts
- Insert and edit charts
- Share content with a group
- 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
- Present during a video meeting
Sheets: Advanced tips
Learn these advanced tips for Google Sheets.
- 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