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