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

Learn about 10 Text functions in Excel with examples, including Find, Len, Left, Right, Mid, Substitute, Upper, Trim, Concatenate, and Text.

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.

Excel provides built-in tools to help you to find discrepancies like Filters, Conditional Formatting, advanced functions (If and IS, VLookUp, etc.), and Add-ins.

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.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

This tutorial will explain how to find a value in an Excel column using the Find function in VBA.

If you need to reconcile batches of records in Microsoft Excel, this simple VLOOKUP() solution offers a quick and easy way to find records in one batch that are missing from another.