If you've used data validation in Excel before, you probably selected the relevant cells, clicked "Data Validation" in the Data tab on the ribbon, and created the rule in the Data Validation dialog ...

While I'll always argue that SUM is my favorite and most-used Excel formula, there are plenty of other powerful functions included in the software. These features go far past using Excel as a digital ...