Use Pivot Tables for Better Insight into Your Spreadsheets

You've probably heard of pivot tables and just kind of ignored them, since they sound pretty complicated and it's not even clear what they do. The reality is that you can create pivot tables from almost any kind of spreadsheet to better visualize your data and see hidden relationships that help you solve all sorts of problems.

Watch the Business Hacks exclusive video after the jump (try it in full screen mode for best results) for an overview of how to create and use pivot tables in Excel 2007. It's only three minutes and it will rock your Excel universe.

What do you think about these BizHack videos? Tell me the good and the bad about these videos, and suggest topics for future entries. We're all ears.