Google Sheets Tips Articles

Google sheets date picker
Google Sheets Tips

How to Insert a Date Picker in Google Sheets

Spreadsheet software like Google Sheets can be quite sensitive to differences in date formats, so it’s always better to pick the date from a real-time calendar, rather than typing it out. In this tutorial we

How to Make a Gantt Chart In Google Sheets
Charting

How to Make a Gantt Chart in Google Sheets

A Gantt chart can be a powerful tool to help project managers share and distribute tasks among team members. It also helps them control progress and keep projects on track. Gantt charts are now becoming

How to Make A Box And Whisker Plot In Google Sheets
Google Sheets Tips

How to Make a Box and Whisker Plot in Google Sheets

A box plot can provide a valuable way to visualize distribution of data. It lets you summarize important details of a set of data at a glance. Unfortunately, Google Sheets does not have a feature to

Google Sheets DSUM Function: The Ultimate Guide
Google Sheets Tips

 Google Sheets DSUM Function: The Ultimate Guide

The DSUM function in Google Sheets is part of a whole suite of Google Sheets functions that work like SQL queries. These functions process data that is in table-like arrays or ranges with proper headers

How to Share Only One Sheet in Google Sheets
Google Sheets Tips

How to Share Only One Sheet in Google Sheets

Google can be a little cumbersome when it comes to sharing. Often, when you try to share a document, Google Sheets tries to share the entirety of the document — and that’s not always what you