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.

When working with a large data set, you would be more productive if you knew how to quickly find what you need. Luckily, Excel has a few functions that can help with this.

Sometimes you need to scan some files for a piece of data like a string, phrase or some number, and one of those files just happens to be an Excel spreadsheet. You could open up the file, launch the ...

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

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.

In Microsoft Excel, using a scatter chart allows you to plot the data points against the probability of achieving each observed data point.