Lynda-com-Excel-2010-Piv-YXIU
00 Introductio. Welcome.mov5.42MB
00 Introduction02. Using the exercise files.mov852.43KB
01 Creating and Pivoting PivotTables09. Updating and refreshing PivotTable data sources.mov7.01MB
01 Creating and Pivoting PivotTables02. Fortting data for use in a PivotTable.mov6.81MB
01 Creating and Pivoting PivotTables08. Consolidating data from multiple sources.mov6.79MB
01 Creating and Pivoting PivotTables01. Introducing PivotTables.mov6.55MB
01 Creating and Pivoting PivotTables03. Creating a PivotTable.mov6.51MB
01 Creating and Pivoting PivotTables06. Connecting to an external data source.mov5.85MB
01 Creating and Pivoting PivotTables10. naging PivotTables.mov5.37MB
01 Creating and Pivoting PivotTables04. Pivoting a PivotTable.mov4.25MB
01 Creating and Pivoting PivotTables05. Configuring a PivotTable.mov4.04MB
01 Creating and Pivoting PivotTables07. Connecting to an Access database.mov3.63MB
02 Sumrizing PivotTable Data06. Using PivotTable data in a formula.mov7.00MB
02 Sumrizing PivotTable Data02. Changing the PivotTable data field summary operation.mov6.84MB
02 Sumrizing PivotTable Data01. Adding, removing, and positioning subtotals and grand totals.mov5.21MB
02 Sumrizing PivotTable Data03. Summarizing more than one data field.mov4.75MB
02 Sumrizing PivotTable Data05. Grouping PivotTable fields.mov4.35MB
02 Sumrizing PivotTable Data04. Creating a calculated field.mov3.70MB
02 Sumrizing PivotTable Data07. Drilling down to the underlying data.mov2.50MB
03 Sorting and Filtering PivotTable Data08. Filtering a PivotTable with report filter fields.mov6.93MB
03 Sorting and Filtering PivotTable Data06. Filtering a PivotTable using slicers.mov6.11MB
03 Sorting and Filtering PivotTable Data07. Fortting slicers.mov5.63MB
03 Sorting and Filtering PivotTable Data02. Creating a custom sort order.mov5.52MB
03 Sorting and Filtering PivotTable Data03. Filtering a PivotTable field by selection.mov4.50MB
03 Sorting and Filtering PivotTable Data05. Filtering a PivotTable using a search filter.mov4.39MB
03 Sorting and Filtering PivotTable Data04. Filtering a PivotTable by rule.mov4.06MB
03 Sorting and Filtering PivotTable Data01. Sorting PivotTable data.mov2.86MB
03 Sorting and Filtering PivotTable Data09. Clearing and reapplying PivotTable filters.mov2.05MB
04 Fortting PivotTables02. Creating a PivotTable style.mov8.37MB
04 Fortting PivotTables01. Applying a PivotTable style.mov8.33MB
04 Fortting PivotTables03. Changing the PivotTable layout.mov4.77MB
04 Fortting PivotTables04. Changing the data field number format.mov2.83MB
05 Applying Conditional Fortting to PivotTables03. Formatting PivotTable cells using data bars.mov5.93MB
05 Applying Conditional Fortting to PivotTables04. Formatting PivotTable cells using color scales.mov5.69MB
05 Applying Conditional Fortting to PivotTables02. Highlighting the or bottom values in a PivotTable.mov5.15MB
05 Applying Conditional Fortting to PivotTables07. Controlling how multiple rules are applied.mov5.11MB
05 Applying Conditional Fortting to PivotTables01. Highlighting cells by applying a rule.mov4.20MB
05 Applying Conditional Fortting to PivotTables06. Editing conditional formatting rules.mov3.49MB
05 Applying Conditional Fortting to PivotTables08. Deleting a conditional formatting rule.mov3.25MB
05 Applying Conditional Fortting to PivotTables05. Formatting PivotTable cells using icon sets.mov3.20MB
06 Creating and nipulating PivotCharts06. Changing a PivotChart s chart type.mov7.15MB
06 Creating and nipulating PivotCharts04. Formatting a PivotChart.mov5.98MB
06 Creating and nipulating PivotCharts01. Creating a PivotChart.mov5.16MB
06 Creating and nipulating PivotCharts03. Filtering a PivotChart.mov5.12MB
06 Creating and nipulating PivotCharts02. Pivoting a PivotChart.mov4.32MB
06 Creating and nipulating PivotCharts05. Changing a PivotChart s layout.mov4.24MB
06 Creating and nipulating PivotCharts07. Adding a trendline to a PivotChart.mov3.74MB
07 Printing PivotTables and PivotCharts01. Printing a PivotTable.mov6.37MB
07 Printing PivotTables and PivotCharts02. Printing each item on its own page.mov5.23MB
07 Printing PivotTables and PivotCharts03. Printing a PivotChart.mov2.73MB
08 nipulating PivotTables Using Macros02. Running a macro.mov9.74MB
08 nipulating PivotTables Using Macros01. Recording and reviewing a macro.mov6.55MB
08 nipulating PivotTables Using Macros03. Creating a simple PivotTable presentation kit.mov5.03MB
09 Getting Started with PowerPivot06. Creating relationships between tables.mov7.14MB
09 Getting Started with PowerPivot04. naging table columns.mov6.76MB
09 Getting Started with PowerPivot02. Downloading and installing PowerPivot.mov5.38MB
09 Getting Started with PowerPivot03. Importing PowerPivot data.mov5.25MB
09 Getting Started with PowerPivot05. Adding tables to a PowerPivot model.mov4.32MB
09 Getting Started with PowerPivot01. Introducing PowerPivot.mov3.48MB
10 Working with DAX Expressions06. Using filters in aggregate functions.mov7.32MB
10 Working with DAX Expressions05. Using aggregate functions.mov6.69MB
10 Working with DAX Expressions02. Using DAX operators.mov6.31MB
10 Working with DAX Expressions04. Adding calculated columns and measures.mov6.21MB
10 Working with DAX Expressions03. Surveying DAX functions.mov5.43MB
10 Working with DAX Expressions01. Introducing the DAX language.mov4.81MB
11 ConclusionAdditional resources.mov1.14MB
Exercise FilesEx_Files_Ex2010_Pivot.zip161.88MB
- CreateTime2018-05-06
- UpdateTime2018-05-06
- FileTotalCount68
- TotalSize1006.49MBHotTimes6ViewTimes10DMCA Report EmailmagnetLinkThunderTorrent DownBaiduYunLatest Search: 1.MADV-293 2.HUNT-076 3.SDDM-044 4.DDT-260 5.KTDS-472 6.ELO-186 7.KWBD-045 8.HODV-20776 9.NEO-303 10.ZATD-02 11.MN-007 12.WNZ-274 13.VRXS-114 14.FSET-244 15.WKED-001 16.NASS-052 17.SVDR-001 18.DVDES-480 19.ANND-087 20.PDV-122 21.PSD-463 22.BMW-012 23.KIBD-086 24.KIBD-046 25.ONSD-514 26.ONSD-465 27.JUSD-501 28.NLD-008 29.IDBD-381 30.TMSA-004 31.ONSD-368 32.ONSD-661 33.WCMD-03 34.DFTA-37 35.WNZ-443 36.SMA-526 37.KWBD-061 38.IDOL-102 39.IWGB-046 40.BIJ-030 41.SQTE-037 42.HODV-20738 43.YRZ-063 44.APAA-217 45.CADV-362 46.MAMA-334 47.MJFD-002 48.LPCD-0110 49.OHIS-42 50.CS-016 51.CDPFT-003 52.ARSO-13050 53.CO-4580 54.DBE-126 55.SFRR-106 56.EZD-027 57.WF-328 58.BUR-048 59.AZRD-194 60.YDJ-003 61.AEIL-204 62.KRMV-763 63.SEED-039 64.ITVW-001 65.SKS-015 66.MDX-084 67.BF-025 68.ARM-031 69.KRMV-945 70.HET-275 71.198 72.463 73.006 74.228 75.360 76.107 77.2866 78.088 79.3 80.105 81.317 82.067 83.087 84.199 85.137 86.1 87.062 88.015 89.043 90.077 91.460 92.016 93.309 94.130 95.011 96.483 97.013 98.244 99.565 100.303 101.005 102.016 103.206 104.191 105.383 106.625 107.671 108.20 109.301 110.048 111.445 112.307 113.20171 114.661 115.00545 116.038 117.01 118.178 119.182 120.334 121.011 122.004 123.015 124.4059 125.519 126.756 127.097 128.572 129.492 130.363 131.001 132.001 133.093 134.024 135.436 136.632 137.9156 138.094 139.012 140.034