Google Sheets is an online spreadsheet manager within the Google Drive platform. Its interface and overall features are similar to Microsoft Excel, with the advantage of being able to be used by the browser or cell phone and have the data saved in the cloud.
In addition to the most basic options for managing spreadsheets, Google Sheets has a huge range of built-in functions, ranging from data import and synchronization to math and engineering formulas. Check out some of the “unknown” functions of the platform below.
Google Sheets: language translation
To me, Google Translate is one of the greatest feature in Google Sheets. It is possible to translate selected cells into other languages within the spreadsheet itself. Just type the command =GOOGLETRANSLATE to open the options. By just selecting a cell, the system itself automatically translates to the source language of the Google account .
Google Sheets: generate QR Code
Google Sheets makes it possible to create a QR Code image in a spreadsheet. To do this, create a different column, preferably with the name “QR Code”. In that column, enter the command =image(“https://image-charts.com/chart?chs=250×250&cht=qr&choe=UTF-8&chl=”&ENCODEURL(A2))
In the case of the example, A2 was used. But you can – of course – change it to whatever you want.
Google Sheets: unit converter
Another very useful function is the unit conversion. The possibilities are almost endless: measurements of time, temperature, weight, distance, energy…. To do this, type the command =CONVERT in a cell. Then enter the Cell in which you have the number you want to convert, the current unit of measurement and the unit to which you want to convert.
Google Sheets: stock price
Spreadsheets are very useful in the financial market. If you are using the manager and need to check the value of a company’s stock currently or on a certain day, you can do so using the integration with Google Finance. Just type the command = GOOGLEFINANCE, the financial security code and, if you want, the start and end dates.
Google Sheets: Import data in HTML or XML
The HTML and XML markup languages are the most common used in the programming of pages over the internet. If any list or table on a website is configured in HTML, Google Sheets can import this data. The command for this is =IMPORTHTML, followed by the URL, the table or list demarcation and the order on the page.
Google Sheets: Generate charts
For a better visualization of the data of a spreadsheet, Google Sheets allows to create graphs within the platform itself. To do this, go to “Insert”> “Graphics”. The platform will show a side window in which it is possible to configure all the information. Styles vary between line, bar, column and pie charts.
Google Sheets: mathematical functions
You can set the calculator aside: Google Sheets has a number of mathematical and statistical functions. When selecting them, the system performs the operations directly on the spreadsheet. To learn more about each one, open the “Insert” tab and then go to “Functions” to see the complete list.
Google Sheets: record macros
Do you have an operation that you learned from that list or that you are used to using frequently on Google Sheets ? It is possible to save it and turn it into a shortcut. Go to “Tools”> “Macros”> “Record Macros”. The manager will now record the commands used. This way, there is no need to repeat codes and the process is simplified.