Autosum Function
Autosum Function Overview The AutoSum Function is by far one of the most useful features in all of Excel. Just about...
Start Learning
FLOOR Function
The FLOOR function in Excel rounds a given number down to the nearest specified multiple. Unlike the MROUND function, the FLOOR function...
RANK Function
The Excel Rank function returns the numeric value when compared to a list of numeric values. You can rank lists in ascending...
NETWORKDAYS.INTL Function
How many days do I have to work? Find out in Excel.
CUMPRINC Function
The CUMPRINC Function in Excel returns the cumulative principal paid on a loan between the start and end period. This is an...
XLOOKUP Function in Excel
XLOOKUP replaces VLOOKUP AND HLOOKUP permanently! Speed up your spreadsheet by changing your default lookup function. Add a 4th and 5th argument!
INT Function
The INT function in Excel rounds a number down to the nearest integer. This function will always round down. For negative numbers,...
RANK Function
The Excel Rank function returns the numeric value when compared to a list of numeric values. You can rank lists in ascending...
MROUND Function
The MROUND function in Excel will round a number up or down to a given multiple.
Excel Tutorials
Functions
ISOWEEKNUM Function
The Excel ISOWEEKNUM function takes a specified date and returns a week number (1-54). The returned week follows the ISO standard. This...
NETWORKDAYS Function
The NETWORKDAYS function in Excel allows you to return the number of workdays between two specified dates. This function automatically excludes weekends...
DATEDIF Function
The DATEDIF Function in Excel is used to calculate the number of days, months, or years between two dates. A common error...
AVERAGEIF Function
AVERAGEIF (Arithmetic Mean) – Single Criteria IF statement Use the AVERAGEIF Function to find the arithmetic mean in Excel while...
ROUNDDOWN Function
The ROUNDDOWN function in Excel returns a number rounded down to a specified number of places.
Formulas
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...
Annual Growth Rate in Excel
Annual Growth Rate in Excel Calculating the Annual Growth Rate in Excel is very easy. Annual growth rates are...
SPLIT FIRST and LAST NAMES
Split First and Last name This tutorial covers how to split first and last names in excel.
Equated Monthly Installment (EMI)
Calculate your Equated Monthly Installment (EMI) in Excel.
Summing Only Positive or Negative Values
Learn how to sum only positive or negative values in excel. If you are an avid excel user,...
LATEST Additions
Rule of 500 Calculator – Astrophotography
The Rule of 500 Calculator in Excel is a simple document to let you quickly determine the maximum shutter speed for shooting Astrophotography....
Full-Frame Crop Factor Calculator in Excel
Easily determine the Full-Frame Crop Factor of your various lenses using the following calculator in Excel. If you shoot with a Full-Frame or...
PPMT Function
The PPMT Function in Excel is used to calculate the principle of a given loan payment. If all you a trying to determine...
NPER Function
The NPER Function in Excel is a financial function that returns the number of periods for a specified loan. The total periods of...
“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 you...
CUMPRINC Function
The CUMPRINC Function in Excel returns the cumulative principal paid on a loan between the start and end period. This is an excellent...
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 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...