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