There might be times when you want to know what weekday it is on a specific date. For example, you may want to know the […]
If you’re creating a timetable for students in Google Sheets, or just planning ahead, you may need to know when is the last Monday of […]
Google Sheets has some great date related formulas that can come in handy in many situations. In this tutorial, I will show you how to […]
A hyperlink allows you to quickly access an external webpage or a file/folder in your system. These are widely used in web-pages to link to […]
If you work with huge datasets in Google Sheets, sometimes, it may get difficult to identify some data points. For example, if you have a […]
Google Sheets has some useful functions that are not available in Excel (such as IMPORTRANGE, QUERY, IMPORTDATA, etc.) One such extremely powerful one is the […]
OR function is useful when you want to evaluate a set of conditions. It will return TRUE when any of the conditions being checked are […]
There are a couple of useful functions in Google Sheets that will quickly calculate the number of days between the two specified dates. This kind […]
IMPORTDATA function is Google sheets allows you to quickly import the data from the URL of a .csv (comma separated value) or .tsv (tab separated value) […]
Do you want to import the data from other Google Sheets into the one in which your working currently? You can do this easily using […]
If you work with formulas in Google Sheets, you would know that errors can pop-up any time. While getting errors is a part of working […]
Watch Video – How to Freeze / Lock Rows and Column in Google Sheets You may want to freeze/lock rows in Google Sheets if you’re […]