This article looks at how to use Excel’s auditing tools to audit formulas and ensure the accuracy of data.

Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy datasets.

Learn how to easily set up your own search field in Excel to find and filter content within a table.

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.

Sometimes it's necessary to split cells in a spreadsheet, and Microsoft Excel makes it easy enough to do.

It's easy to divide in Excel to make calculations and analyze data in a spreadsheet. Here's what you need to know to do it.