Productivity Spot - Google Sheets Tips

Productivity Spot - Google Sheets Tips Ebook

FREE EBOOK: 10 Google Sheets Tips for Busy Professionals

Get Work Done Faster with these 10 Tips

Popular Tutorials on Google Sheets

How to Insert Checkbox in Google Sheets

There is no direct way to insert a checkbox in Google Sheets. However, you can use a smart data validation technique to get a drop down list with a checkbox option

Read More >>

How to Remove Duplicates in Google Sheets

If you work with data, getting duplicates is a common issue. In this tutorial, learn how to quickly find and remove duplicates.

Read More >>

How to Use IF Function in Google Sheets

IF function evaluates a conditions a specified value when the condition is TRUE, else it return the other specified value. Learn how to use IF function with examples.

Read More >>

How to QUERY Function in Google Sheets

Query function allows you to retrieve specific data from a tabular dataset. This is helpful when you quickly want to get a subset of a larger dataset.

Read More >>

How to Quickly Freeze/Lock Rows in Google Sheets

Freezing rows at the top would make those rows visible all the time so that you never lose a track of what column represents what metrics.

Read More >>

Calculate the Number of Days Between Two Dates

In this tutorial, I will show you how to calculate the number of days, number of weekdays, and number of weekends between two specified dates

Read More >>

Follow on: Facebook | Youtube | Twitter | Google+ | Pinterest

© Productivity Spot - Google Sheets Tips & Tricks (2017)