Welcome to a special two-part edition of the Cobry Cafetiere of Cloud Knowledge. In the most recent episode, the Cobry team discussed all of our favourite Google Workspace productivity hacks. Turns out there are so many that we need 2 episodes to cover them all! From robust integrations to slick shortcuts, there are so many tricks that will enhance your day-to-day working life. So, here are some of our favourites – we hope you learn a trick or two!
Since Google Workspace is delivered entirely through the browser, there are a few URL tricks that you can use to make your life so much easier. A favourite shortcut amongst the Cobry team is the ‘.new’ shortcut which can be used to open a new tab in the app of your choice. Simply type the app you wish to use into the browser followed by ‘.new’ (For example, meet.new, docs.new…). This directs you straight to a new page on your chosen platform and enables you to get to work quickly without navigating through various pages.
When you open a new file in this way, it will automatically be stored in your My Drive. So, we recommend that you name and organise the file once you are finished using it to avoid your My Drive from becoming crowded and unorganised.
It is also possible to quickly change the format of a file by altering its URL. For example, you can create a copy of a document by changing the end of the URL from ‘/edit’ to ‘/copy’. Alternatively, you can download a doc as a PDF by changing the end of the URL to ‘/export/pdf’. These are both really simple hacks that you can use to eliminate extra steps and save yourself time while working!
Present Directly from Docs, Sheets & Slides
This is a new one and we already love it! We’ve all been guilty of having a few too many tabs open which results in a wave of panic when we try to find the one we want to present. Well, with the new feature available in Docs, Sheets and Slides, this is a thing of the past!
Google has added a button at the top right hand side of Docs, Sheets and Slides which you can use to cast that tab to a Meet call. Simply click on the icon and select the meeting you are currently in. Or, if you really want to be ahead of the game, you can select meetings later in the day to present that screen in. This means that when you and other guests join the meeting, you will already be sharing your chosen tab.
Tricks in Google Sheets
Google Sheets is full of wonderful features which can increase productivity and improve data analysis. It’s a tough choice, but two of our absolute favourites are the Data Clean functions and Filter Views.
Data Clean Suggestions
Google Sheets offers powerful data clean tools including clean-up suggestions and column stats which help you organise, standardise and clean raw data before you use it.
Clean-up suggestions help to identify errors such as extra spaces, duplication or inconsistencies as well as anomalies. Meanwhile, column stats provide insights into your data which enable you to identify any issues and understand what your data looks like.
How it works:
- On your spreadsheet, click data> cleanup suggestions.
- Cleanup suggestions will appear in the sidebar. Click on the exclamation mark (!) on each column to understand the detected suggestion. If you hover over a suggestion with your mouse, the related cells will be highlighted. A good note to make is that suggestions will be marked in green whereas detected errors will be red.
Filters can be used in Google Sheets to focus your work by displaying only cells that satisfy a certain condition. This allows you to display the data exactly as you want to see it without making changes to the original. Filter Views can also be saved and used again, meaning that you don’t need to spend time filtering each time you use the data.
How it works:
- On your spreadsheet, click Data > Filter Views > Create New Filter
- Sort and filter the data in your rows and columns by applying rules based on conditions, format or values included within the cells.
- Name and save your filter view to be used in the future
These tricks are only a drop in the ocean of amazing features you can use to increase your productivity in Google Workspace. Want to know more? Tune in next week for part 2 of Google Workspace productivity and collaboration tricks!
If you’d like to find out more about Google Workspace, get in touch!