Google Sheet Tips

Keep track of changes to Drive files and folders
Description If you have a lot of collaborators, it's important to keep track of changes to your files. In Google Drive, the activity stream show...
Tue, 30 Jan, 2018 at 11:36 PM
Create and edit pivot tables
Description Pivot tables help you summarize data, find patterns, and reorganize information. You can add pivot tables based on suggestions in Google ...
Tue, 30 Jan, 2018 at 11:38 PM
Get automatic spreadsheet formulas
Description Add formulas faster and easier. Instead of searching for the formula you need and adding it manually, let Google Sheets add it for you with ...
Tue, 30 Jan, 2018 at 11:40 PM
Create customized groups of data in a pivot table
Description In a pivot table in Google Sheets, you can group data to get a different view. For example, say you have a pivot table showing total sale...
Tue, 30 Jan, 2018 at 11:41 PM
Get instant insights into your data
Description A spreadsheet full of data can be daunting. Get summaries and charts of your data with the click of a button in Google Sheets. It’s kind of ...
Tue, 30 Jan, 2018 at 11:43 PM
Filter spreadsheet data without changing what collaborators see
Description If you're looking at a spreadsheet with other people, create a filter view that only you can see. Examples Working with collaborat...
Tue, 30 Jan, 2018 at 11:44 PM
Split data into columns
Description When copying and pasting data into spreadsheets, sometimes the data doesn’t separate neatly into columns. In Google Sheets, if you have com...
Tue, 30 Jan, 2018 at 11:46 PM
Do more with add-ons and scripts
Description Use ready-made add-ons to do more with Gmail and Google Docs, Sheets, Slides, and Forms. You can also create your own scripts in any of the ...
Tue, 30 Jan, 2018 at 11:48 PM
Summarize your data with charts
Description Summarize data with charts in your spreadsheet. Examples Make your data visual so that others can understand it quickly. Create chart...
Tue, 30 Jan, 2018 at 11:50 PM
Manage large events in Calendar
Description Organizing an event with a lot of attendees? Use Google Calendar and Google Sheets to effectively manage events of any size. When you create...
Tue, 30 Jan, 2018 at 11:52 PM