Chapter 21. Powerful Reporting, Easier Than You Think: A PivotTable Primer

In this chapter, you will:

  • Understand the benefits of using a PivotTable

  • Learn the essentials of creating and formatting PivotTables

  • Explore PivotTable field settings and options

  • Learn about calculated PivotTable fields and PivotCharts

  • Discover the power of Slicers

PivotTable and PivotChart reports have a bad reputation, but don’t believe everything you hear. Though you can get more complex if you want to, PivotTables don’t have to be any more challenging to create and use than a typical bar or column chart. However, simple as your PivotTable may be, it’s likely to be a powerful analytical tool that can do more for you than you probably expect.

This chapter is quite a bit different ...

Get Documents, Presentations, and Workbooks: Using Microsoft® Office to Create Content That Gets Noticed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.