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

10 Google Sheets Tips that’ll Help You Get Work Done Faster

While Microsoft Excel still rules the spreadsheet world, Google Sheets has been slowly making inroads. It has found some loyalists in freelancers, small business owners, […]

101 Google Sheets Keyboard Shortcuts

Google Sheets is a relatively new spreadsheet tool in the market. It has quickly gained a lot of fan following and I see a lot […]

Sparkline in Google Sheets – The Only Guide You Need

Sparklines are miniature charts that you can create within a cell. These are quite useful when you're creating a dashboard and want to quickly show a […]

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