How to Use the SUBSTITUTE Function in Google Sheets
The SUBSTITUTE Function in Google Sheets is useful for situations where you need to replace existing text with…
How to Use TRIM Function with SPLIT in Google Sheets
The TRIM function in Google Sheets is a nifty little tool that is especially useful for cleaning up…
How to Use the DMIN Function in Google Sheets
The DMIN Function in Google Sheets is useful when you want to get the minimum value in a…
How to Highlight Cells Based on Multiple Conditions in Google Sheets
A few days ago, my wife and I were organising our yearly budget for the family. I was…
How to ROUND Numbers in Google Sheets
The ROUND function in Google Sheets is useful if you want to reduce a value by a specific…
How to Use COUNTIF Function in Google Sheets
The COUNTIF function in Google Sheets is useful if you want to count the number of times a…
How to Create a Line Chart in Google Sheets
The use cases for line graphs vary greatly and without a shadow of a doubt, it is one…
How to Use ISBLANK Functions in Google Sheets
The ISBLANK function is useful if you want to find out whether a cell is empty. Let’s take…
How to Insert Excel Table in Gmail with Borders
Occasionally you’ll want to insert an Excel table directly into your Gmail. Besides the fact that it looks…
How to Get Subscript and Superscript Values in Google Sheets
A few days back I was making some changes and adding data into a Google Sheet as part…