Category Archives for Google Sheets Tips

Conditional Formatting Based on Another Cell Value in Google Sheets

Conditional Formatting Based on Another Cell in Google Sheets - multilple result

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.

Continue Reading >>

Creating a Heat Map in Google Sheets (Step-by-Step Tutorial)

Heat Map in Google Sheets - Example

A heat map is a good visual analysis layer to add to your data set to get some insights quickly. For example, if you have students marks in columns, you can use a heat map in Google Sheets to identify students who failed or students who scored above 90. Similarly, if you have sales data, […]

Continue Reading >>

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 in Google Sheets to quickly split the contents of a cell (or a range of cells). Split Text to Columns in Google Sheets Split Text to Columns feature comes in handy when you want quickly […]

Continue Reading >>

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 allows you to collaborate with others and benefit from the powerful features of Google Sheets. There are a couple of ways to convert Excel to Google Sheets: Convert by importing an Excel file to Google […]

Continue Reading >>

How to Zoom In and Zoom Out in Google Sheets

One of the basic features that is missing in Google Sheets (at least at the time of writing this article) is that ability to Zoom In and Zoom Out in Google Sheets. That’s one point to the Microsoft Excel team! Now, since there is no option to zoom in Google Sheets, how can we avoid […]

Continue Reading >>

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 user can select from it. It helps in speeding up data entry and makes it more reliable. In real life, there would be a need to create a dependent drop down list where the once […]

Continue Reading >>

Leave Tracker Template in Google Sheets

Looking for a leave tracker template in Google Sheets that can track leaves of your employees or students? You’re at the right place. In this post, I am sharing one of my best templates – the leave tracker template in Google Sheets. Click here to access the leave tracker template [You will have to make a […]

Continue Reading >>

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 image in a cell in Google Sheets is by going to Insert –> Image and the selecting the image or specifying the URL. The issue with this method is that it treats the image as […]

Continue Reading >>

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 met. For example, if you have a list of students and you want to quickly get the count of all the students who have scored above 75, then you can use the COUNTIF Function in […]

Continue Reading >>

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 the need to merge cells in Google Sheets. For example, if you have a main header as Revenue and subheaders as 2016, 2017, and 2018, you can merge the three cells that make up […]

Continue Reading >>
1 2 3