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

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 […]

Best Ergonomic Mouse to Use in 2017 (Buyer’s Guide)

[tcb-script type="text/javascript" src="//cdn.geni.us/snippet.js" defer=""][/tcb-script] [tcb-script type="text/javascript"] document.addEventListener("DOMContentLoaded", function() { var tsid =29769; Genius.amazon.convertLinks(tsid, true, "http://buy.geni.us"); }); [/tcb-script] Do you use a regular mouse or an […]

Best Ergonomic Mouse Pad To Use in 2017 (Buyer’s Guide)

[tcb-script type="text/javascript" src="//cdn.geni.us/snippet.js" defer=""][/tcb-script] [tcb-script type="text/javascript"] document.addEventListener("DOMContentLoaded", function() { var tsid =29769; Genius.amazon.convertLinks(tsid, true, "http://buy.geni.us"); }); [/tcb-script] If you're a heavy computer user you already […]

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 […]

LOAD MORE