Google Tips and Tricks

10 Tips for Managing Shared Files on Google Drive

Much like Event and Appointment Slots, Reminder is just another option available to you when you're creating an item in Google Calendar. The coolest thing about Reminders is they carry forward to the next day, until you mark them done.

 

How to Print Your Google Calendar

The title of the post sounds simple enough, right? Surprisingly, this question comes up time and time again. Check out the post for the simple steps you need to take to print your calendar.

 

Have you ever wanted to insert a special character but couldn’t remember the name of the symbol? In Google Docs, Slides, and Drawings, here’s a great way to jog your memory. In these apps, there’s a trackpad you can use to draw the symbol. Sometimes all we can remember is what a symbol looks like, the names for symbols aren’t always the most memorable, like the symbol ampersand.

 

This functionality, coupled with the Information Rights Management (IRM) features launched last July, should significantly increase the security of your organization’s documents and information. There is no doubt about it; this is a major update to Google Drive security and a long requested feature 

 

From keyboard shortcuts to masking images, Google Slides has an impressive set of tools for all end users to learn to become a Google Slides artist. With these tips, you'll be creating amazing presentations just like a professional graphic designer!

 

Pasting in Google Sheets can become especially difficult when you want to paste a list or text that you want to separate into different cells. The former solution to separating text was with a script, but Google announced this week that you can now easily convert text to columns in Sheets with new paste formatting options.

 

9 Keyboard Shortcuts in Gmail That Will Make You More Productive

Did you know there are keyboard shortcuts specific to Gmail? Through a quick adjustment in the General settings tab, you’ll be whizzing through your email and will barely need to click your mouse. This post will show you how to get started with keyboard shortcuts by enabling them in your account while also going through some powerful productivity tips

 

In Google Spreadsheets, it can get repetitive adding one row at a time. With the right-click drop down menu, you are able to add multiple rows at once.

 

How to Share Individual Tabs In Google Sheets

As simple as it sounds, Google does not have a direct way to share individual tabs in Google Sheets. That does not mean it is not possible to do, you just need to get creative.

 

An Insert Comment button now appears in the Google Doc when you highlight any text in the body of the document. Previously, you had to click Insert > Comment. Now, a few steps are removed to make instant feedback, instant. 

 

After entering all the roles (in the correct format) in Google Sheets, you can turn them into an Org Chart with the chart creation tool. The chart will update dynamically as you modify the roles in the spreadsheet, so you don’t need to worry about starting from scratch when things change.

 

Building a Table of Contents in Google Sheets

Have you ever made a spreadsheet so large that you get lost in it? It is something that has happened to the best of us. While Google Sheets are a great format for recording and crunching data, they can be increasingly difficult to navigate the larger they get.

 

Knowing your schedule at all times is vital when reading and composing emails. If someone asks you to get coffee later this afternoon, you should know what times you are free. Obviously, you can open up your Google Calendar in another tab and check what events are on the horizon before responding, but wouldn’t it be nice if you could see this information right in Gmail?

 

The Send by Gmail Chrome Extension allows you to share a link with the click of a button. Once your Gmail account is connected, your shareable link is automatically pasted in a new message with the subject line and message complete. All you have to do is type in the recipient and click send. 

 

From generating Sudoku puzzles to organizing your Secret Santa gift exchange, there is a lot these add-ons can let you do beyond just number crunching. We put together our three favorite add-ons that increase morale more than productivity. Next lunch break, open up a Google Sheet and do something fun with it.

 

12 Free Add-Ons That Take Docs and Sheets to the Next Level

Aside from the three in the above post, here's another set of add-ons that will help you be even more productive. While these add-ons might not be as much fun in your personal life, they can make work easier (which is always fun!).

 

This tool is equally useful to both businesses and educational institutions. By filtering and sorting you can create spreadsheets that can be analyzed and understood at a glance, whether it is your department’s annual budget or your third-grade class attendance sheet.

 

 

 

 

 

 

 

5 hidden features in Google Apps that everybody should be using

Whether you are trying to ignore a group email thread that keeps popping up in your inbox or want real-time analysis of your Google Form results, there are tools that can help you out. Check out some of my favorite “hidden gem” features that are tucked away in Gmail, Forms, Calendar, Sheets, and Docs.