### NPER Function

The NPER Function in Excel is a financial function that returns the number of periods for a specified loan. The total periods...

#### Start Learning

### Universal Basic Income from a Republican?

Could a Universal Basic Income work in the US?

### DAYS360 Function in Excel

Learn to use the DAYS360 Function in Excel.

### How to apply Multiple Filters in Excel

We are going to cover how to use Multiple filters in Excel. A Filter is cumulative, this implies that you can apply...

### Import/Export Data in Tableau

Let's take an example by importing data. Goto> Data> Microsoft Excel gives the location of the file, for...

### COUNTIFS Function

The countifs Function is used when you want to count data with multiple criteria. =COUNTIFS (range1, criteria1,...

### Use a Letter to Represent a Value in Excel

This tutorial will show you how to use a letter to represent a specific value. Using this process, you can perform mathematical...

### Rounding functions in Excel

Complete overview of rounding options in Excel.

### Pivot Tables

Overview: Pivot tables are one of the most versatile and powerful tools available in Excel. They allow you to...

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

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

### CUMPRINC Function

The CUMPRINC Function in Excel returns the cumulative principal paid on a loan between the start and end period. This is an...

### ROUNDDOWN Function

The ROUNDDOWN function in Excel returns a number rounded down to a specified number of places.

### _xlfn. prefix in Excel

The Excel _xlfn. prefix indicates that your workbook contains a function that is not supported by your version of Excel. This is a common error you many receive, especially is...

#### Formulas

### SUMPRODUCT and EXACT Formula

In this tutorial, we will combine the SUMPRODUCT and EXACT Function in a formula to determine the total number of Wins 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...

### Sum if greater than

To sum if greater than, we need to use the SUMIF Function and define our criteria. In this example, we will use...

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

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