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

CES 2018 Launches: 5 tools for enhanced productivity

Technology has become ubiquitous in our lives. Twenty years ago who would have thought we will make payments, call a cab, be connected to work […]

How to Create and Use Filter Views in Google Sheets

Watch Video – Creating and Using Filter Views in Google Sheets Google Sheets has this amazing functionality to collaborate with other users. However, one issue […]

How to Create a Table of Contents in Google Sheets

Inserting Table of Contents can be useful if you have a lot of content and you want to quickly skip to relevant sections. If you […]

5 must-haves for maximum productivity at home office

Productivity is self-driven and self-directed.  Whether you are a freelancer or a full-time employee, you will agree that productivity requires more than self-discipline and a […]

Google Sheets Weekday Function – Explained with Examples

There might be times when you want to know what weekday it is on a specific date. For example, you may want to know the […]

How to Get the Last Monday of the Month in Google Sheets

If you’re creating a timetable for students in Google Sheets, or just planning ahead, you may need to know when is the last Monday of […]

Calculate Age in Google Sheets (using the Date of Birth)

Google Sheets has some great date related formulas that can come in handy in many situations. In this tutorial, I will show you how to […]

How to Create Hyperlinks in Google Sheets (Step-by-Step Guide)

A hyperlink allows you to quickly access an external webpage or a file/folder in your system. These are widely used in web-pages to link to […]

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