【Lynda】Excel 2008 for Mac: Pivot Tables for Data Analysis【CHN】中英文字幕[SRT]
==========教程信息=====================================================
教程名称：Excel 2008 for Mac: Pivot Tables for Data Analysis
作者：Curt Frye
主题：Business, Data Analysis
使用软件：Excel for Mac 2008
难度等级：中级
时长： 1h 6m
发布日期： Sep 22, 2009
┏ACELY STUDIO，2012
┃更多资源请访问
┃◆唯一发布站：ACELY.CN
┗◆我的博客：http://blog.sina.com.cn/u/1991840741
==========教程目录文件列表=============================================
Excel 2008 for Mac- 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 Importing data from an external source.srt
│ └─◇ 0106 Consolidating data from multiple sources.srt
│ └─◇ 0107 Updating and refreshing data sources.srt
│ └─◇ 0108 Managing PivotTable reports.srt
├─◆2. Summarizing PivotTable Data
│ └─◇ 0201 Adding and removing 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 Grouping fields.srt
│ └─◇ 0206 Drilling down to the underlying data.srt
│ └─◇ 0207 Using data in a formula.srt
├─◆3. Sorting and Filtering PivotTable Data
│ └─◇ 0301 Sorting data.srt
│ └─◇ 0302 Creating a custom sort order.srt
│ └─◇ 0303 Filtering a field by selection or by rule.srt
│ └─◇ 0304 Filtering using report filter fields.srt
├─◆4. Formatting and Printing PivotTable Reports
│ └─◇ 0401 Changing the data field number format.srt
│ └─◇ 0402 Applying formats.srt
│ └─◇ 0403 Highlighting cells by applying a rule.srt
│ └─◇ 0404 Printing a PivotTable report.srt
├─◆Conclusion
│ └─◇ Goodbye.srt
◇
【本字幕由ACELY.CN独家制作发布】
┏
┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译，对翻译结果中不当内容不承担任何责任！
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载！
┗