MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Significant tricks that you can use in Google sheets

Published on 15 April 17
Google Sheets is a free and the best tool for creating and modifying spreadsheets. It has a lot of features you may not know and they are assured to make you more prolific.

In this post, we will share some tips and tricks to use Google Sheets that will help you in saving time at work. Keep reading if you want to discover how to make the most of your information, in small time:

1. Employ SQL commands and the query function
Take benefit of the QUERY ( ) function in Google Sheets to begin to treat your tables such as databases where you can recover any figure depending on SQL code.
2. Keyboard shortcuts
You may be acquainted with a few shortcuts such copy and paste, but there are more authoritative commands available. Shortcuts that allow you move to the subsequent sheet and alter data layouts, for instance.
3. Take out only the date part of a timestamp
If you have a timestamp in your spreadsheet, then there is a simple way to take away the time data. Use the INT ( ) function to take out only the date part of a timestamp.
4. Develop QR codes
QR codes can be employed for various reasons – involving concert tickets, WiFi login, ads, and product purchases. Google Sheets allows you to produce QR codes with any input you akin to.
5. Lookup values depending on many criteria
You may be alert of lookup functions that let you find out based on single term. If you want to find out through multiple criteria, then you can employ the ARRAYFORMULAs.
6. FILTER ( ) function
The FILTER function lets you simply revisit values from a column that fulfills definite conditions. FILTER can only be employed to sort out rows or columns at single time.
7. Web accessing with Google Sheets
You can access information from a website in your spreadsheet without needing to copy or paste through IMPORTHTML ( ) or IMPORTXML ( ).
8. Spot a language
Google has an integral language identifier. You can use the formula DETECTLANGUAGE ( ) and it will come back a two letter language cipher.
9. Interpret a language
Google can notice a language, but also interpret or translate from one language to a different one.
The formula GOOGLETRANSLATE ( ) has three divisions – text to interpret, the present language, and the language you want to interpret.
10. Post data from Google sheet
With the help of a particular add-on, you may be able to post data from Google sheet.

We hope that these tricks will increase your output and make you a master of Google Sheets.
This blog is listed under Development & Implementations and Data & Information Management Community

Related Posts:
Post a Comment

Please notify me the replies via email.

  • We hope the conversations that take place on will be constructive and thought-provoking.
  • To ensure the quality of the discussion, our moderators may review/edit the comments for clarity and relevance.
  • Comments that are promotional, mean-spirited, or off-topic may be deleted per the moderators' judgment.
You may also be interested in
Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url