Using PivotTables and PivotCharts
Few people use PivotTables but they are missing out on probably the strongest component in Excel. It takes a little time to learn, but once you have conquered it, you will become an Excel power user capable of grouping and summarizing data in almost any form you can think of. Your boss will be amazed at what you can produce. If you are the boss, you will be even more amazed at yourself. PivotTables can create the types of reports managers want to see: those that don’t contain every detail but rather contain only the data they want to see when they want to see it.