Docs

Tips
Docs

Make Google Docs work harder for you with these tips

Tips

Drive
Gmail
Docs
OverDRIVE
Calendar
Sheets
Sites
Chrome
Contacts
Slides
Hangouts & Chat
Google Plus
Forms
More...

Sign in with Google

Or

We won't share your email address with any third-parties.
Please see our Privacy Policy for further information.

About Us

G Suite Tips is provided by the team at OverDRIVE. We’re passionate about G Suite and everything Google, so we’re delighted to share the latest insights, tips and tricks with you.

Join in

If you’ve got a top tip then share it. We’re all ears!
Suggest a Tip

Latest Tips

Translate languages in Google Sheets

Translate text from one language into another with this simple formula in Google Sheets Whether you’re a student studying a new language or a tourist encountering new words, the Google Translate formula in Google Sheets provides you with an easy access list of what you know, or want to know. To get started simply enter a word in one language in a cell, and then use the formula =GOOGLETRANSLATE(cell with text, “source language”, “target language”) in another cell to translate it. You can even drag the fill handle at the bottom of the formula cell down to apply this formula to more than one cell. Here’s an example, translating English words into Spanish: =GOOGLETRANSLATE(A2, “en”,”es”) This formula works for all languages supported by Google Translate. You’ll just need to know the 2-letter code for the language, which you can find in this list .
Create a GIF with your data

Bring your data to life with the Data GIF Maker by Google This handy free tool by Google allows you to make your data stand out. Start by choosing from three different GIF templates and bring your data to life. Whether you want to give your presentations the wow factor or add some life to your website, it’s really that easy to use. Follow these steps: Visit https://datagifmaker.withgoogle.com/ Simply choose from one of the templates Give your GIF a title Name your terms and add in the values You can choose whether to present your data in whole numbers or a percentage Preview your GIF then save You can also share your GIF via the link and make as many different ones as you like.
Bring your Google Photos to life

Displaying your Google Photos just got even better Use OverDRIVE to display your Google Photos in a fun slideshow, helping to bring your photos to life. And not only that, using OverDRIVE to display your photos means you can share your albums and photos with a large audience if you wish, instead of having to share your albums with individuals. OverDRIVE is a G Suite website builder (and is also the power behind G Suite Tips) so all you need to get started is your Google Drive and G Suite content and it’s even free to set up! Follow these steps: Sign in with Google on OverDRIVE Central Add a new site Create a new page > Google photos Choose whichever album you’d like to present Use the View drop down to see the variations of how you can present your photos Click > Save and voilà

Disclaimer

The Tools provided here are not supported under any standard support program or service. All Tools are provided AS IS without warranty of any kind.

Refractiv further disclaims all implied warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the Tools and documentation remains with you. In no event shall Refractiv, its authors, or anyone else involved in the creation, production, or delivery of the Tools be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the scripts or documentation, even if Refractiv has been advised of the possibility of such damages.

Show More Show Less

Convert Google Drive and
G Suite content into web pages automatically

Get Started

Android iOS Migration Scripts Security Admin Images Drive Gmail Docs OverDRIVE Calendar Sheets Sites Chrome Contacts Slides Hangouts Google Plus Forms More

Suggest a Tip