Formulas Articles

Sometimes, you may want to quickly insert a timestamp in Google Sheets to mark when the activity was done. There are multiple ways of adding a timestamp in Google Sheets and in this tutorial, I

Google Sheets has really easy tools to use when it comes to sorting data. And these same tools can also be used when you need to sort by date in Google Sheets. Since a date

Watch Video – How to Color Alternate Rows in Google Sheets (with and without Conditional Formatting) In case you prefer reading over watching a video, below is a written tutorial for you. Google Sheets has

There are some times I wish Google Sheets had some more functionalities like MS Excel. One such functionality that isn’t available in Google Sheets is the ability to filter by color. For example, suppose I

In this tutorial, I will show you how to change text case in Google Sheets. You can convert any text into Upper case, Lower case, Proper case (also called the Title case), or Sentence case.

Google Sheets has been adding some great functionalities lately. It recently added a way to easily insert a checkbox (tick box) in any cell with a single click. Note that I will be using the

Watch Video – How to Transpose Data in Google Sheets (Using Formula and Paste Special) In this tutorial, I will show two ways to quickly transpose data in Google Sheets. Transposing the data means that

Working with date and time has become easy in Google Sheets thanks to some formulas. You can easily calculate the number of days between two dates by simply subtracting the dates (in case you need