# How to Use Locate Maximum Value In Excel

This example teaches you how to find the cell address of the maximum value in a column.

# How to Use Lower/Upper Case In Excel

This example teaches you how to convert a text string to lower, upper or proper case in Excel.

# How to Use MaxIfs and MinIfs Function In Excel

Use MAXIFS and MINIFS in Excel 2016 or later to find the maximum and minimum value based on one criteria or multiple criteria.

# How to use Nearest Multiple In Excel

This example illustrates three functions to round numbers to a multiple of x in Excel.

# How to use the IF Function (WS) In Excel

The IF function is one of the most used functions in Excel.

# How to Use the IRR function in Excel

Use the IRR function in Excel to calculate a project’s internal rate of return.

# How to calculate depreciation in Excel

Excel offers five different depreciation functions.

# How to Copy Exact Formula In Excel

When you copy a formula, Excel automatically adjusts the cell references for each new cell the formula is copied to.

# How to Count the Errors In Excel

This example shows you how to create an array formula that counts the number of errors in a range.

# How to Count Unique Values In Excel

This example shows you how to create an array formula that counts unique values.

# How to Count with Or Criteria In Excel

Counting with Or criteria in Excel can be tricky. This article shows several easy to follow examples.

# How to Create an External References In Excel

An external reference in Excel is a reference to a cell or range of cells in another workbook.

# How to Use Day of the Year In Excel

An easy formula that returns the day of the year for a given date.

# How to Use Days until Birthday In Excel

To calculate the number of days until your birthday in Excel, execute the following steps.

# How to use Even and Odd function in Excel

This example illustrates the EVEN and the ODD function in Excel.