Lynda.com- Excel 2010 Pivot Tables in Depth

seeders: 0
leechers: 33
Added on May 6, 2014 by TOXIC-MANin Other > Tutorials
Torrent verified.



Lynda.com- Excel 2010 Pivot Tables in Depth (Size: 503.24 MB)
 01. Welcome.mov5.42 MB
 02. Using the exercise files.mov852.43 KB
 09. Updating and refreshing PivotTable data sources.mov7.01 MB
 02. Formatting data for use in a PivotTable.mov6.81 MB
 08. Consolidating data from multiple sources.mov6.79 MB
 01. Introducing PivotTables.mov6.55 MB
 03. Creating a PivotTable.mov6.51 MB
 06. Connecting to an external data source.mov5.85 MB
 10. Managing PivotTables.mov5.37 MB
 04. Pivoting a PivotTable.mov4.25 MB
 05. Configuring a PivotTable.mov4.04 MB
 07. Connecting to an Access database.mov3.63 MB
 06. Using PivotTable data in a formula.mov7 MB
 02. Changing the PivotTable data field summary operation.mov6.84 MB
 01. Adding, removing, and positioning subtotals and grand totals.mov5.21 MB
 03. Summarizing more than one data field.mov4.75 MB
 05. Grouping PivotTable fields.mov4.35 MB
 04. Creating a calculated field.mov3.7 MB
 07. Drilling down to the underlying data.mov2.5 MB
 08. Filtering a PivotTable with report filter fields.mov6.93 MB
 06. Filtering a PivotTable using slicers.mov6.11 MB
 07. Formatting slicers.mov5.63 MB
 02. Creating a custom sort order.mov5.52 MB
 03. Filtering a PivotTable field by selection.mov4.5 MB
 05. Filtering a PivotTable using a search filter.mov4.39 MB
 04. Filtering a PivotTable by rule.mov4.06 MB
 01. Sorting PivotTable data.mov2.86 MB
 09. Clearing and reapplying PivotTable filters.mov2.05 MB
 02. Creating a PivotTable style.mov8.37 MB
 01. Applying a PivotTable style.mov8.33 MB
 03. Changing the PivotTable layout.mov4.77 MB
 04. Changing the data field number format.mov2.83 MB
 03. Formatting PivotTable cells using data bars.mov5.93 MB
 04. Formatting PivotTable cells using color scales.mov5.69 MB
 02. Highlighting the top or bottom values in a PivotTable.mov5.15 MB
 07. Controlling how multiple rules are applied.mov5.11 MB
 01. Highlighting cells by applying a rule.mov4.2 MB
 06. Editing conditional formatting rules.mov3.49 MB
 08. Deleting a conditional formatting rule.mov3.25 MB
 05. Formatting PivotTable cells using icon sets.mov3.2 MB
 06. Changing a PivotChart's chart type.mov7.15 MB
 04. Formatting a PivotChart.mov5.98 MB
 01. Creating a PivotChart.mov5.16 MB
 03. Filtering a PivotChart.mov5.12 MB
 02. Pivoting a PivotChart.mov4.32 MB
 05. Changing a PivotChart's layout.mov4.24 MB
 07. Adding a trendline to a PivotChart.mov3.74 MB
 01. Printing a PivotTable.mov6.37 MB
 02. Printing each item on its own page.mov5.23 MB
 03. Printing a PivotChart.mov2.73 MB
 02. Running a macro.mov9.74 MB
 01. Recording and reviewing a macro.mov6.55 MB
 03. Creating a simple PivotTable presentation kit.mov5.03 MB
 06. Creating relationships between tables.mov7.14 MB
 04. Managing table columns.mov6.76 MB
 02. Downloading and installing PowerPivot.mov5.38 MB
 03. Importing PowerPivot data.mov5.25 MB
 05. Adding tables to a PowerPivot model.mov4.32 MB
 01. Introducing PowerPivot.mov3.48 MB
 06. Using filters in aggregate functions.mov7.32 MB
 05. Using aggregate functions.mov6.69 MB
 02. Using DAX operators.mov6.31 MB
 04. Adding calculated columns and measures.mov6.21 MB
 03. Surveying DAX functions.mov5.43 MB
 01. Introducing the DAX language.mov4.81 MB
 Additional Resources.mov1.14 MB
 Ex_Files_Ex2010_Pivot.zip161.88 MB
 Torrent downloaded from Demonoid.me.txt46 bytes

Description

"Excel 2010: Pivot Tables in Depth - Free Video Training Tutorial"

In 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, tips, and insider information you won't hear elsewhere--including special discounts extended to newsletter subscribers.

After taking advantage of the free video training, you can access all of their video tutorials by becoming a member of the Online Training Library®. Membership plans start at $25 per month, and require no long-term commitment.
Offered Free by: Lynda.com Inc.

- See more at: http://geocommunity.tradepub.com/free-offer/excel-2010-pivot-tables-in-depth--free-video-training-tutorial/w_lynd20?sr=hicat&_t=hicat:713#sthash.jN3pdfmC.dpuf

Related Torrents

torrent name size seed leech

Sharing Widget


Download torrent
503.24 MB
seeders:0
leechers:33
Lynda.com- Excel 2010 Pivot Tables in Depth