【Lynda】Managing and Analyzing Data in Excel【CHN】中英文字幕[SRT]
==========教程信息=====================================================
教程名称：Managing and Analyzing Data in Excel
作者：Dennis Taylor
主题：Business, Data Analysis
使用软件：Excel 2007, 2010
难度等级：适合所有人
时长： 1h 32m
发布日期： Oct 27, 2011
┏ACELY STUDIO，2012
┃更多资源请访问
┃◆唯一发布站：ACELY.CN
┗◆我的博客：http://blog.sina.com.cn/u/1991840741
==========教程目录文件列表=============================================
Managing and Analyzing Data in Excel[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 Using the exercise files.srt
├─◆1. Sorting Data
│ └─◇ 0101 Sorting from the Sort menu.srt
│ └─◇ 0102 Sorting from the toolbar.srt
│ └─◇ 0103 Multi-key sorting.srt
│ └─◇ 0104 Sorting based on the order of data in custom lists.srt
│ └─◇ 0105 Sorting by color font, color background, or icon.srt
│ └─◇ 0106 Sorting columns.srt
│ └─◇ 0107 Sorting data in random order.srt
├─◆2. Filtering Data
│ └─◇ 0201 Using single- and multiple-column text filtering.srt
│ └─◇ 0202 Taking a look at special numeric filters.srt
│ └─◇ 0203 Harnessing special date filters.srt
│ └─◇ 0204 Creating a top-ten list by value or percent.srt
│ └─◇ 0205 Creating custom filters.srt
│ └─◇ 0206 Copying and sorting filtered lists.srt
│ └─◇ 0207 Recognizing the limitations of standard filtering.srt
├─◆3. Creating Automatic Subtotals in Sorted Lists
│ └─◇ 0301 Setting up subtotals.srt
│ └─◇ 0302 Creating multiple levels and copying subtotals.srt
├─◆4. Using Advanced Filters
│ └─◇ 0401 Using the Advanced Filter for complex OR criteria.srt
│ └─◇ 0402 Using the Advanced Filter for complex multiple-field criteria.srt
│ └─◇ 0403 Using the Advanced Filter to create unique lists from repeating field data.srt
├─◆5. Eliminating Duplicate Data
│ └─◇ 0501 Using the Remove Duplicates command.srt
│ └─◇ 0502 Using a specialized array formula to identify data that’s been duplicated.srt
│ └─◇ 0503 Using an array formula to count the number of unique items in a list.srt
├─◆6. Using Database Analysis Tools
│ └─◇ 0601 Using SUMIF, COUNTIF, and related functions for quick data analysis.srt
│ └─◇ 0602 Using database functions like DSUM, DAVERAGE, and DMAX.srt
├─◆Conclusion
│ └─◇ Next steps.srt
◇
【本字幕由ACELY.CN独家制作发布】
┏
┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译，对翻译结果中不当内容不承担任何责任！
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载！
┗