This cheat sheet gets you ... As you type, Excel looks through your corporate or personal address book and lists the names and addresses of contacts who match the text you’ve input.

That trick is Index/Match, a function that can find any value in any spreadsheet. One of the most common uses of Excel is as a database program, and oftentimes you've got to search the sheet for a ...

As we’ve shown you, Excel 2007 is chock full of new features, some of which may initially drive you crazy. But armed with our cheat sheet and a little elbow grease, you’ll be up and running ...

Excel isn’t the sexiest application in the world—it has an unfortunate association with the type of Milton-esque office drones we all wish we weren’t. All the same, you’re going to have to ...

In Excel, the INDEX function returns an item from a specific position (in a list, table, database). The MATCH function returns ... he needs from his Query Sheet. Remember, the bigger the ...

Many of us fell in love with Excel as we delved into its deep and ... First, select a range of blank cells beneath (or on another sheet) that’s the same size as the original range.