Lynda.com- Excel 2010 Pivot Tables in Depth

seeders: 0

leechers: 33

Download torrent

Added on May 6, 2014 by TOXIC-MANin Other > Tutorials
Torrent verified.

Main

add to bookmarks

Lynda.com- Excel 2010 Pivot Tables in Depth (Size: 503.24 MB)

		01. Welcome.mov	5.42 MB
		02. Using the exercise files.mov	852.43 KB
		09. Updating and refreshing PivotTable data sources.mov	7.01 MB
		02. Formatting data for use in a PivotTable.mov	6.81 MB
		08. Consolidating data from multiple sources.mov	6.79 MB
		01. Introducing PivotTables.mov	6.55 MB
		03. Creating a PivotTable.mov	6.51 MB
		06. Connecting to an external data source.mov	5.85 MB
		10. Managing PivotTables.mov	5.37 MB
		04. Pivoting a PivotTable.mov	4.25 MB
		05. Configuring a PivotTable.mov	4.04 MB
		07. Connecting to an Access database.mov	3.63 MB
		06. Using PivotTable data in a formula.mov	7 MB
		02. Changing the PivotTable data field summary operation.mov	6.84 MB
		01. Adding, removing, and positioning subtotals and grand totals.mov	5.21 MB
		03. Summarizing more than one data field.mov	4.75 MB
		05. Grouping PivotTable fields.mov	4.35 MB
		04. Creating a calculated field.mov	3.7 MB
		07. Drilling down to the underlying data.mov	2.5 MB
		08. Filtering a PivotTable with report filter fields.mov	6.93 MB
		06. Filtering a PivotTable using slicers.mov	6.11 MB
		07. Formatting slicers.mov	5.63 MB
		02. Creating a custom sort order.mov	5.52 MB
		03. Filtering a PivotTable field by selection.mov	4.5 MB
		05. Filtering a PivotTable using a search filter.mov	4.39 MB
		04. Filtering a PivotTable by rule.mov	4.06 MB
		01. Sorting PivotTable data.mov	2.86 MB
		09. Clearing and reapplying PivotTable filters.mov	2.05 MB
		02. Creating a PivotTable style.mov	8.37 MB
		01. Applying a PivotTable style.mov	8.33 MB
		03. Changing the PivotTable layout.mov	4.77 MB
		04. Changing the data field number format.mov	2.83 MB
		03. Formatting PivotTable cells using data bars.mov	5.93 MB
		04. Formatting PivotTable cells using color scales.mov	5.69 MB
		02. Highlighting the top or bottom values in a PivotTable.mov	5.15 MB
		07. Controlling how multiple rules are applied.mov	5.11 MB
		01. Highlighting cells by applying a rule.mov	4.2 MB
		06. Editing conditional formatting rules.mov	3.49 MB
		08. Deleting a conditional formatting rule.mov	3.25 MB
		05. Formatting PivotTable cells using icon sets.mov	3.2 MB
		06. Changing a PivotChart's chart type.mov	7.15 MB
		04. Formatting a PivotChart.mov	5.98 MB
		01. Creating a PivotChart.mov	5.16 MB
		03. Filtering a PivotChart.mov	5.12 MB
		02. Pivoting a PivotChart.mov	4.32 MB
		05. Changing a PivotChart's layout.mov	4.24 MB
		07. Adding a trendline to a PivotChart.mov	3.74 MB
		01. Printing a PivotTable.mov	6.37 MB
		02. Printing each item on its own page.mov	5.23 MB
		03. Printing a PivotChart.mov	2.73 MB
		02. Running a macro.mov	9.74 MB
		01. Recording and reviewing a macro.mov	6.55 MB
		03. Creating a simple PivotTable presentation kit.mov	5.03 MB
		06. Creating relationships between tables.mov	7.14 MB
		04. Managing table columns.mov	6.76 MB
		02. Downloading and installing PowerPivot.mov	5.38 MB
		03. Importing PowerPivot data.mov	5.25 MB
		05. Adding tables to a PowerPivot model.mov	4.32 MB
		01. Introducing PowerPivot.mov	3.48 MB
		06. Using filters in aggregate functions.mov	7.32 MB
		05. Using aggregate functions.mov	6.69 MB
		02. Using DAX operators.mov	6.31 MB
		04. Adding calculated columns and measures.mov	6.21 MB
		03. Surveying DAX functions.mov	5.43 MB
		01. Introducing the DAX language.mov	4.81 MB
		Additional Resources.mov	1.14 MB
		Ex_Files_Ex2010_Pivot.zip	161.88 MB
		Torrent downloaded from Demonoid.me.txt	46 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
Lynda - Excel 2013 Pivot Tables In Depth - sum1_here Posted by sum1_here in Other > Tutorials	760.43 MB	58	8
Lynda - Excel 2013 - Pivot Tables in Depth (MP4) Posted by GOLU in Other > Tutorials	755.67 MB	10	2

Sharing Widget

Download torrent

503.24 MB

seeders:0

leechers:33

Lynda.com- Excel 2010 Pivot Tables in Depth