Excel for Mac.2011 Pivot Tables in Depth

[caovantan 42]

 

Lynda - Excel for Mac 2011: Pivot Tables in Depth

Size: 263 MB | Duration: 1h 34m | Video: AVC (.mp4) 1280x720 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

 

Download link:

Ukryta Zawartość

Treść widoczna tylko dla użytkowników forum DarkSiders. Zaloguj się lub załóż darmowe konto na forum aby uzyskać dostęp bez limitów.

 

Links are Interchangeable - No Password - Single Extraction