The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

Lookup functions are great for finding values that match another value. Thanks to XLOOKUP () this task is easier than ever, and it even supports wildcards! In this article, I’ll show you how to ...

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.

VLOOKUP and Search are two functions that Excel uses to search for text. VLOOKUP finds data in a column and returns the contents of an adjacent cell.

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on ...

Here are the 17 most useful accounting functions in Microsoft Excel to make financial data monitoring and reporting easier and faster.

When creating formulas and equations on Microsoft Excel, users have the option of inserting multiple functions and conditions into a formula to attain a desired result. This action is often referred ...

When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions.

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.

Kinds of Functions Used in Excel. Microsoft's Excel program, widely used in business, comes with many built-in functions that perform mathematical and logical operations on spreadsheet data.