How to Create Named Ranges in Google Sheets (Static & Dynamic)
Named Ranges in Google Sheets can be used to define a cell or a range of cells and give it
Category: Google Sheets Tips & Tutorials
How to Quickly Insert Multiple Rows in Google Sheets
What do you do when you want to insert multiple rows in Google Sheets? Do you insert one row at
How to Rotate Text in Google Sheets (in less than 5 seconds)
Google Sheets has some great data formatting tools. One such formatting feature is the ability to rotate text within a cell
How to Count Cells If Not Blank in Google Sheets
Sometimes you may have a dataset where some of the cells or rows are blank. In such a case, if
Conditional Formatting Based on Another Cell Value in Google Sheets
In this tutorial, you will learn how to highlight cells using conditional formatting based on another cell in Google Sheets. This can be done using the custom function option in conditional formatting.
Creating a Heat Map in Google Sheets (Step-by-Step Tutorial)
A heat map is a good visual analysis layer to add to your data set to get some insights quickly.
How to Split Text to Columns in Google Sheets (with Examples)
Watch Video – How to Split Text to Columns in Google Sheets You can use the Split Text to Columns
How to Convert Excel to Google Sheets (a Step-by-Step Tutorial)
If you work with Google Sheets, there may be times when you have to convert Excel to Google Sheets. This
How to Create a Dependent Drop Down List in Google Sheets
A drop down list in Google Sheets can be used when you want to show a list of options and the
How to Insert an Image in a Cell in Google Sheets
Watch Video – How to Insert an Image in a Cell in Google Sheets Normally, the way people insert an
How to Use COUNTIF Function in Google Sheets
COUNTIF Function in Google Sheets can be used when you want to get the count when a given condition is
How to Quickly Merge Cells in Google Sheets
Watch Video – Merge Cells in Google Sheets When you work with data that has headers, sometimes, you may feel