I stopped overrelying on Excel's filter buttons after learning how to build live lists

If you've spent any time working with data in Excel, you've probably come across filtering. It's a quick way to focus on the records you need, analyze a subset of your data, and hide everything else from view. But Excel's regular filter buttons come with a few annoyances: they hide entire worksheet rows, can make the original dataset harder to see, and leave you with filters to clear when you've finished.