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 functionTake 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 shortcutsYou 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 timestampIf 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 codesQR 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 criteriaYou 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 ( ) functionThe 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 SheetsYou can access information from a website in your spreadsheet without needing to copy or paste through IMPORTHTML ( ) or IMPORTXML ( ).
8. Spot a languageGoogle has an integral language identifier. You can use the formula DETECTLANGUAGE ( ) and it will come back a two letter language cipher.
9. Interpret a languageGoogle 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 sheetWith 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.