NPER Function
The NPER Function in Excel is a financial function that returns the number of periods for a specified loan. The total periods...
“We can’t connect to” in Excel
"We can't connect to" pop-up! If you have ever received an Excel document sent to you loaded with Macros, chances are...
CUMPRINC Function
The CUMPRINC Function in Excel returns the cumulative principal paid on a loan between the start and end period. This is an...
YEARFRAC Function
The YEARFRAC function in Excel returns a decimal value that represents fractional years between two specified dates. Syntax:
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...
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...
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...
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...
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...
WORKDAY.INTL Function
Workday.intl Function
