How to Use the Multiple Rows Function in Excel. In addition to listing data, you can also use Excel to manipulate data. For example, you can compute sales, determine inventory or calculate nearly ...

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.

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.

This article will teach you how to use the MATCH formula in Excel to find data entries that are partially linked to one another. How to perform a partial cell match on Excel? The below example shows ...

Combine INDEX and MATCH: Use MATCH to find the row or column number and INDEX to retrieve the value at that position.

This month, Susan Harkins introduces an Excel user to advanced filtering and helps a PowerPoint user reduce his work when positioning pictures in PowerPoint.