【Lynda】Excel 2007: Pivot Tables for Data Analysis【CHN】中英文字幕[SRT]
==========教程信息=====================================================
教程名称：Excel 2007: Pivot Tables for Data Analysis
作者：Curt Frye
主题：Business, Data Analysis
使用软件：Excel 2007
难度等级：中级
时长： 2h 45m
发布日期： Nov 05, 2009
┏ACELY STUDIO，2012
┃更多资源请访问
┃◆唯一发布站：ACELY.CN
┗◆我的博客：http://blog.sina.com.cn/u/1991840741
==========教程目录文件列表=============================================
Excel 2007- Pivot Tables for Data Analysis[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 Using the exercise files.srt
├─◆1. Creating and Pivoting PivotTable Reports
│ └─◇ 0101 Introducing PivotTable reports.srt
│ └─◇ 0102 Formatting data for use in a PivotTable report.srt
│ └─◇ 0103 Creating a PivotTable report.srt
│ └─◇ 0104 Pivoting a PivotTable report.srt
│ └─◇ 0105 Configuring a PivotTable report.srt
│ └─◇ 0106 Connecting to an external data source.srt
│ └─◇ 0107 Consolidating data from multiple sources.srt
│ └─◇ 0108 Updating and refreshing PivotTable data sources.srt
├─◆2. Summarizing PivotTable Data
│ └─◇ 0201 Adding, removing, and positioning subtotals and grand totals.srt
│ └─◇ 0202 Changing the data field summary operation.srt
│ └─◇ 0203 Summarizing more than one data field.srt
│ └─◇ 0204 Creating a calculated field.srt
│ └─◇ 0205 Drilling down to the underlying data.srt
│ └─◇ 0206 Grouping fields.srt
│ └─◇ 0207 Using PivotTable data in a formula.srt
├─◆3. Sorting and Filtering PivotTable Data
│ └─◇ 0301 Sorting PivotTable data.srt
│ └─◇ 0302 Creating a custom sort order.srt
│ └─◇ 0303 Filtering by selection.srt
│ └─◇ 0304 Filtering by a rule.srt
│ └─◇ 0305 Filtering with report filter fields.srt
│ └─◇ 0306 Clearing and reapplying filters.srt
├─◆4. Formatting PivotTable Reports
│ └─◇ 0401 Applying a style.srt
│ └─◇ 0402 Creating and editing styles.srt
│ └─◇ 0403 Changing the layout.srt
│ └─◇ 0404 Changing the data field number format.srt
├─◆5. Emphasizing Data Using Conditional Formatting
│ └─◇ 0501 Highlighting cells by applying a rule.srt
│ └─◇ 0502 Highlighting the top or bottom value in a report.srt
│ └─◇ 0503 Formatting cells using data bars.srt
│ └─◇ 0504 Formatting cells using color scales.srt
│ └─◇ 0505 Formatting cells using icon sets.srt
│ └─◇ 0506 Editing conditional formatting rules.srt
│ └─◇ 0507 Controlling how Excel applies multiple conditional formatting rules.srt
│ └─◇ 0508 Deleting conditional formatting rules.srt
├─◆6. Creating and Manipulating PivotChart Reports
│ └─◇ 0601 Creating a PivotChart report.srt
│ └─◇ 0602 Pivoting a PivotChart report.srt
│ └─◇ 0603 Filtering a PivotChart report.srt
│ └─◇ 0604 Formatting a PivotChart report.srt
│ └─◇ 0605 Changing the layout.srt
│ └─◇ 0606 Changing the chart type.srt
│ └─◇ 0607 Adding a trendline.srt
├─◆7. Printing PivotTable and PivotChart Reports
│ └─◇ 0701 Printing a PivotTable report.srt
│ └─◇ 0702 Printing each item on its own page.srt
│ └─◇ 0703 Printing a PivotChart report.srt
├─◆Conclusion
│ └─◇ Goodbye.srt
◇
【本字幕由ACELY.CN独家制作发布】
┏
┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译，对翻译结果中不当内容不承担任何责任！
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载！
┗