### _xlfn. prefix in Excel

The Excel _xlfn. prefix indicates that your workbook contains a function that is not supported by your version of Excel.

#### Start Learning

### Autofilter in Excel

AutoFilter Excel offers an easy way to search or modify complex data sets using the AutoFilter feature. In order to use...

### FV Function â€“ Future Value

The FV Function is built into Excel. It is a financial function used to calculate the Future Value of an investment. ...

### Compound Annual Growth Rate (CAGR)

The compound annual growth rate (CAGR) is an essential function regardless of industry. In this tutorial, we will cover how easy it...

### DSUM Function

The Dsum function is used to calculate a specified column in a database that correlates with a specified criteria.

### TEXT Function in Excel

Learn how to use the TEXT Function in Excel.

### Writing Your First Macro

Learning to write your first macro in excel is very exciting. In this tutorial we will write and run our first simple...

### EDATE Function

The EDATE function in Excel takes a date and adds specified number of months.

### AverageIFS Function

Finding the arithmetic mean in Excel is very easy. In this example, we will be using the AVERAGEIFS function. We will be finding...

# Excel Tutorials

#### Functions

### MROUND Function

The MROUND function in Excel will round a number up or down to a given multiple.

### DAYS360 Function in Excel

Learn to use the DAYS360 Function in Excel.

### WORKDAY Function

The WORKDAY function in Excel takes a date and returns the nearest working day. This is achieved based on user specified values....

### MAX Function

The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells, the logical values, TRUE...

### RAND Function

The Excel RAND function returns a random number between 0 and 1. This is a rather simple function in Excel, but can...

### Subtract If Greater than Zero

Learn how to subtract if greater than zero. In this example, we will demonstrate how to subtract a value only if a cell is greater than zero. Let's look...

#### Formulas

### Percent Change Formula in Excel

Quickly Calculate Percentage Change in Excel.

### Annual Growth Rate in Excel

Annual Growth Rate in Excel Calculating the Annual Growth Rate in Excel is very easy. Annual growth rates are...

### Subtract If Greater than Zero

Learn how to subtract if greater than zero. In this example, we will demonstrate how to subtract a value only if a...

### Sum if date is greater than

Sum if date is greater than a specified date. In this example, we will use the following formula to sum a range...

#### LATEST Additions

### Add Text to Beginning Number in Excel

Easily learn to Add Text to the beginning of a Number in Excel. In many instances, you are required to format number with...

### YEAR Function

The YEAR function in Excel returns a 4-digit number representing the year component of date. This function allows you to pull out the...

### Delete Multiple Rows of data

In some cases, there is a need to delete multiple rows of data in Excel. When dealing with large data sets, there are...

### Separate Numbers after a symbol

This quick tutorial will demonstrate how to separate numbers after a symbol in Excel. In our example, we have a list of Serial...

### WORKDAY Function

The WORKDAY function in Excel takes a date and returns the nearest working day. This is achieved based on user specified values. For...

### Subtract If Greater than Zero

Learn how to subtract if greater than zero. In this example, we will demonstrate how to subtract a value only if a cell...

### WEEKNUM Function

The WEEKNUM Function in Excel will return the week number for a specific date. This function will return an integer from 1 to...