Excel 2010: Pivot Tables in Depth - Free Video Training
Written by YU53P on 14:24In Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel Pivot Tables, 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 Pivot Tables, 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:
* Pivoting a Pivot Table
* Summarizing more than one data field
* Filtering a Pivot Table using a search filter
* Formatting Pivot Table cells using color scales
* Creating a PivotChart
* Introducing PowerPivot
Along with the free video training tutorials you will also receive monthly offers, Excel Functions and formulas Tips, and insider information you won't hear elsewhere--including special discounts extended to newsletter subscribers.
Download Video here
0 komentar: Responses to “ Excel 2010: Pivot Tables in Depth - Free Video Training ”