Produtivity Spot

Productivity Spot is a blog where I share useful Google Apps tips. I am a spreadsheet geek and I primarily focus on sharing Google Sheets tips with my readers. I often also share tips on other useful tools such as Google Docs, Google Slides, MS Word, and PowerPoint. The blog is targeted towards educators and small business owners to help them become more efficient in using these common tech tools.

Produtivity Spot ranking

This blog ranks #44 in our Top E-Learning Blogs.

Copy and paste this code into any part of your blog to get a dynamic badge that automatically updates your rank every day.

Posts by Produtivity Spot

Best Mini Projector Under 100 Dollars (2017 Buyer’s Guide)

​Throughout modern history, projectors have served a pivotal role in many firms and companies as they are used in everyday operations in organizations. However, some […]

How to Search in Google Sheets and Highlight the Matching Data

If you work with huge datasets in Google Sheets, sometimes, it may get difficult to identify some data points. For example, if you have a […]

Using FILTER Function in Google Sheets (explained with Examples)

Google Sheets has some useful functions that are not available in Excel (such as IMPORTRANGE, QUERY, IMPORTDATA, etc.) One such extremely powerful one is the […]

How to Use OR Function in Google Sheets (with Examples)

OR function is useful when you want to evaluate a set of conditions. It will return TRUE when any of the conditions being checked are […]

Calculate the Number of Days Between Two Dates in Google Sheets

There are a couple of useful functions in Google Sheets that will quickly calculate the number of days between the two specified dates. This kind […]

How to Use IMPORTDATA function in Google Sheets

IMPORTDATA function is Google sheets allows you to quickly import the data from the URL of a .csv (comma separated value) or .tsv (tab separated value) […]

How to Use IMPORTRANGE Function in Google Sheets (with Examples)

Do you want to import the data from other Google Sheets into the one in which your working currently? You can do this easily using […]

Using IFERROR Function in Google Sheets (with Examples)

If you work with formulas in Google Sheets, you would know that errors can pop-up any time. While getting errors is a part of working […]

How to Quickly Freeze / Lock Rows in Google Sheets

Watch Video – How to Freeze / Lock Rows and Column in Google Sheets You may want to freeze/lock rows in Google Sheets if you’re […]

Using IFS Function in Google Sheets to Test Multiple Conditions

In Google Sheets, you can use the IFS function to test multiple conditions at once and then return the result based on it. The difference […]

Best Ergonomic Office Chair Under $200 (Buyer’s Guide 2017)

Most office jobs nowadays involve a lot of sitting down and working on a computer all day. This promotes an unhealthy sedentary lifestyle, which is […]

How to Create a Drop Down List in Google Sheets

A drop down list in Google Sheets can be helpful when you want the user to select from pre-defined options. It’s a great way to […]