Using PivotTables and PivotCharts
David L. Slager, Annette Slager · Apress eBooks · 2020
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. It’s called a PivotTable because you can pivot your data, switching between rows and columns. You can dynamically rearrange your existing data into an almost endless variety of different views. You can rapidly create these views by dragging and dropping fields to different locations. Excel then automatically recalculates the results to match the view you created.