You’ve probably heard a lot about Excel pivot tables. In fact, people who are really into pivot tables tend to go on and on about how cool they are. It can be a little annoying. What’s the big deal? Why are pivot tables so cool?
The main reason pivot tables are cool is that they instantly summarize large sets of data without any formulas. In less than 5 minutes, you can have a good-looking table, with perfect summaries by almost any category you like.