Translate languages in Google Sheets

Tips
Sheets
Translate languages in Google Sheets

Tips

Drive
Gmail
Docs
Overdrive
Calendar
Sheets
Sites
Chrome
- How to remove the Reading list button from Chrome
Contacts
Slides
Chat
Meet
Forms
Keep
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 Google Workspace and everything Google, so we’re delighted to share the latest insights, tips and tricks with you.

Latest Tips

Give your Google account a security checkup

As a Google Workspace user, your Google account is directly connected to apps such as Drive, Gmail, Contacts and more, as well as any mobile devices you might use for work. This is why it’s important to run a security checkup regularly and fix any issues on your account as soon as they arise. Running a Security Checkup is the easiest way to identify any outstanding issues and suspicious activity on your account. Here’s how to do it: Log into your account and go to the Security Checkup page . Go through each security category and review the information. Google will highlight any recommended actions but it’s worth going through any recent activity even if it’s not highlighted on this page. Click the dropdown arrow to see the details from each category. It’s especially important to check your devices and the list of third-party apps that have access to your account. If you see any suspicious devices that you don’t recall using, sign out and change your password. You can also use this to sign out of any devices that you’re no longer using. Finally, perform a Password Checkup to find out if any passwords saved in your Google Account have been compromised. Change any compromised passwords and consider using strong unique passwords for each account. This is just a quick security checkup of your account but keep in mind that wider vulnerabilities can exist within your organization. To enhance security we recommend adding an extra level of protection with dedicated security add ons and backup solutions .
How to share your Google Calendar with others

Here’s how to share your Google calendar with your colleagues or people from outside your organization. To share your calendar with specific people: Open Google Calendar and find yours in the left side panel. Hover over it and select Settings and sharing. Alternatively, you can go to Settings (cog icon - top right) and then select your calendar from under Settings for my calendars. Scroll down to find the Share with specific people option. Click on Add people and enter their email address. By default, you can add people from outside your organization, but your administrator can turn off this option. Select the level of permissions you want them to have. Use caution when granting the highest level of permissions because the person you’re sharing the calendar with will be able to make changes to your events and even delete your calendar. The different levels of permissions are explained below. 6. Click Send. The recipients will receive an email with a link to accept the invite and to add the calendar to their list. Google Calendar permissions explained: See only free/busy information (hide details) They can view when your calendar is booked and when it has free time, without seeing any details about your scheduled events, including the titles of your meetings and who’s invited. See all event details The people you’re sharing the calendar with can view the details of all events, with the exception of those marked by you as private. Make changes to events People can view and change all events, including those set to be private. Make changes and manage sharing They have the same rights as you, the owner of the calendar. Anyone who has this level of permissions can create new events and edit the existing ones, respond to invitations, share your calendar with others, receive email notifications about changes to your calendar and even delete your calendar.
Euro 2020 Google Sheets Sweepstake

The Euro 2020 Sweepstake is a fun way to predict match outcomes, compete with your family, friends or colleagues and add to the excitement of the tournament. The spreadsheet will automatically calculate the points for each player so you can see at the glance who’s in the lead. Here’s how to use our Euro 2020 predictions template in Google Sheets: Make a copy of our Sheet . Personalise the sheet with player names. Fill in match predictions and keep on top of who’s winning! The sheet uses Protected Ranges to add some restrictions: A protected range across columns A to F so you have control of the matches and results. A protected range in the user header cells so only you can add users and Points cannot be changed. We recommend adding the following to your own sheet: A protected range per user column - so only the user can add their predictions. Protect each prediction once it is final by adding a protected range called “Lock in Predictions” across the user columns. You can do this after the matches have started to stop people changing their predictions. To add a Protected Range: Select the range or column. Right click and select Protect range. From the right hand panel, click Set permissions. From the pop up window you can choose who can edit that specific column. Remember to update fixtures and result as results come in. You can also add extra player columns, but make sure to also copy the formulas from any existing “Player” column. Have fun!

Powered by Overdrive

Tips
Tools
Services
- Development
- Training
Add-on Apps
Blog

Translate languages in Google Sheets

Translate languages in Google Sheets

Give your Google account a security checkup

How to share your Google Calendar with others

Euro 2020 Google Sheets Sweepstake