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 #93 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 Delete Every Other Row in Google Sheets (Easy Formula Trick)

The Google Sheets filter is a powerful tool that can help you manipulate how your spreadsheet data displays nondestructively. For example, you can use this […]

How to Make a Bell Curve in Google Sheets?

A bell curve is a useful graph for comparing how data points compare to the rest of the data. I am sure you have heard […]

How to Convert Time to Military Time Format in Google Sheets?

Google Sheets features a built-in time formatting tool that makes converting between 12-hour time and military time, also known as 24-hour time, a breeze. This […]

How to Import and Open CSV File in Google Sheets?

Comma-separated value, or CSV, is a non-standardized plain text data file format used to store and exchange tabular or spreadsheet information. While CSV files omit […]

How to Round Numbers in Google Sheets? (ROUNDUP/ROUNDDOWN)

Google Sheets makes it easy to round numbers. It features several functions that can accommodate a wide-range of rounding. Whether you need to round to […]

How to Use SWITCH function in Google Sheets?

The SWITCH function in Google Sheets is a helpful tool for changing how a cell behaves based on the value in another cell. It’s incredibly […]

How To Calculate Weighted Average In Google Sheets (AVERAGE.WEIGHTED)?

You can calculate weighted averages in Google Sheets by using a built-in formula: AVERAGE.WEIGHTED. Weighted averages are useful for calculating average scores when some factors […]

How to Print Labels from Google Sheets (For Free)?

Google Sheets can be a helpful tool for pulling information into consistent printed labels. However, Google Sheets doesn’t include the capability to print labels. Instead, […]

How To Recover Deleted Google Sheets Files

Recovering deleted Google Sheets is a straight-forward process – thanks to Google Drive integration. It can be very startling when you realize you need information […]

How To Format Phone Numbers In Google Sheets?

With a little know-how and effort, you can format phone numbers in Google Sheets any way you’d like them to appear. Unfortunately, Google Sheets doesn’t […]

How to VLOOKUP Multiple Columns in Google Sheets?

VLOOKUP formula (or Vertical lookup) in Google Sheets is a formula that you can use to look for a value in a columnar data set. […]

How to Make a Scatter Plot in Google Sheets (Step-by-Step)

Google Sheets has a convenient, built-in tool for generating scatter plot graphs. Scatter plots are a very useful tool for showing trends and relationships in […]

We are updating our Privacy Policy, so please make sure you take a minute to review it. As of May 25, 2018 your continued use of our services will be subject to this new Privacy Policy.
Review Privacy Policy OK