Recent Posts

How to VLOOKUP Multiple Columns 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...

How To Format Phone Numbers In Google Sheets?

With a little know-how and effort, you can format phone numbers in Google Sheets any way you’d like them to appear. Unfortunately, Google Sheets doesn’t have built-in formatting presets for phone ...

How to Highlight Duplicates In Google Sheets (Easy Steps)

Watch Video – Highlight Duplicates in Google Sheets With a little know-how, you can use Google Sheets to highlight duplicates. You can customize how Sheets represents a duplicate match so it mak...

How to VLOOKUP from Another Sheet in Google Sheets

You can unlock the full potential of Vlookup, (vertical lookup), in Google Sheets by using it to call data across different spreadsheets and workbooks. The Vlookup function is an incredibly powerful f...

How to Convert Text to Numbers In Google Sheets

You may think in what scenario will I need to convert text to numbers in a Google document or in Google sheets.  Think about it this way: if you are given a spreadsheet with numbers, it will be e...

Capitalize First Letters in Google Sheets (Easy Formula)

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...

Remove Last Character from a String in Google Sheets (or Last N Characters)

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 ...

Easy Google Sheets Day Of Week (WEEKDAY) Guide – 1 Step!

There might be times when you want to know what weekday it is on a specific date in Google Sheets For example, you may want to know the weekday on your birthday, or on the first date of the next month...

5 Simple Examples for FILTER Function Google Sheets Mastery

https://www.youtube.com/watch?v=-z587aoPhCcGoogle Sheets has some useful functions that are not available in Excel (such as IMPORTRANGE, QUERY, IMPORTDATA, etc.) One such extremely powerful one is ...

OR Function Google Sheets Tutorial with Examples for 2023

OR function is useful when you want to evaluate a set of conditions. It will return TRUE when any of the conditions being checked are met, else it returns FALSE. Let’s dive into our OR function ...

An Easy to Follow IMPORTRANGE Google Sheets Guide for 2023

Watch Video – IMPORTRANGE Google Sheets Guide Do you want to import the data from other Google Sheets into the one in which your working currently? You can do this easily using the IMPORTRANGE f...

How to Use IMPORTDATA function in Google Sheets

Watch Video – IMPORTDATA Function in Google Sheets IMPORTDATA function is Google sheets allows you to quickly import the data from the URL of a .csv (comma separated value) or .tsv (tab-separate...