The Easiest Google Sheets FILTER Function Tutorial for 2022

With more than 2 billion users, Google Sheets is one of the most popular spreadsheet applications in the world. The Filter function is a powerful tool that can

Read More

How to Make a Super Powered Secret Santa Generator This Christmas

Do you want to organize a Secret Santa swap with your friends but you don't know how to get everyone a partner quickly? Well one of the coolest

Read More

How to Create a Free QR Code in Google Sheets

Thanks to the IMAGE function and the hero that created Google's chart API, we can easily generate a qr code in any table you make in Google Sheets.

Read More

How to Use the IFS Function in Google Sheets

In google sheets, the IFS, much like the IF function, is used to conditionally format your data according to various criteria and multiple conditions. While the IF function

Read More

How to Use the IF Function in Google Sheets

The IF function in Google Sheets (somewhat like the IFS function) lets you command your data with more than just a simple True/False statement. If you know how

Read More

Logical Tests and The Foundation of Conditional Functions in Google Sheets

Learning how to run a logical test is the foundation for understanding the more confusing if-then statement functions later on in Sheets. Today, I will show you how

Read More

How to Find the Sum of a Column in Google Sheets

Use this technique to quickly find the sum of an entire column of data in Google Sheets quickly and effectively.Without further ado, let's get right into it=SUM(Column Cell

Read More

How to Use “ImportRange” in Google Sheets

With "ImportRange", you will be able to exchange cell ranges between URLs and data tables with Ease. I will show you how to use the IMPORT-RANGE function along with

Read More

How to Transpose Data in Google Sheets

Transposing Data is when you reorient your data from Vertical to Horizontal, and vice versa. I will show you how to do so in Google Sheets. It is

Read More

How To Name a Cell Range in Google Sheets

With Google Sheets, you can organize massive ranges of Cells super easy, thanks to the ability to name your ranges. Learn how to do so in just a

Read More