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 #206 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 REGEXEXTRACT Function in Google Sheets (8 Examples)

REGEXEXTRACT is part of the suite of REGEX functions that Google Sheets provides. The function is extremely handy when you are trying to dig out […]

How to Use REGEXREPLACE Function in Google Sheets

REGEXREPLACE is a handy function offered by Google Sheets that lets you quickly replace parts of strings in your sheets. It comes as part of […]

What-If Analysis in Google Sheets | Goal Seek in Google Sheets

When doing data analysis, there may be times when we know what we want as the result, but don’t really know what input values will […]

How to Get Running Totals in Google Sheets (Easy Formula)

A running total is a useful aggregation tool that helps you see the cumulative sum of a sequence of numbers at any point in the […]

Creating Candlestick Chart in Google Sheets (Step-by-step)

Charts and Graphs are great visualization tools that give you a birds-eye view of your data and help you make inferences. A candlestick chart is […]

How to Use the INDEX function in Google Sheets (Examples)

The INDEX function is perhaps one of the most under-used functions in Google Sheets. However, if you know the right way to use it, you’ll […]

How to Combine Formula and Text in Google Sheets (2 Easy Ways)

Combining text and numbers is common in spreadsheets, for example when you want to add some context There are a number of cases where you […]

Using Wildcards in Google Sheets (4 Examples)

Wildcards are a very versatile set of symbols that help you select a group of similar strings at a time. In this tutorial, I will […]

How to Convert Text to Date in Google Sheets

Working with dates in Google Sheets can sometimes be quite frustrating. This is because there are so many ways in which dates can be represented. […]

How to Convert PDF to Google Sheets (3 Easy Ways)

We often need to work with data received in the form of a PDF file. You might have a scanned copy of important data that […]

How to Convert Formula to Value in Google Sheets

Formulas always help make data processing easier and faster. As helpful as they are, formulas can sometimes come in the way of what we are […]

How to Group Columns in Google Sheets

Remember those little phone books with colorful tabs on them for each letter of the alphabet? Those little tabs helped keep your contacts grouped together […]

LOAD MORE
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