Table of contents
Google Sheets is a free tool for creating spreadsheets. Google Sheets are particularly valued for enabling colleagues to work together on the same file. There is another secret feature which makes Sheets incredibly effective: add-ons. Think of add-ons as something like web browser extensions, but ones that are designed specifically for Google Sheets.
Spreadsheet as a calendar
This add-on helps you combine Google Sheets and Google Calendar. It allows creating events that can then be easily imported into Google Calendar. This is especially useful when creating work schedules. You can import up to 20 events at once in the free version, and up to 100 events in the paid version. This add-on lets you forget about the constant switching between Google Sheets and Calendar.
Advanced “Find and Replace”
“Find and Replace” is an add-on that lets you quickly and accurately modify spreadsheets. Making changes manually is not only time-consuming, but also prone to mistakes. The task of this function is to check the data in the cell, links and notes, and then replace the found information with the desired values.
Delete duplicates in spreadsheets
When working on a large amount of data in a spreadsheet, there is a risk that some content may get duplicated. Duplicates can lead to generating incorrect information and, in consequence, wrong conclusions. Searching for duplicate data manually would be incredibly time-consuming. By using Remove Duplicates, it is possible to remove duplicate content quickly and efficiently.
Power Tools for better work efficiency
Power Tools is a set of over 20 functions for Google Sheets. They allow performing specific actions in spreadsheets more efficiently – both simple and complex ones. Power Tools saves time and increases work efficiency. This add-on will work primarily during monotonous work and tedious repetition of routine activities such as changing the size of letters or adding up values in cells by colours.
Merge Sheets – learn to easily combine sheets
Combining data from two different sheets has never been easier. If you have at least one common column in both tables, the add-on will update current values for the same records and/or insert all the missing information. Merge Sheets plugin retrieves and analyses information from both documents and then transfers them to one without duplicating content.
These and other practical functions are presented during the Google Workspace training for companies that we organize online, in our office, or at the client’s premises. Contact us to schedule a free consultation, and don’t forget to grab an ebook with 101 Google Sheets tricks.
- Macros in Google Sheets – what is it and how to use them?
- TOP 10 tricks to help you make the most of Google Sheets