PivotTables are one of the most powerful data analysis tools in Microsoft Excel. Learn how to use PivotTables to summarize, sort, count, and chart your organization's data in Excel for Mac 2011. Author Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. He shows how to build PivotTables from single or multiple data sources (including external spreadsheets and text files), add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to share your work by printing PivotTables and saving them as PDFs.