Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

AVERAGEIF and AVERAGEIFS aren't the only functions in Excel that calculate the average of a dataset. For example, the AVERAGE function produces a straightforward arithmetic mean of a set of data, and ...

In two-dimensional XLOOKUP formulas, it doesn't matter which way around the XLOOKUPs go. In this example, the ID lookup is first in the formula, and the column header lookup is nested. If these were ...

You can sum a series of numbers in Microsoft Excel manually by typing in a simple formula, or automatically with a tool.

When you need to see the last value in an Excel Table or data range, these formulas will get the job done. This walk-through details the necessary formulas and some VBA code that performs the same ...

The Gordon growth model, also known as the dividend discount model, is often applied in Microsoft Excel to determine the intrinsic value of a stock.

How to Use a Letter to Represent a Value in Excel. In Microsoft Excel, the well-known and widely used spreadsheet software, you can use letters to represent values.

How to Use the IF Function in Excel to See Who Has Paid. Excel's IF function validates a cell's contents, determining whether it meets criteria that you set. It provides no information beyond what ...

Learn how to use the VLOOKUP formula to compare a maximum of two columns to have common values returned or to locate missing data.

Find out how to use Microsoft Excel to calculate the present value of a fixed annuity, including a calculation example. The calculation doesn't account for taxes.