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