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.
Spreadsheet Point on MSN

Make Excel do the boring part of budgeting with a bank CSV macro

A repeatable Excel macro workflow can import a bank CSV, clean dates and amounts, normalize merchant names, apply categories, ...