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.
Houston Chronicle

How to Subset Data in Excel

Filters are used to create subsets of data in a Microsoft Excel worksheet. The "AutoFilter" or "Sort and Filter" function in Excel allows you to create views of data matching your specified criteria.