Lynda.com - Excel 2010: Pivot Tables in Depth 

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 PivotTable
  Connecting to an external data source
  Refreshing a data source
  Adding, removing, and positioning subtotals and grand totals
  Creating a calculated field
  Grouping PivotTable fields
  Clearing and reapplying PivotTable filters
  Applying field styles
  Formatting cells
  Creating a PivotChart
  Printing PivotTables and PivotCharts
  Creating relationships between tables in a PowerPivot model
  Using the DAX language for advanced summaries in PowerPivot


Microsoft Office applications;   
https://www.piratebays.to/search/Microsoft%20Office%202010%20%5Bthethingy%5D/0/99/300

-----------------------------------------------------------------------------------

TO USE .iso FILES DOWNLOAD THIS;   
https://www.piratebays.to/search/Power%20iso%20%5Bthethingy%5D/0/99/300