Lynda.com - Excel 2010 Pivot Tables in Depth

seeders: 0
leechers: 0
Added on February 17, 2015 by VIP-Naruin Other > Tutorials
Torrent verified.



Lynda.com - Excel 2010 Pivot Tables in Depth (Size: 622.31 MB)
 77968_00_01_SC03_Welcome.mov5.42 MB
 77968_00_02_SC11_exerfiles.mov852.43 KB
 77968_01_09_SC11_update.mov7.01 MB
 77968_01_02_SC11_dataprep.mov6.81 MB
 77968_01_08_SC11_consolidate.mov6.79 MB
 77968_01_01_SC11_introPivot.mov6.55 MB
 77968_01_03_SC11_create.mov6.51 MB
 77968_01_06_SC11_external.mov5.85 MB
 77968_01_10_SC11_manage.mov5.37 MB
 77968_01_04_SC01_pivot.mov4.25 MB
 77968_01_05_SC01_configure.mov4.04 MB
 77968_01_07_SC11_access.mov3.63 MB
 77968_02_06_SC11_getpivotdata.mov7 MB
 77968_02_02_SC11_summary.mov6.84 MB
 77968_02_01_SC11_subandgrand.mov5.21 MB
 77968_02_03_SC11_more.mov4.75 MB
 77968_02_05_SC11_group.mov4.35 MB
 77968_02_04_SC11_calculated.mov3.7 MB
 77968_02_07_SC11_drill.mov2.5 MB
 77968_03_08_SC11_report.mov6.93 MB
 77968_03_06_SC11_slicer.mov6.11 MB
 77968_03_07_SC11_formatslicer.mov5.63 MB
 77968_03_02_SC11_custom.mov5.52 MB
 77968_03_03_SC11_select.mov4.5 MB
 77968_03_05_SC11_search.mov4.39 MB
 77968_03_04_SC11_rule.mov4.06 MB
 77968_03_01_SC11_sort.mov2.86 MB
 77968_03_09_SC11_clear.mov2.05 MB
 77968_04_02_SC11_create.mov8.37 MB
 77968_04_01_SC11_apply.mov8.33 MB
 77968_04_03_SC11_layout.mov4.77 MB
 77968_04_04_SC11_dataformat.mov2.83 MB
 77968_05_03_SC11_databars.mov5.93 MB
 77968_05_04_SC11_colorscale.mov5.69 MB
 77968_05_02_SC11_top.mov5.15 MB
 77968_05_07_SC11_multi.mov5.11 MB
 77968_05_01_SC11_rule.mov4.2 MB
 77968_05_06_SC11_edit.mov3.49 MB
 77968_05_08_SC11_delete.mov3.25 MB
 77968_05_05_SC01_icons.mov3.2 MB
 77968_06_06_SC11_type.mov7.15 MB
 77968_06_04_SC11_format.mov5.98 MB
 77968_06_01_SC11_create.mov5.16 MB
 77968_06_03_SC11_ptfilter.mov5.12 MB
 77968_06_02_SC11_pivot.mov4.32 MB
 77968_06_05_SC11_layout.mov4.24 MB
 77968_06_07_SC11_trend.mov3.74 MB
 77968_06_06_SC12_type.mov97.38 KB
 77968_07_01_SC11_print.mov6.37 MB
 77968_07_02_SC11_each.mov5.23 MB
 77968_07_03_SC11_printchart.mov2.73 MB
 77968_08_02_SC11_run.mov9.74 MB
 77968_08_01_SC11_record.mov6.55 MB
 77968_08_03_SC11_present.mov5.03 MB
 77968_09_06_SC11_relate.mov7.14 MB
 77968_09_04_SC11_manage.mov6.76 MB
 77968_09_02_SC11_download.mov5.38 MB
 77968_09_03_SC11_import.mov5.25 MB
 77968_09_05_SC11_add.mov4.32 MB
 77968_09_01_SC11_intro.mov3.48 MB
 77968_10_06_SC11_filter.mov7.32 MB
 77968_10_05_SC11_aggregate.mov6.69 MB
 77968_10_02_SC11_ops.mov6.31 MB
 77968_10_04_SC11_measure.mov6.21 MB
 77968_10_03_SC11_functions.mov5.43 MB
 77968_10_01_SC11_intro.mov4.81 MB
 77968_11_01_SC11_done.mov1.14 MB
 WholesaleData.xlsx44.6 MB
 Relationship.xlsx15.51 MB
 IMPORT.xlsx15.47 MB
 manage.xlsx15.47 MB
 AddTable.xlsx15.47 MB
 MonthTable.accdb368 KB
 Filtered.xlsx29.3 MB
 measures.xlsx28.68 MB
 aggregate.xlsx28.67 MB
 DAX Intro.xlsx28.67 MB
 DAX Functions.xlsx28.67 MB
 DAX Operators.xlsx28.67 MB
 PTDatabase.accdb412 KB
 Refreshing.xlsx25.03 KB
 managing.xlsx19.37 KB
 CONFIGURE.xlsx17.75 KB
 INTRODUCING.xlsx17.44 KB
 Pivoting.xlsx16.73 KB
 CreatePivot.xlsx12.58 KB
 dataprep.xlsx11.88 KB
 Consolidating.xlsx10.29 KB
 OutsideSource.xlsx9.99 KB
 SimplePresKit.xlsm26.12 KB
 running.xlsm20.15 KB
 RecordMacro.xlsx17.83 KB
 PrintPChart.xlsx24.07 KB
 PrintPTable.xlsx17.87 KB
 PrintItems.xlsx17.77 KB
 FilterPChart.xlsx21.43 KB
 FormatPChart.xlsx20.81 KB
 PivotPChart.xlsx20.63 KB
 PCTrendline.xlsx20.14 KB
 PivotChartLayout.xlsx19.3 KB
 PivotChartType.xlsx19.06 KB
 MakePTChart.xlsx17.76 KB
 FormatSlicer.xlsx19.28 KB
 FilterByRule.xlsx18.54 KB
 selection.xlsx17.94 KB
 sorting.xlsx17.86 KB
 Slicer.xlsx17.86 KB
 SearchFilter.xlsx17.86 KB
 customlist.xlsx17.8 KB
 ReportFilter.xlsx17.76 KB
 Clearing.xlsx17.04 KB
 PTColorScale.xlsx19.19 KB
 DeletePTCF.xlsx18.68 KB
 MultConds.xlsx18.67 KB
 PTDataBars.xlsx17.74 KB
 Topten.xlsx17.74 KB
 ConditionalRules.xlsx17.74 KB
 PTIconSets.xlsx17.47 KB
 EditConds.xlsx16.19 KB
 summary.xlsx18.88 KB
 Calculated.xlsx18.34 KB
 MoreThanOne.xlsx18.28 KB
 grouping.xlsx17.83 KB
 DrillDown.xlsx17.74 KB
 GetPivotData.xlsx17.74 KB
 SubAndGrand.xlsx17.74 KB
 ApplyStyle.xlsx17.94 KB
 PTLayout.xlsx17.74 KB
 DataFormat.xlsx17.74 KB
 CreatePTStyles.xlsx17.74 KB

Description

3h 42m Intermediate Apr 19, 2011

In Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel PivotTables, 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 PivotTables, 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:

Formatting data for use in a PivotTable
Connecting to an external data source
Refreshing a data source
Adding, removing, and positioning subtotals and grand totals
Creating a calculated field
Grouping PivotTable fields
Clearing and reapplying PivotTable filters
Applying field styles
Formatting cells
Creating a PivotChart
Printing PivotTables and PivotCharts
Creating relationships between tables in a PowerPivot model
Using the DAX language for advanced summaries in PowerPivot

Software:
Excel Office
Author:
Curt Frye
Source Page


Related Torrents

torrent name size seed leech

Sharing Widget


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