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

From lookup functions to multi-part formulas, I wish I knew about these Excel formulas earlier because they make me feel like a data wizard whenever I use them.

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.

How to Delete Functions in Excel. Excel uses the Visual Basic for Applications (VBA) language to generate functions used within the spreadsheet. Most developers use Excel functions to automate ...

How to Use Excel to Find Percentiles. As your business grows, you'll find that you need Microsoft Excel 2010 more and more to compute important numbers for your business. One Excel function that ...

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

You probably use VLOOKUP() function to find exact matches in Microsoft Excel, but you can also find the closest value when you don't know the exact value.

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.

Microsoft Excel is perhaps the most powerful spreadsheet application you can buy. But it also has some simple functions, like finding duplicates in data.