Lynda com Excel 2010 Pivot Tables in Depth | D09657A54AFDD8B3FA773BF1817BDA49DF9B5556

Lynda com Excel 2010 Pivot Tables in Depth

Name	Lynda.com- Excel 2010 Pivot Tables in Depth	DOWNLOAD Copy Link
Total Size	527.7 MB
Total Files	68
Hash	D09657A54AFDD8B3FA773BF1817BDA49DF9B5556

/00 Introduction/
01. Welcome.mov	5.7 MB
02. Using the exercise files.mov	872.9 KB
/01 Creating and Pivoting PivotTables/
09. Updating and refreshing PivotTable data sources.mov	7.4 MB
02. Formatting data for use in a PivotTable.mov	7.1 MB
08. Consolidating data from multiple sources.mov	7.1 MB
01. Introducing PivotTables.mov	6.9 MB
03. Creating a PivotTable.mov	6.8 MB
06. Connecting to an external data source.mov	6.1 MB
10. Managing PivotTables.mov	5.6 MB
04. Pivoting a PivotTable.mov	4.5 MB
05. Configuring a PivotTable.mov	4.2 MB
07. Connecting to an Access database.mov	3.8 MB
/02 Summarizing PivotTable Data/
06. Using PivotTable data in a formula.mov	7.3 MB
02. Changing the PivotTable data field summary operation.mov	7.2 MB
01. Adding, removing, and positioning subtotals and grand totals.mov	5.5 MB
03. Summarizing more than one data field.mov	5.0 MB
05. Grouping PivotTable fields.mov	4.6 MB
04. Creating a calculated field.mov	3.9 MB
07. Drilling down to the underlying data.mov	2.6 MB
/03 Sorting and Filtering PivotTable Data/
08. Filtering a PivotTable with report filter fields.mov	7.3 MB
06. Filtering a PivotTable using slicers.mov	6.4 MB
07. Formatting slicers.mov	5.9 MB
02. Creating a custom sort order.mov	5.8 MB
03. Filtering a PivotTable field by selection.mov	4.7 MB
05. Filtering a PivotTable using a search filter.mov	4.6 MB
04. Filtering a PivotTable by rule.mov	4.3 MB
01. Sorting PivotTable data.mov	3.0 MB
09. Clearing and reapplying PivotTable filters.mov	2.2 MB
/04 Formatting PivotTables/
02. Creating a PivotTable style.mov	8.8 MB
01. Applying a PivotTable style.mov	8.7 MB
03. Changing the PivotTable layout.mov	5.0 MB
04. Changing the data field number format.mov	3.0 MB
/05 Applying Conditional Formatting to PivotTables/
03. Formatting PivotTable cells using data bars.mov	6.2 MB
04. Formatting PivotTable cells using color scales.mov	6.0 MB
02. Highlighting the top or bottom values in a PivotTable.mov	5.4 MB
07. Controlling how multiple rules are applied.mov	5.4 MB
01. Highlighting cells by applying a rule.mov	4.4 MB
06. Editing conditional formatting rules.mov	3.7 MB
08. Deleting a conditional formatting rule.mov	3.4 MB
05. Formatting PivotTable cells using icon sets.mov	3.4 MB
/06 Creating and Manipulating PivotCharts/
06. Changing a PivotChart's chart type.mov	7.5 MB
04. Formatting a PivotChart.mov	6.3 MB
01. Creating a PivotChart.mov	5.4 MB
03. Filtering a PivotChart.mov	5.4 MB
02. Pivoting a PivotChart.mov	4.5 MB
05. Changing a PivotChart's layout.mov	4.4 MB
07. Adding a trendline to a PivotChart.mov	3.9 MB
/07 Printing PivotTables and PivotCharts/
01. Printing a PivotTable.mov	6.7 MB
02. Printing each item on its own page.mov	5.5 MB
03. Printing a PivotChart.mov	2.9 MB
/08 Manipulating PivotTables Using Macros/
02. Running a macro.mov	10.2 MB
01. Recording and reviewing a macro.mov	6.9 MB
03. Creating a simple PivotTable presentation kit.mov	5.3 MB
/09 Getting Started with PowerPivot/
06. Creating relationships between tables.mov	7.5 MB
04. Managing table columns.mov	7.1 MB
02. Downloading and installing PowerPivot.mov	5.6 MB
03. Importing PowerPivot data.mov	5.5 MB
05. Adding tables to a PowerPivot model.mov	4.5 MB
01. Introducing PowerPivot.mov	3.6 MB
/10 Working with DAX Expressions/
06. Using filters in aggregate functions.mov	7.7 MB
05. Using aggregate functions.mov	7.0 MB
02. Using DAX operators.mov	6.6 MB
04. Adding calculated columns and measures.mov	6.5 MB
03. Surveying DAX functions.mov	5.7 MB
01. Introducing the DAX language.mov	5.0 MB
/11 Conclusion/
Additional resources.mov	1.2 MB
/Exercise Files/
Ex_Files_Ex2010_Pivot.zip	169.7 MB
/
Torrent downloaded from Demonoid.me.txt	0.0 KB
Total files 68