Google Sheets Tips
Google Sheets Trace Dependents and Precedents
Google Sheets does not have the trace dependents and trace precedents features, but in this tutorial we show you alternative ways to get this done on Google Sheets.
Google Sheets Tips Articles
Formulas
How to Use The IFNA Google Sheets Function: The Only Tutorial You Need
The IFNA function in Google Sheets helps handle N/A errors that are returned when a search value is not found by a formula. This tutorial shows how it is used.
Formulas
How to Use the UNIQUE Function in Google Sheets: Unique Values Tutorial
Data that has been imported from multiple sources often has the tendency to contain multiple copies of the same entries. As such, one of the prime tasks in data cleaning is to clear duplicate values,
Google Sheets Tips
Google Sheets Date Picker – An Easy Step-by-Step Guide
Prefer watching a video tutorial? Watch how to insert Google Sheets date picker below: Spreadsheet software like Google Sheets can be quite sensitive to differences in date formats, so it’s always better to pick the
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, and it also helps them control progress and keep projects on track. Gantt charts are now
Google Sheets Tips
How to Make a Box and Whisker Plot in Google Sheets
A box plot in Google Sheets can provide a valuable way to visualize the distribution of data. It lets you summarize important details of a set of data at a glance. Unfortunately, Google Sheets does
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 in table-like arrays or ranges with proper headers (like in
Formulas
Google Sheets NOT Function: How to Use IF/NOT Step-by-Step
The Google Sheets NOT function is a handy tool that lets you negate or reverse a logical value. This tutorial shows how to apply it in different use cases.
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
