Google Sheet: 7 tips to be an expert

As you know, G Suite has an endless number of applications that help facilitate tasks and optimize time at work. On other occasions, we also made posts about Calendar, Gmail and Drive File Stream. Today is your turn to become experts in Google sheets and discover several tips that will not only facilitate its use but will also allow you to get much more out of it.

What is Google Sheets?

Google Sheets, is the application of google spreadsheets and is part of G Suite application package. They stand out for being ideal for collaborative work, they are secure and work perfectly for dynamic organizations.

7 tips for Google Sheets

1. Talk to your colleagues within the Google Sheets document itself

One of the main advantages of collaborative work of Google Sheets, is that since all team members have G Suite, they will not only be able to chat with each other live in the same spreadsheet, but they can also observe the changes are doing in it.

2. Share the spreadsheet with your colleagues

As we already mentioned, one of the main functions that GSuite has is collaborative work. Sharing spreadsheets with your coworkers is really simple. Just by clicking on the top right from the computer, where it says «Share«, we can choose who can access, view and even edit our document.

3. Activate full screen mode

By activating the full screen option in the menu, it will be possible to concentrate only on the cells and thus be more productive, avoiding any distraction that may arise. To do this, you should go to View > full screen.

4. Insert images into spreadsheetsulo in a very simple way

Inserting images into your sheets is truly child's play, just by using the formula =image(«image url») We can insert images from any web link.

5. Access previous versions of your file

Have you ever gotten involved with numbers after spending hours doing calculations? To the point of not even understanding your own calculations?

Quiet, Google Sheets It has a function that allows you to see previous versions of the file and in this way not only verify the modifications, but also see how the work has evolved. To do so, you just have to go to the top right of the file and click on «Last modification«.

6. Work offline

There is no need to worry if the connection is lost, Google Sheets allows you to continue working on the file and once the connection returns, the changes will be saved automatically.

7. Discover new functions thanks to key combinations

Keyboard shortcuts allow you to work quickly and better familiarize yourself with the Google Sheets interface, you can find them in Menu Help > Key combinations, or else by pressing Ctrl+/ on the keyboard.

Do you want to have G Suite?

If you have decided to use Google Sheets, making the most of it with the G Suite professional application package, you can hire it on our website. If you have any questions, do not hesitate to contact us.