Tips and Tricks

Sometimes when working in spreadsheet programs like Google Sheets, you may have a mix of cells that contain no data (blank cells), and other cells that are not blank (contain …

Sometimes when working in spreadsheet programs like Google Sheets, you may want to know the number of cells in a range that are empty or blank. There are a number …

Color coding your spreadsheet can make your data easier to understand and can help to highlight key information. With conditional formatting, you can create a color code to automatically change …

Spreadsheet programs like Google Sheets are extremely versatile and allow you to do many useful things. You can do simple things like creating budgets, graphs, charts, and do simple math …

Sometimes when working in a large spreadsheet you may want to know the last value in a column without having to scroll all the way to the bottom of the …

Understanding how to use wildcard characters is an extremely useful skill that every spreadsheet user should develop. Wildcard characters can be used in Google Sheets in combination with functions to …

If you want to count how many times a value or word appears in a column in Google Sheets, that can be done pretty easily with a couple of functions. …

If you need to find the unique values in your spreadsheet across multiple columns, there is a way to do that in Google Sheets with this UNIQUE function. In this …

If you need to remove the last character from a string in your spreadsheet, there are a number of ways you can do this in Google Sheets. There are a …

There are many different ways to extract numbers, text, and punctuation from a cell in Google Sheets. Learning all of the different functions that can be used to extract a …