Google Spreadsheet Tricks & Tips You Probably Didn’t Know

110314-googlesheets-1-100528081-orig

You can do a lot of things that can facilitate your work using Google Spreadsheet, below you can find some tips and tricks you probably didn’t know about:

Using the =Image function

docs_01

It is of course a known fact that you are able to add images through a file upload in Google Sheets. However, a faster way to add images to your Google Sheets is through a formula of =image(“url”). In the parenthesis, put the link of the image from online in quotation marks. It’s a fairly easy formula to make use of and it can possibly save you a ton of upload time in the process.

Keyboard Shortcuts

docs_04

Keyboard shortcuts are the best way to stay productive. Find out all of the keyboard shortcuts at your disposal by making use of a keyboard shortcut. Command + “forward slash” (Mac) or “Control” + “Forward Slash” (Windows) brings up the ultimate list of shortcuts that will allow you to get things done in a snap.

More Currencies

docs_08

If you are working in finance or simply need to make a spreadsheet involving some money, this is the tip for you. If you need to access currency other than the US Dollar, simply highlight the cells, click the “123” button in the toolbar, and scroll to “More Currencies”. Click the currency you want and you’re done. Google Docs just became a bit more travelled!

Insert Google Sheets into Docs

 

docs_09

If you are an avid Google Docs user, you will find that your word documents will need to be placed in Google Sheets and vice versa. Doing this, however, is much easier and seamless than you think. With Charts, in the Google Chrome store, you are able to insert Google Sheets charts in Google Docs by opening the add-on “Charts” in your add-on menu, click “Load Data”, select, drag what data you’ll be using, and select “Insert”.

Gathering Data Easier

docs_10

If you are working on a project or need to make use of a survey to then gather information from spreadsheet, Google Forms its what you need. Easily sharable and even with the ability to be embedded on your website by going to “Forms” then “Create a Form”. From there, you can have individuals fill out their respective responses. Once your trials have ended, your data is added to the top of the spreadsheet for you to make use of.

Remove Blank Rows

Remove Blank Rows Add-On: Automatically delete all empty rows; This is helpful if you’re cleaning up a spreadsheet that wasn’t designed compactly. It will delete all the blank rows in a sheet, or the blanks within a range of cells that you select. Or, this add-on lets you hide the blank rows, so you can just see what a sheet looks and works like without them.

Power Tools Add On

110314-googlesheets-7-100528087-orig

This add-on includes six tools to help you edit spreadsheets faster. Some of their tasks: Remove characters, formatting or other elements; change the capitalizations of text, or formats of dates or other numbers; convert formulas between absolute and resolute; and split values in a column.

Stay tuned for more Google Tips & News!

Exeo Google Partner (1)

Don’t forget to Subscribe (On the right)

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Reach out

Re-Architect

This methodology requires the most effort to implement but it results in the most optimised recurring cost and will provide the best scalability for apps. This involves re-adapting the code of applications and the heavy use of SAAS solutions in order to replace existing hosted applications.

Re-Platform

This method utilizes the power of  PAAS services, like transferring a database to an as-a-service model,  the use of containers for some apps or the use of network/security functions as a service. Greater scalability and lower cost of operation is achieved.

Re-Host (Lift & Shift)

the migration of workloads from  to the cloud without changing the architecture. Machines get to keep their  OS and apps. This is the quickest and easy way to migrate, but since its  utilising IAAS, its is also the most expensive on the long term.