Category: Google Sheets Functions Tips & Tutorials

The SWITCH function in Google Sheets is a helpful tool for changing how a cell behaves based on the value

Google Sheets makes it easy to round numbers. It features several functions that can accommodate a wide-range of rounding. Whether

You can calculate weighted averages in Google Sheets by using a built-in formula: AVERAGE.WEIGHTED. Weighted averages are useful for calculating

VLOOKUP formula (or Vertical lookup) in Google Sheets is a formula that you can use to look for a value

With a little know-how and effort, you can format phone numbers in Google Sheets any way you’d like them to

With a little know-how, you can use Google Sheets to highlight duplicates. You can customize how Sheets represents a duplicate

You can unlock the full potential of Vlookup, (vertical lookup), in Google Sheets by using it to call data across

You may think in what scenario will I need to convert text to numbers in a Google document or in

If you work with text data in Google Sheets, there are many useful text functions that can help you slice

When working with data in Google Sheets, sometimes you may have a need to remove the last character from a

There might be times when you want to know what weekday it is on a specific date. For example, you

Watch video – Using FILTER function in Google Sheets (examples) Google Sheets has some useful functions that are not available