A pivot table is a must-have tool for power Excel users. It lets you see the bigger picture, where you can make sense of large amounts of information quickly and easily.

Click OK, and Excel will display a pivot table frame and a field list. Using Figure C as a guide, build the pivot table shown in Figure A. Figure A. Build this pivot table. Figure B.

After completing these steps, Excel will generate a basic Pivot Table based on your selections, ready for further customization. Excel Pivot Tables Beginner to Pro Guide Watch this video on YouTube .

As you’re working on your own pivot tables, you can experiment to see how added and removing fields affects the data that’s displayed. You’ll find that Excel does a great job of making ...