Sheets were structured in light of the requirements of coordinated associations. Computer-based intelligence highlights the means of taking advantage of the correct experiences to settle on essential business choices. A cloud-based design empowers you to work together with anybody, whenever and wherever. Here are eight simple and helpful tips on using Google Sheets:
Google Sheets have a lot of formulas you could use, especially in universities or business corporations; however, some of those formulas in Google Sheets are unfamiliar to several people. Also, those new current employees don’t know how to use it properly, and even the purpose of every method. But Google Sheets is necessary for each company, which is why learning the primary usage of the platform is recommended. Google Sheets is not overall challenging to understand because it has simple functions that are easy to use. This is the perfect time to learn more about formulas in Google Sheets.
For the past few years, there’s a massive increase in how entrepreneurs depend on data. It looks like some of the businesses are tracking their data with the use of different Data Trends nowadays. It helps them learn how to improve their business as well as the know-how. Analytic tools also trend today; they can analyze the data of a company and predict what is likely to happen.
8 Google Sheets Tricks
Tip 1: Adding heatmaps with conditional formatting
Heatmaps help draw your attention to the essential data indicated in your sheets, as well as using functions to help you identify the trends in your data.
- Highlight a particular value, outline, or error in your sheets, then right-click, at the bottom of the dropdown menu, click the “Conditional Formatting.”
- After clicking the “Conditional Formatting,” another window telling “Conditional Format Rules” will appear. Now, two rules will appear here: the “Single Rule” and “Color Scale.” Single Rules mainly focus on one value, and Color Scale value shows the scale of each value.
- Then, for you to set the value, click Min Value, Midpoint Value, and Maximum Value and set all of these in numbers so that it will identify its value.
- After you set the values, there will appear different colors where dark color shows the Minimum Value or the Least value, and the lightest one shows the Maximum Value or the Highest Value.
Google Sheets Tip 2: Send emails when you comment
You can put a comment on a particular cell and tag a specified person if you need to ask a question. By doing this, the person you mentioned or shared the file with will receive an email that serves as a notification of your comment.
- Right-click the cell you want to leave a comment on and click at the dropdown menu near the bottom click “Comment.”
- Another window will appear after you clicked the “Comment.” After that, a pop up will appear. Inside that pop-up, type what you want to comment on the text box, and put a “+” sign to tag a particular email address and send them emails.
Tip 3: Check for validation of email
If you have a list of emails and you want to confirm them, you can use “isemail” in Google Sheets. It won’t work if the given email addresses are invalid. It is, therefore, necessary to validate the emails before sending them.
To validate an email, click any cell that is containing an email address of a particular person to confirm if the email is valid or not. The formulas you will be using is “isemail.” Isemail will determine if the email is correct or not; it will be stating TRUE or FALSE, where true means the email is valid and false means invalid.
Some of the emails become invalid because of the wrong URL in the email. These will help you to identify errors in emails and prevent you from not sending such emails.
Google Sheets Tip 4: Visualize data with sparklines
Sparkline’s use is to present a visual presentation of the data in charts and graphs. It is the most straightforward way of showing visual displays in Google Sheets. Using google sheet sparkline feature, helps you gain insight into data, and it’s particularly important for digital marketers as it aids them in refining their content plan to market their business well. You can also view the changes in your data without creating an actual chart, which can be considered a hassle by most employees.
- Select any cell where you want your sparkline to appear. And then, type “=sparkline” and select enter.
- Then, all you have to do is to highlight the area that you want the cells to include different data like numbers, currency, etc. and then select enter.
Tip 5: Use Data Validation to create a dropdown list in a cell
Creating a dropdown list with Data Validation is one of the best ways to determine a particular cell by indication of choices. The common purpose of the dropdown list is to make a list of options or items that will identify a specific cell.
- First, highlight the cells that you want to include in your dropdown list.
- Now, click “Data” on the menu tab of Google Sheet, then click the “Data Validation” from the dropdown list.
- Then click the “Data Validation,” there’s a window that will appear named “Data Validation” from that window, from the Criteria at the right side of that there’s a dropdown list, and from that list click “list of items.”
- Type what you want to be in your dropdown list in the text box.
- Then click the “save” button, the dropdown will appear in the cells you chose, then click the dropdown for you to see the lists.
Google Sheets Tip 6: Translating text
If your Google Sheet is containing different languages, you can use the “Google TRANSLATE” function to translate the words or texts you want to translate. In cases where your Google Sheet is publicly exposed and you have a lot of clients or participants with different languages, you can easily convert those words or languages immediately with the “GOOGLE TRANSLATE” formula.
- First, type “=GOOGLETRANSLATE” and select to enter.
- Next, entered the “GOOGLE TRANSLATE,” click the cell you want to translate. Then select enter. Sometimes, to bring a word or phrase, it takes time, but it won’t take a long while.
Google Sheets Tip 7: Change capitalization in the cells
In changing the capitalization of the words and phrases in the cells, there are three functions you could choose: Proper, Upper, and Lower function. These options allow you to apply different capitalization to your text in your sheets.
- There are three types of Capitalization: PROPER, UPPER, and LOWER. Just type “=PROPER,” “=UPPER,” or “=LOWER.”
- For proper function, it makes the word or phrases standard or formal sentence like making the first letter of a sentence capitalized.
- Then, click the cell with the capitalization that you want to change and then select enter. You can choose any of the mentioned functions, whichever you prefer.
- The upper function allows you to change the capitalization of your text in uppercase. It’s just the same process as to how it is done in the Proper function; however, the purpose is different.
- The lower function allows you to change the capitalization to lowercase. It also has the same process with the other two services.
Tip 8: Protected data cells
If lots of people are working on a sheet, then you might want to lock down some of the data to prevent mistakes. Protecting data cells allows you to enclose the data in the cells and lock it, enabling the protection of your data, so that no one will be able to edit it.
- Highlight the cell/s you want to protect.
- Then, from the menu bar, click “Data.” After you click it, a dropdown menu will appear. Click the “Protected Sheets and Ranges.” You may choose from these options and click whatever you prefer.
- Once you type what you want to say in the cells or ranges, you will be able to seal it and put something in a description box for the protected cells. Then, click “Set permission.” After you click it, there’s another window that will pop-up. It will show you that there are two options to set the permission.
The use of the first option is: if somebody tries to change the range you protected. There will be a pop-up, or in other words, “a warning” that will appear if someone tries to edit it. The second option’s purpose is to enable you to select the whole range you protected. Click “Done” after choosing what kind of permission you want.
If you want to see the ranges that you protected, click “View” from the menu bar and its dropdown list. Click “Protected Ranges.” There will be stripes that will appear in the ranges you protected, showing that this is the range you sealed.
Google Sheets Tips Conclusion
Google Sheets platform has so much in store to make your organization of files more accessible. However, it is recommended to practice while reviewing these tips. These are some simple but helpful tips for those who want to use Google Sheets. I hope these tips will make learning Google Sheets much easier.