Microsoft Excel's new dynamic array functions make complex calculations easier than ever before.

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.