Formulas Articles

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

While formulas are awesome, there might be some cases when you want to convert formula to values in Google Sheets. Here are some likely scenarios when this might be needed: You want to copy and

Google Sheets makes life easy when it comes to doing some data slice and dice. It has tons of formulas and functionalities (some even better than the ones in Microsoft Excel spreadsheets). One such area