Google Drive and cloud-linked online office tools have little-known features that can increase user productivity and make life easier. Services such as Google Docs, Google Spreadsheets and Google Presentations provide functions that facilitate daily tasks, allowing you to find PDFs using text search, translate documents, generate QR Code and link different slide shows. Here are eight hidden features of the Google platform.
READ: Google reveals the most searched themes in Brazil in 2018
Eight useful and little-known Google Drive features Photo: Carolina Ochsendorf / dnetc
Want to buy cell phones, TV and other discounted products? Meet Compare dnetc
1. Find PDF by text in the search
Google Drive scans the text of PDF documents, so that they can be found using the text search tool. To do this, type in the Search in Drive field any word or term present on the desired PDF pages. The results will be flagged with the file format.
Google Drive allows you to find PDFs through text search Photo: Reproduo / Rodrigo Fernandes
2. Add typographic fonts to Google Docs
Google Docs allows you to add new fonts for use in texts. The service offers more than 800 typographic styles that are not available by default in the editor.
Step 1. Access the Source field and select the More Fonts option;
Google Docs allows adding new typographic fonts for use in texts Foto: Reproduo / Rodrigo Fernandes
Step 2. Choose the desired font from the list options and finish with the OK button.
Google Docs makes available more than 800 typographic fonts for use Photo: Reproduo / Rodrigo Fernandes
It is possible to translate complete documents into several languages directly on Google Docs. After translation, a new document will be created with the text in the new language.
Step 1. Access the Tools tab and then go to the Translate document … option;
Translating a document in Google Docs Foto: Reproduo / Rodrigo Fernandes
Step 2. Create a title for the new file, select the language into which the text will be translated and finish by pressing the Translate button.
Google Docs translates complete documents into several languages Photo: Reproduo / Rodrigo Fernandes
4. Add Google Sheets charts
You can import charts from Google Sheets files into Google Docs, including a link to the original file. You can size it as you like to fit the page and text format.
Step 1. Access the Insert tab, then Graph and then check the option Do Spreadsheets …;
Importing a Google Sheets chart into a Google Docs document Photo: Reproduo / Rodrigo Fernandes
Step 2. Choose the file containing the desired graphic and press the "Select" button;
Selecting a Google Sheets document to use in Google Docs Photo: Reproduo / Rodrigo Fernandes
Step 3. Finally, choose the graph and press Import.
Selecting a Google Sheets chart to send to Google Docs Photo: Reproduo / Rodrigo Fernandes
5. Generate QR Code in Google Sheets
Google Spreadsheets allows you to create QR Codes targeted to a specific cell in the spreadsheet. When being read, the QR Code will show the content of the informed cell.
Step 1. In an empty cell, type the following code:
- = IMAGE ("https://chart.googleapis/chart?chs=200×200&cht=qr&chl=" &CLULA& "")
In the highlighted field CLULA, include the reference of the cell that will have its content revealed by the QR Code. In the example below, the reference used was "B4". Note that the QR Code appears immediately on the spreadsheet.
Creating a QR Code in Google Spreadsheets Photo: Reproduo / Rodrigo Fernandes
6. Receive email notification of document changes
Google Docs has an option that allows the user to receive email notifications if changes are made to the spreadsheets. The useful feature for controlling shared files.
Step 1. Access the Tools tab and then go to Notification rules …;
Activating notifications of changes in Google Spreadsheets Photo: Reproduo / Rodrigo Fernandes
Step 2. Determine whether notifications will be sent with each change, or enable sending a daily report. Finish with the Save button.
Google Spreadsheets sends notifications by email notifying you of changes to the document Photo: Reproduo / Rodrigo Fernandes
7. Change the mouse cursor during presentations
Google Presentations allows you to change the traditional mouse cursor and insert a laser effect to point information on slides during a presentation.
During a full screen presentation, touch the Pointer icon in the bottom menu to activate the laser. To return to the normal cursor, simply touch the button again.
Google presentations can have a laser effect to point information on the screen Photo: Reproduo / Rodrigo Fernandes
8. Link different slides
The tool allows you to insert links to other slides that are in your presentation, facilitating the opening of previous information, without having to search for the content between the pages.
Step 1. Select the word or term to serve as a link and click the right mouse button. Then choose the Link option;
Google presentations can have links directed to other slides Photo: Reproduo / Rodrigo Fernandes
Step 2. In the Link field, select the Slides option in this presentation and enter the desired page. Finalize the configuration in Apply.
It is possible to create links to any slide in the Google presentation Photo: Reproduo / Rodrigo Fernandes
How to put text in two columns in Google Docs? Ask questions in the dnetc forum.
How to schedule beauty salon or barber shop through Google Maps