Lynda – Excel for Mac 2011: Pivot Tables in Depth-0daytown

Lynda – Excel for Mac 2011: Pivot Tables in Depth
Size: 263 MB | Duration: 1h 34m | Video: AVC (.mp4) 1280×720 15&30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English
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.

Topics include:

* Creating a PivotTable
* Refreshing PivotTable data
* Managing totals
* Creating calculated fields
* Grouping PivotTable fields
* Sorting and filtering PivotTable data
* Printing PivotTables