• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 1. Pivot Table Fundamentals > Why Should You Use a Pivot Table?

Why Should You Use a Pivot Table?

As a rule, your dealings in Excel can be split into two categories: calculating data and shaping (formatting) data. Although there are many built-in tools and formulas that facilitate both of these, the pivot table is often the fastest and most efficient way to calculate and shape data.

Let's look at one simple scenario that will illustrate this point.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint