# How to use Vlookup function in Excel

The VLOOKUP function is one of the most popular functions in Excel.

# How to Use WEEKDAY Function in Excel

Learn how to get the day of the week of a date in Excel and how to get the number of weekdays or workdays days between two dates.

# How to use Weighted Average in Excel

To calculate a weighted average in Excel, simply use the SUMPRODUCT and the SUM function.

# How to use RANK Function In Excel

The RANK function in Excel returns the rank of a number in a list of numbers.

# How to count the number of words In Excel

This example describes how to count the number of words in a cell.

# How to Create a Roll the Dice In Excel

This example teaches you how to simulate the roll of two dice in Excel.

# How to Generate Random Numbers In Excel

Excel has two useful functions when it comes to generating random numbers.

# How to Split a String In Excel

This example teaches you how to separate strings in Excel.

# How to use Calculate Quarter in Excel

An easy formula that returns the quarter for a given date.

# How to use Offset function In Excel

The OFFSET function in Excel returns a cell or range of cells that is a specified number of rows and columns from a cell or range of cells.

# How to use Or function in Excel

The OR function in Excel returns TRUE if any of the conditions are true and returns FALSE if all conditions are false.

# How to use Percent Change Formula In Excel

The percent change formula is used very often in Excel.

# How to use Percentiles and Quartiles In Excel

This example teaches you how to use the PERCENTILE and QUARTILE function in Excel.

# How to use PMT function In Excel

The PMT function in Excel calculates the payment for a loan based on constant payments and a constant interest rate.

# How to use Search function In Excel

Use the SEARCH function in Excel to find the position of a substring in a string.