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 #111 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 Make a Pie Chart in Google Sheets (Step-by-Step)

There are a lot of great reasons to make a pie chart! It shows relationships between pieces of data and it’s a great way to […]

How to Sort by Color in Google Sheets

Sorting by color in Google Sheets is just a few mouse clicks or screen taps away. Google added this capability to the Sheets app in […]

How to Automatically Send Emails from Google Sheets (Using Appscript)

Spreadsheets these days are all about automating as many of your tasks as possible. Imagine a scenario where you have to process an order, create […]

How to Insert a Pivot Table in Google Sheets (Step-by-Step)

Spreadsheets provide a great way to work with data. They help you keep your data organized so that you can get good insights from it. […]

Capitalize First Letters in Google Sheets (Easy Formula)

If you work with text data in Google Sheets, there are many useful text functions that can help you slice and dice the text data […]

Remove Last Character from a String in Google Sheets (or Last N Characters)

When working with data in Google Sheets, sometimes you may have a need to remove the last character from a string (or remove the last […]

How to Insert Timestamp in Google Sheets

Google Sheets is a great tool when you’re collaborating and working with people on the same sheet. It allows people to work in the sheet simultaneously. In […]

Show / Hide Gridlines in Google Sheets (in less than 5 seconds)

Just like most of the spreadsheet tools, Google Sheets also have gridlines around the cells in it. These gridlines make it easy for you to […]

How to Insert Spin Button in Google Sheets (to change cell values)

Recently, I was working on creating a leave tracker template in Google Sheets. One of the interactive features that I wanted to create was a […]

How to Center Text in the Middle of the Page in Microsoft Word 2016

If you're are creating and printing a report in Word, it looks great to have the title of the report on the first page aligned […]

25 Useful Microsoft Word Tips to Make You a Power User

Microsoft Word is the most popular Word processor tool out there. Over the years, it has evolved into a complex tool that is super easy […]

4 Ways to Insert a Vertical Line in Microsoft Word Document

There are various ways you can use to insert a vertical line in Microsoft Word. The method you choose would depend on where you want […]

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