Recent Posts

The Google Sheets SWITCH function is a helpful tool for changing how a cell behaves based on the value in another cell. Learn how to use it properly here!...
Rounded numbers make your spreadsheets easier to read. So learning the Google Sheets ROUND, ROUNDUP , and ROUNDDOWN are all but necessary for sharing sheets....
The following processes will teach you how to calculate weighted average using the weighted average formula in Google Sheets....
VLOOKUP formula (or Vertical lookup) in Google Sheets is a formula that you can use to look for a value in a columnar data set. For example, if you have a list of student names and their scores, you c...
You need to use custom formatting to apply Google Sheets phone number format by heading to Format > Number > Custom number format. Click here for more details....
Google Sheets is a complex program and when others use your sheet it can be hard to understand. Learn how to make Google Sheets show formulas to make it easier....
Learn how to highlight duplicates in Google Sheets with this comprehensive guide. We' cover several examples, including how to highlight every nth instance....
Can Google Sheets VLOOKUP from another sheet? Yes, and it's pretty simple to do. Follow this guide to learn how....
If you've been asking yourself, "Can Google Sheets convert text to number?" The answer is yes, in 6 different ways, learn them all here....
If you work with text data in Google Sheets, there are many useful text functions that can help you slice and dice the text data or modify it easily. One of the common tasks that many people need to d...
When working with data in Google Sheets, sometimes you may have a need to remove the last character from a string (or remove the last 2 or 3 or 5 characters). This can easily be done using some basic ...
In this tutorial, you'll learn how to use the Google Sheets day of week (WEEKDAY) function to get the weekday numbers/name for a date. All in one easy step!...