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

How To Move A Column In Google Sheets

Google Sheets offers several methods for moving columns around on a spreadsheet. It’s common to come back to data and decide the way you organized […]

How to Unhide Rows in Google Sheets (4 Easy Methods)

Google Sheets offers a few ways to unhide rows in a spreadsheet. If you’re new to Google Sheets or you’ve never relied on the “hide […]

How to Set Print Area in Google Sheets

Setting the print area in Google Sheets is an important part of the process for transferring spreadsheet information to paper in a way that’s easy […]

How to Show Formulas Instead of Values in Google Sheets

Google Sheets has countless built-in features that automate and streamline the most common use-cases. However, when you want to do something like show a formula […]

Format Painter in Google Sheets (Copy formatting easily)

Formatting data and making it look good and more readable is something we often do when working with Google Sheets. And Google Sheets has a […]

How to Highlight Duplicates In Google Sheets (Easy Steps)

With a little know-how, you can use Google Sheets to highlight duplicates. You can customize how Sheets represents a duplicate match so it makes sense […]

How to VLOOKUP from Another Sheet in Google Sheets

You can unlock the full potential of Vlookup, (vertical lookup), in Google Sheets by using it to call data across different spreadsheets and workbooks. The […]

How to Strikethrough in Google Sheets (3 Easy Ways + Shortcut)

Google Sheets offers several quick ways to format text with strikethrough when you need it. While strikethrough is something mostly used in Google Docs, you […]

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