INT Function
The INT function in Excel rounds a number down to the nearest integer. This function will always round down. For negative numbers,...
Start Learning
Annual Growth Rate in Excel
Annual Growth Rate in Excel Calculating the Annual Growth Rate in Excel is very easy. Annual growth rates 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...
Summing Only Positive or Negative Values
Learn how to sum only positive or negative values in excel. If you are an avid excel user,...
Create a Drop Down List
If you want to force user for selecting data from the fixed data items and prevent user from entering custom data for any...
HOUR Function in Excel
What time is it? The HOUR Function can grab, you guessed it, the HOUR!
WEEKNUM Function
The WEEKNUM Function in Excel will return the week number for a specific date. This function will return an integer from 1...
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...
RANK Function
The Excel Rank function returns the numeric value when compared to a list of numeric values. You can rank lists in ascending...
Excel Tutorials
Functions
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. ...
AVERAGEIF Function
AVERAGEIF (Arithmetic Mean) – Single Criteria IF statement Use the AVERAGEIF Function to find the arithmetic mean in Excel while...
CONCATENATE Function
The Excel CONCATENATE function joins multiple strings into a single string. You can combine up to 30 text items together.
MINUTE Function
The MINUTE function in Excel returns the minute component of a specified time as a number between 0-59.
Formulas
Get the day name of a date in Excel
Here is an easy way to get the name of a date in Excel. Overview:
Calculate Private Mortgage Insurance (PMI)
Learn how to calculate Private Mortgage Insurance (PMI) on a new home purchase.
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...
Annual Growth Rate in Excel
Annual Growth Rate in Excel Calculating the Annual Growth Rate in Excel is very easy. Annual growth rates are...
Compound Quarterly Growth Rate (CQGR)
Compound Quarterly Growth Rate (CQGR) in Excel is rather easy to calculate. This can be very useful to forecast potential income or...
LATEST Additions
Add Text to End Number in Excel
Easily learn to Add Text to the End of a Number in Excel. This simple trick will allow you to format numbers with...
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...