Excel can send alerts based on spreadsheet data, but you'll need to write a macro to do it. We'll show you how.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.