Lynda com Excel 2010 Pivot Tables in Depth | 5C6119A56324087C86B9B3CB4D700DA6A5401464

Lynda com Excel 2010 Pivot Tables in Depth

Name	Lynda.com.Excel.2010.Pivot.Tables.in.Depth	DOWNLOAD Copy Link
Total Size	652.4 MB
Total Files	131
Hash	5C6119A56324087C86B9B3CB4D700DA6A5401464

/00 Introduction/
77968_00_01_SC03_Welcome.mov	5.7 MB
77968_00_02_SC11_exerfiles.mov	872.9 KB
/01 Creating and Pivoting PivotTables/
77968_01_01_SC11_introPivot.mov	6.9 MB
77968_01_02_SC11_dataprep.mov	7.1 MB
77968_01_03_SC11_create.mov	6.8 MB
77968_01_04_SC01_pivot.mov	4.5 MB
77968_01_05_SC01_configure.mov	4.2 MB
77968_01_06_SC11_external.mov	6.1 MB
77968_01_07_SC11_access.mov	3.8 MB
77968_01_08_SC11_consolidate.mov	7.1 MB
77968_01_09_SC11_update.mov	7.4 MB
77968_01_10_SC11_manage.mov	5.6 MB
/02 Summarizing PivotTable Data/
77968_02_01_SC11_subandgrand.mov	5.5 MB
77968_02_02_SC11_summary.mov	7.2 MB
77968_02_03_SC11_more.mov	5.0 MB
77968_02_04_SC11_calculated.mov	3.9 MB
77968_02_05_SC11_group.mov	4.6 MB
77968_02_06_SC11_getpivotdata.mov	7.3 MB
77968_02_07_SC11_drill.mov	2.6 MB
/03 Sorting and Filtering PivotTable Data/
77968_03_01_SC11_sort.mov	3.0 MB
77968_03_02_SC11_custom.mov	5.8 MB
77968_03_03_SC11_select.mov	4.7 MB
77968_03_04_SC11_rule.mov	4.3 MB
77968_03_05_SC11_search.mov	4.6 MB
77968_03_06_SC11_slicer.mov	6.4 MB
77968_03_07_SC11_formatslicer.mov	5.9 MB
77968_03_08_SC11_report.mov	7.3 MB
77968_03_09_SC11_clear.mov	2.2 MB
/04 Formatting PivotTables/
77968_04_01_SC11_apply.mov	8.7 MB
77968_04_02_SC11_create.mov	8.8 MB
77968_04_03_SC11_layout.mov	5.0 MB
77968_04_04_SC11_dataformat.mov	3.0 MB
/05 Applying Conditional Formatting to PivotTables/
77968_05_01_SC11_rule.mov	4.4 MB
77968_05_02_SC11_top.mov	5.4 MB
77968_05_03_SC11_databars.mov	6.2 MB
77968_05_04_SC11_colorscale.mov	6.0 MB
77968_05_05_SC01_icons.mov	3.4 MB
77968_05_06_SC11_edit.mov	3.7 MB
77968_05_07_SC11_multi.mov	5.4 MB
77968_05_08_SC11_delete.mov	3.4 MB
/06 Creating and Manipulating PivotCharts/
77968_06_01_SC11_create.mov	5.4 MB
77968_06_02_SC11_pivot.mov	4.5 MB
77968_06_03_SC11_ptfilter.mov	5.4 MB
77968_06_04_SC11_format.mov	6.3 MB
77968_06_05_SC11_layout.mov	4.4 MB
77968_06_06_SC11_type.mov	7.5 MB
77968_06_07_SC11_trend.mov	3.9 MB
/07 Printing PivotTables and PivotCharts/
77968_07_01_SC11_print.mov	6.7 MB
77968_07_02_SC11_each.mov	5.5 MB
77968_07_03_SC11_printchart.mov	2.9 MB
/08 Manipulating PivotTables Using Macros/
77968_08_01_SC11_record.mov	6.9 MB
77968_08_02_SC11_run.mov	10.2 MB
77968_08_03_SC11_present.mov	5.3 MB
/09 Getting Started with PowerPivot/
77968_09_01_SC11_intro.mov	3.6 MB
77968_09_02_SC11_download.mov	5.6 MB
77968_09_03_SC11_import.mov	5.5 MB
77968_09_04_SC11_manage.mov	7.1 MB
77968_09_05_SC11_add.mov	4.5 MB
77968_09_06_SC11_relate.mov	7.5 MB
/10 Working with DAX Expressions/
77968_10_01_SC11_intro.mov	5.0 MB
77968_10_02_SC11_ops.mov	6.6 MB
77968_10_03_SC11_functions.mov	5.7 MB
77968_10_04_SC11_measure.mov	6.5 MB
77968_10_05_SC11_aggregate.mov	7.0 MB
77968_10_06_SC11_filter.mov	7.7 MB
/11 Conclusion/
77968_11_01_SC11_done.mov	1.2 MB
/Exercise Files/Ch01/
Configure.xlsx	18.2 KB
Consolidating.xlsx	10.5 KB
CreatePivot.xlsx	12.9 KB
DataPrep.xlsx	12.2 KB
External.xlsx	8.4 KB
Introducing.xlsx	17.9 KB
Managing.xlsx	19.8 KB
OutsideSource.xlsx	10.2 KB
Pivoting.xlsx	17.1 KB
PTAccess.xlsx	8.4 KB
PTDatabase.accdb	421.9 KB
Refreshing.xlsx	25.6 KB
/Exercise Files/Ch02/
Calculated.xlsx	18.8 KB
DrillDown.xlsx	18.2 KB
GetPivotData.xlsx	18.2 KB
Grouping.xlsx	18.3 KB
MoreThanOne.xlsx	18.7 KB
SubAndGrand.xlsx	18.2 KB
Summary.xlsx	19.3 KB
/Exercise Files/Ch03/
Clearing.xlsx	17.5 KB
CustomList.xlsx	18.2 KB
FilterByRule.xlsx	19.0 KB
FormatSlicer.xlsx	19.7 KB
ReportFilter.xlsx	18.2 KB
SearchFilter.xlsx	18.3 KB
Selection.xlsx	18.4 KB
Slicer.xlsx	18.3 KB
Sorting.xlsx	18.3 KB
/Exercise Files/Ch04/
ApplyStyle.xlsx	18.4 KB
CreatePTStyles.xlsx	18.2 KB
DataFormat.xlsx	18.2 KB
PTLayout.xlsx	18.2 KB
/Exercise Files/Ch05/
ConditionalRules.xlsx	18.2 KB
DeletePTCF.xlsx	19.1 KB
EditConds.xlsx	16.6 KB
MultConds.xlsx	19.1 KB
PTColorScale.xlsx	19.7 KB
PTDataBars.xlsx	18.2 KB
PTIconSets.xlsx	17.9 KB
TopTen.xlsx	18.2 KB
/Exercise Files/Ch06/
FilterPChart.xlsx	21.9 KB
FormatPChart.xlsx	21.3 KB
MakePTChart.xlsx	18.2 KB
PCTrendline.xlsx	20.6 KB
PivotChartLayout.xlsx	19.8 KB
PivotChartType.xlsx	19.5 KB
PivotPChart.xlsx	21.1 KB
/Exercise Files/Ch07/
PrintItems.xlsx	18.2 KB
PrintPChart.xlsx	24.6 KB
PrintPTable.xlsx	18.3 KB
/Exercise Files/Ch08/
RecordMacro.xlsx	18.3 KB
Running.xlsm	20.6 KB
SimplePresKit.xlsm	26.7 KB
/Exercise Files/Ch09/
AddTable.xlsx	16.2 MB
Import.xlsx	16.2 MB
Manage.xlsx	16.2 MB
MonthTable.accdb	376.8 KB
Relationship.xlsx	16.3 MB
WholesaleData.xlsx	46.8 MB
/Exercise Files/Ch10/
Aggregate.xlsx	30.1 MB
DAX Functions.xlsx	30.1 MB
DAX Intro.xlsx	30.1 MB
DAX Operators.xlsx	30.1 MB
Filtered.xlsx	30.7 MB
Measures.xlsx	30.1 MB
Total files 131