# The COUNTIF Function in Excel

The COUNTIF function in Excel is used to count the number of cells in a range that meet a certain criteria.

Read More The COUNTIF Function in Excel

# Common Excel Mistakes

Here are five common Excel mistakes that people often make, that you should be aware of and how to avoid them.

# Using Vlookup in Excel (and Google Sheets)

VLOOKUP is a very powerful tool in Excel, when interviewing candidates for jobs, I would ask them about their English, Maths and VLOOKUP skill

# Using iserror in excel

The ISERROR function in Excel is a useful tool that allows you to check if a value is an error, and return a specific value if it is. This can be especially helpful when working with large datasets, as it allows you to identify and handle errors quickly and easily.

Read More Using iserror in excel

# How to check if a column has duplicate values in excel

Duplicate values in a column can cause a variety of problems in Excel. For example, they can distort any statistical analysis you may be performing, or make it difficult to find unique values in your data. That’s why it’s important to check for duplicates and remove them if necessary.

Read More How to check if a column has duplicate values in excel

# How to calculate the difference between two dates in excel

Calculating the number of days between two dates in Excel is a relatively simple task, and can be done using the “DATEDIF” function. This function allows you to specify the start date, end date, and unit of time you want to use to calculate the difference. For example, to calculate the number of days between 1/1/2022 and 1/5/2022, you would use the following formula.

Read More How to calculate the difference between two dates in excel

# How to separate first name and surname in excel

Extracting a first name and surname from a full name in Excel can be a useful way to organize and sort data. There are a few different approaches you can take to accomplish this task.

Read More How to separate first name and surname in excel