O'Reilly logo

Excel® 2013 In Depth by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

23. Using Pivot Tables to Analyze Data

A pivot table enables you to summarize thousands or millions of records of data to a one-page summary in just a few clicks.

Pivot tables were introduced in Excel 95 and have been evolving ever since:

• Excel 2013 adds a new entry point for pivot tables called Recommended Pivot Tables. This feature shows you various thumbnails of pivot tables before you begin creating one.

• Excel 2013 adds the ability to create a data model from several different tables. You can create a relationship between tables without using VLOOKUPs and base pivot tables on the model.

• Timelines are a visual date filter introduced in Excel 2013. They join slicers, the visual filter introduced in Excel 2010. The best feature of timelines ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required