Someone else's Excel spreadsheet, my problem now—these 5 tools help me handle it

I've lost count of how many times someone has sent me an Excel spreadsheet that technically contains everything I need, but makes me work far too hard to find it. Maybe the data is crammed into the wrong columns, duplicate records are lurking everywhere, or the formulas look like they were designed to confuse the next person who opens the file. Over the years, I've settled on a handful of Excel tools that help me turn someone else's mess into something I can actually work with.