Welcome to Google Sheets Resources. Here you will find links to Google Sheets tips ranging from Beginner to Advanced. In addition, you find links to other Google Sheets training and help. These resource links were selected to provide you with the knowledge and skills you need to make the most of this powerful spreadsheet tool.
Tips
Level 1—Beginner tips
- 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
- Sheets Training and Help Center
- Sheets Cheat Sheet
- Sheets Productivity Guides
- Sheets Add-ons
- Sheets Accessibility Resources