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 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?

This guide provides step-by-step instructions with examples how to extract a substring in Excel using various text functions.

Excel Boolean logic: How to sift spreadsheet data using AND, OR, NOT, and XOR Excel logical functions make it easy to find the data you want, especially in huge spreadsheets.

Microsoft's Excel software for Mac can execute a number of statistical functions, including finding the y-intercept of the line formed by a set of data points.