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.

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.

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

Excel’s PivotTables (Microsoft runs the words together, although you?ll find pivot tables in other spreadsheet programs) can provide those types of answers. Do you want to group data by category?

Microsoft Excel displays the error "Cannot extend list or database" when your data set is not as continuous, and shows the error message to avoid overwriting existing data.