The Find and FindB functions count the number of characters of a text. We will explain how to use the Find and FindB functions in Excel.

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.

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 provides built-in tools to help you to find discrepancies like Filters, Conditional Formatting, advanced functions (If and IS, VLookUp, etc.), and Add-ins.

Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible.

TEXTBEFORE and TEXTAFTER are a few more of my favorite Excel functions to clean messy spreadsheets. Excel's newer text ...

Modern Excel functions like XLOOKUP, TEXTJOIN, and dynamic arrays offer faster, more versatile, and error-resistant alternatives to outdated tools such as VLOOKUP, CONCAT, and OFFSET.

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.

Excel's new Copilot function turns your prompts into formulas - how to try it It's so much easier to create, summarize, and analyze data now - no complex manual formulas required.