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

How to Use Slicer in Pivot Tables in Google Sheets

The slicer is a really handy feature of Google Sheets. It enhances the power of Pivot Tables and Pivot Charts in Google Sheets. With Slicers, […]

How to Convert Time to Decimal in Google Sheets (2 Easy Ways)

If your dataset contains date and time values, there might be situations where you need to convert them to decimal numbers. For example, you might […]

Formula Parse Error in Google Sheets (& How to Fix it)

Formulas in Google Sheets were meant to make things easier for us. However, every Formula user, irrespective of whether it’s a beginner or expert, has […]

Comparison Operators in Google Sheets (A Complete Guide)

Google Sheets lets you use six comparison operators to make comparisons between values and return a TRUE or FALSE value. These operators can be easily […]

How to Refresh Pivot Table in Google Sheets

Pivot tables are powerful tools that let you gain very useful insights into your data. A common question on a lot of Google Sheets forums […]

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