Jason Howie

To illustrate Excel's most popular financial functions we consider a loan with monthly payments an annual interest rate of 6% a 20-year duration a present value of $150000 (amount borrowed) and a future value of 0 (that's what you hope to achieve when you pay off a loan).

This example illustrates the End property of the Range object in Excel VBA. We will use this property to select the range from the Active Cell to the last entry in a column.

Below we will look at a program in Excel VBA that removes duplicates.

The AND function in Excel evaluates multiple conditions and returns TRUE only if all conditions are TRUE. This guide provides a comprehensive understanding of the AND function starting with basic usage and progressing to more advanced formulas.

Below we will look at a program in Excel VBA that colors the maximum value of a dynamic range.

Instead of creating different scenarios you can create a data table to quickly try out different values for formulas. You can create a one variable data table or a two variable data table in Excel.

Below we will look at a program in Excel VBA that shows a print preview of all the possible football matches from a list of teams.

This chapter teaches you how to deal with some common formula errors in Excel. Let's start simple.

This example teaches you how to calculate the tax on an income using the VLOOKUP function in Excel. The following tax rates apply to individuals who are residents of Australia.

Let's check out the 10 most used Excel functions. Visit our section about functions for detailed explanations and more awesome functions.