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 PowerPoint to Google Slides

PowerPoint has long been the only slide making tool available to us. However, recently, a bunch of cool slide-making tools have come up. One of such service is Google Slides. The biggest benefit of Google Slides (or any Google App) is that you can collaborate with others at the same time. As some of us […]

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 Create Hanging Indent in Google Docs (in less than 5 seconds)

In this tutorial, I will show you how to create hanging indents in Google Docs. What are Hanging Indents? If you work with citations and/or quotations, you may need to create hanging indents to meet formatting guidelines. Hanging Indent means that the first line of the paragraph has an indent. Something as shown below: How to […]

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 >>

How to Add Page Numbers in Google Docs (Step-by-Step Guide)

Adding page numbers in Google Docs can be really in tracking the content. For example, you can use these page numbers to refer to content during presentations, calls, or while going through a printed copy. Without the page numbers, it could be a disaster if you jumble up the pages after taking a print out. In this tutorial, […]

Continue Reading >>

How to Get the Word Count in Google Docs [in less than 5 seconds]

Google Docs is an amazing word processor tool that allows you to write from anywhere or from any device. I write all my blog posts in Google docs and then move it to WordPress later. Using Google Docs means that I can write using my mobile phone when I am traveling, in a coffee shop, […]

Continue Reading >>
1 2 3 5