Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

Learn how to create self-updating filters in Excel to simplify data management and save time with this step-by-step guide.

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques.