How-To Geek on MSN

3 Excel functions, 1 cell: How to build a pro dashboard engine

One formula filters, dedupes, and ranks your data into a live list. No more manual sort or remove duplicates.
How-To Geek on MSN

Creating drop-downs from table headers in Excel seems impossible—but this trick fixes it

Sync your drop-down menus with table headers using this robust, auto-expanding Named Range trick.