The more I use Google Sheets, the more I realize how powerful it is. And at the same time, there are some things that I wish were inbuilt into the
View our video tutorial: Sometimes you may have a need for Google sheets to keep refreshing themselves after a certain time interval. For example, if you’re tracking stock prices in
Watch Video – Remove Hyperlinks in Google Sheets Hyperlinks are quite useful in Google Sheets when you’re working with web page data. Or when you have links to files and
Those who switch from using Excel to Google Sheets often miss the fact that there is no in-built feature in Google Sheets to split cells diagonally. But if you still
Giving a name to your columns can be quite useful if you want to use these in the formulas. Instead of using the column alphabet in the formula, you can
We often feel the need to rearrange columns in our spreadsheet. Sometimes as an after-thought, other times, we might want to bring two columns next to each other to just
A big part of data analytics involves data cleaning. Well cleaned data is one that is free from incomplete, irrelevant, and redundant records. To remove redundancy, you need to get
Expressing quantities in percentages always helps give a better sense of proportion. It helps us visualize the quantity better in our heads and is great for making comparisons. It’s no
We often need to insert new columns when working with data in spreadsheets. When there are multiple columns that need to be inserted, it often helps to insert them all
