The bigger your spreadsheet, the more you need INDEX and MATCH functions, which you can combine with SUM, AVERAGE, and MAX to refine your searches.

You can do a mail merge in Microsoft Word and Excel to create personalized documents for many recipients at once.

Microsoft Excel has numerous powerful data analysis functions, but sometimes you need to do something simple like merge some cells. Here's how.

You can do a mail merge in Microsoft Word and Excel to create personalized documents for many recipients at once.