Excel Tutorial DATABASE

Hundreds of free Excel tutorials

  • Searchable database
  • Growing community
  • Constant updates
VLOOKUP Function Demo

Latest additions

ISERROR

ISERROR Function

The ISERROR function in Excel returns TRUE for any error type excel generates. This list of errors includes: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or

Read More »
PPMT-Function

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 is the

Read More »
NPER Function

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 a loan

Read More »
CUMPRINC Function

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 tool to

Read More »
YEARFRAC Function

YEARFRAC Function

The YEARFRAC function in Excel returns a decimal value that represents fractional years between two specified dates. Syntax: =YEARFRAC(start_date, end_date, [basis]) Arguments: start_date – The

Read More »

Do you have an Excel Question?
ASK our community!

Using the VLOOKUP Function can sometimes be complicated. The easiest way to learn is by example. Check out the following tutorial for a downloadable demo file that illustrates how to nest a VLOOKUP Function.

XLOOKUP Function in Excel is an extremely powerful lookup tool recently introduced by Microsoft. In fact, VLOOKUP may be a thing of the past. Learn about the  XLOOKUP function now.

Trying to become a financial wizard. You first need to understand the basics. Learn Compound Annual Growth Rate and Average Annual Growth Rates in Excel.

Learning shortcuts in Excel in essential to speeding up your work flow. This Chart is neatly organized to assist in the process. Check it out here.