Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques. The article Five ways to take advantage of Excel list features showed five ...

Transition from user to developer through consistent notation, table-based architecture, global constants, and self-documenting logic.

Whether you're choosing an employee of the month, picking giveaway winners, or assigning tasks, Excel is the perfect tool for a bias-free draw. These simple formulas allow you to generate a single ...

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets. An Excel ...