Click For Photo: https://static.makeuseof.com/wp-content/uploads/2018/11/google-sheets-tricks-994x400.jpg
Google Sheets is a popular Microsoft Excel alternative. As with other Google tools, the Sheets is a core part of Google Drive. In this article, we have taken the liberty to dive deep and unearth a handful of super useful Google Sheets tricks that you may have never heard before.
These Google Spreadsheet tricks are simple enough to learn and remember.
Situations - Calculators - Exchange - Conversions - Harm
We have all come across situations where we need third-party calculators for exchange conversions. While there is no harm in doing so, it is a tedious way of getting stuff done. Google Sheets offers built-in currency conversion features that will help you convert from one currency to another in a jiffy. Let us see how to use this feature.
Use the following syntax:
Currency - Symbol - Currency - Currency - Symbol
Let’s break it down. The “from currency symbol” is the base currency that you want to convert. The “to currency symbol” is the currency that you want to convert the initial value to.
As an example let us convert the Indian price (in INR) for the latest iPhones into USD. So the syntax shapes up as follows:
Ensure - Currency - Symbol - Conventions
Ensure that you don’t use the actual currency symbol and instead stick to the three lettered conventions.
Spell Check is an everyday feature that helps you keep the spreadsheet free of spell-errors and typos. It is tiresome to spellcheck manually. In such cases, it is always better to rely on Google’s inbuilt spell-check feature and manually correct any discrepancy.
Word - Caution - Spell - Check - Feature
A word of caution, it is not wise to completely depend on the Spell Check feature. So, make sure you give it a second look before the change.
Thanks to the Internet the international boundaries have shrunk. Just imagine this, you have just received a quotation in a foreign language. Translating every cell will involve a lot of donkey work. Google Sheets has got you covered with the Translate...
Wake Up To Breaking News!