Summary

In this chapter, you learned what PivotTables are and how to create them from your existing tables or other data sources. You know how to start a PivotTable automatically or build it manually, how to rearrange its fields to change the information it displays and the way it displays the information, and how to design and format the PivotTable. Lastly, you learned how to sort and filter PivotTables to make them show the information you need.

In the next chapter, I'll show you how to share your workbooks with your colleagues.

Get Learn Excel 2011 for Mac 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.