Ever found yourself wondering if there’s a more efficient way to handle your data in Excel? If you’ve been using Pivot Tables but feel like you’re only scratching the surface, you’re in for a treat.

Microsoft’s updated spreadsheet tool isn’t getting a lot of new, whiz-bang features, but it is becoming more functional. That’s something both new and experienced users will enjoy—especially a new ...