What is Google Sheets?
What is Google Sheets?
Google Sheets is an online spreadsheet program capable of doing almost everything a typical spreadsheet program like Microsoft Excel is capable of doing without having to download any software.
Features include text formatting, formulas, charts, scripting, and collaborative editing for sharing between computers, devices, and other users.
Supported file types: .xls, .xlsx, .xlsm, .xlt, .xltx, .xltm .ods, .csv, .tsv, .txt, .tab
How to use Google Sheets
How to use Google Sheets
Tips and Tricks
Tips and Tricks
Level 1—Beginner
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
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
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
King's Education