Download Now
Excel 2010: Pivot Tables
MP4 | Video: 720p | Duration: 3:43:40 | English | Subtitles: VTT | 680.1 MB

In Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel PivotTables, including more advanced techniques such as using macros and the new PowerPivot add-in. The course shows how to connect and consolidate data sources to power PivotTables, sort and filter records, display data in a PivotChart, print tables and charts, and also introduces the DAX language for performing advanced summaries in PowerPivot. Exercise files are included with the course.

Topics include:
Formatting data for use in a PivotTableConnecting to an external data sourceRefreshing a data sourceAdding, removing, and positioning subtotals and grand totalsCreating a calculated fieldGrouping PivotTable fieldsClearing and reapplying PivotTable filtersApplying field stylesFormatting cellsCreating a PivotChartPrinting PivotTables and PivotChartsCreating relationships between tables in a PowerPivot modelUsing the DAX language for advanced summaries in PowerPivot
Download link:

Links are Interchangeable - No Password - Single Extraction
Direct Download

Tags: Tables

Add Comments:
Enter Code: *