【Lynda】Excel 2010: Pivot Tables in Depth【CHN】中英文字幕[SRT]
==========教程信息=====================================================
教程名称：Excel 2010: Pivot Tables in Depth
作者：Curt Frye
主题：Business, Spreadsheets
使用软件：Excel 2010, Office 2010
难度等级：中级
时长： 3h 42m
发布日期： Apr 19, 2011
┏ACELY STUDIO，2012
┃更多资源请访问
┃◆唯一发布站：ACELY.CN
┗◆我的博客：http://blog.sina.com.cn/u/1991840741
==========教程目录文件列表=============================================
Excel 2010- Pivot Tables in Depth[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 Using the exercise files.srt
├─◆1. Creating and Pivoting PivotTables
│ └─◇ 0101 Introducing PivotTables.srt
│ └─◇ 0102 Formatting data for use in a PivotTable.srt
│ └─◇ 0103 Creating a PivotTable.srt
│ └─◇ 0104 Pivoting a PivotTable.srt
│ └─◇ 0105 Configuring a PivotTable.srt
│ └─◇ 0106 Connecting to an external data source.srt
│ └─◇ 0107 Connecting to an Access database.srt
│ └─◇ 0108 Consolidating data from multiple sources.srt
│ └─◇ 0109 Updating and refreshing PivotTable data sources.srt
│ └─◇ 0110 Managing PivotTables.srt
├─◆2. Summarizing PivotTable Data
│ └─◇ 0201 Adding, removing, and positioning subtotals and grand totals.srt
│ └─◇ 0202 Changing the PivotTable data field summary operation.srt
│ └─◇ 0203 Summarizing more than one data field.srt
│ └─◇ 0204 Creating a calculated field.srt
│ └─◇ 0205 Grouping PivotTable fields.srt
│ └─◇ 0206 Using PivotTable data in a formula.srt
│ └─◇ 0207 Drilling down to the underlying data.srt
├─◆3. Sorting and Filtering PivotTable Data
│ └─◇ 0301 Sorting PivotTable data.srt
│ └─◇ 0302 Creating a custom sort order.srt
│ └─◇ 0303 Filtering a PivotTable field by selection.srt
│ └─◇ 0304 Filtering a PivotTable by rule.srt
│ └─◇ 0305 Filtering a PivotTable using a search filter.srt
│ └─◇ 0306 Filtering a PivotTable using slicers.srt
│ └─◇ 0307 Formatting slicers.srt
│ └─◇ 0308 Filtering a PivotTable with report filter fields.srt
│ └─◇ 0309 Clearing and reapplying PivotTable filters.srt
├─◆4. Formatting PivotTables
│ └─◇ 0401 Applying a PivotTable style.srt
│ └─◇ 0402 Creating a PivotTable style.srt
│ └─◇ 0403 Changing the PivotTable layout.srt
│ └─◇ 0404 Changing the data field number format.srt
├─◆5. Applying Conditional Formatting to PivotTables
│ └─◇ 0501 Highlighting cells by applying a rule.srt
│ └─◇ 0502 Highlighting the top or bottom values in a PivotTable.srt
│ └─◇ 0503 Formatting PivotTable cells using data bars.srt
│ └─◇ 0504 Formatting PivotTable cells using color scales.srt
│ └─◇ 0505 Formatting PivotTable cells using icon sets.srt
│ └─◇ 0506 Editing conditional formatting rules.srt
│ └─◇ 0507 Controlling how multiple rules are applied.srt
│ └─◇ 0508 Deleting a conditional formatting rule.srt
├─◆6. Creating and Manipulating PivotCharts
│ └─◇ 0601 Creating a PivotChart.srt
│ └─◇ 0602 Pivoting a PivotChart.srt
│ └─◇ 0603 Filtering a PivotChart.srt
│ └─◇ 0604 Formatting a PivotChart.srt
│ └─◇ 0605 Changing a PivotChart’s layout.srt
│ └─◇ 0606 Changing a PivotChart’s chart type.srt
│ └─◇ 0607 Adding a trendline to a PivotChart.srt
├─◆7. Printing PivotTables and PivotCharts
│ └─◇ 0701 Printing a PivotTable.srt
│ └─◇ 0702 Printing each item on its own page.srt
│ └─◇ 0703 Printing a PivotChart.srt
├─◆8. Manipulating PivotTables Using Macros
│ └─◇ 0801 Recording and reviewing a macro.srt
│ └─◇ 0802 Running a macro.srt
│ └─◇ 0803 Creating a simple PivotTable presentation kit.srt
├─◆9. Getting Started with PowerPivot
│ └─◇ 0901 Introducing PowerPivot.srt
│ └─◇ 0902 Downloading and installing PowerPivot.srt
│ └─◇ 0903 Importing PowerPivot data.srt
│ └─◇ 0904 Managing table columns.srt
│ └─◇ 0905 Adding tables to a PowerPivot model.srt
│ └─◇ 0906 Creating relationships between tables.srt
├─◆10. Working with DAX Expressions
│ └─◇ 1001 Introducing the DAX language.srt
│ └─◇ 1002 Using DAX operators.srt
│ └─◇ 1003 Surveying DAX functions.srt
│ └─◇ 1004 Adding calculated columns and measures.srt
│ └─◇ 1005 Using aggregate functions.srt
│ └─◇ 1006 Using filters in aggregate functions.srt
├─◆Conclusion
│ └─◇ Additional resources.srt
◇
【本字幕由ACELY.CN独家制作发布】
┏
┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译，对翻译结果中不当内容不承担任何责任！
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载！
┗