Excel has a versatile If, Then function built right into it. We’ll show you how to use the IF function in Excel with a number of helpful examples.

Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does.

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

Before beginning, here is a quick run down of the Microsoft Excel functions needed for this to work. The SEARCH function is used to find a piece of data in an Excel spreadsheet.

The Excel INDIRECT function returns the reference specified by a text string. Learn how to use the INDIRECT function in Excel in easy steps.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

Functions frequently used in Excel are consolidated in the right-click menu, so you can work efficiently by "using tabs at the top of the screen and using the right-click menu".

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find.