【Lynda】Cleaning Up Your Excel Data【CHN】中英文字幕[SRT]

作者: acely. 分类: Lynda中文字幕, ◇ 商业办公

==========教程信息=====================================================
教程名称:Cleaning Up Your Excel Data
作者:Dennis Taylor
主题:Business, Spreadsheets
使用软件:Excel 2007, 2010
难度等级:适合所有人
时长: 1h 26m
发布日期: Nov 01, 2011

┏ACELY STUDIO,2012
┃更多资源请访问
┃◆唯一发布站:ACELY.CN
┗◆我的博客:http://blog.sina.com.cn/u/1991840741

==========教程目录文件列表=============================================
Cleaning Up Your Excel Data[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 Using the exercise files.srt
├─◆1. Readjusting Data Layouts
│ └─◇ 0101 Moving and inserting rows and columns of data with a simple drag.srt
│ └─◇ 0102 Using one-dimensional and two-dimensional transpositions.srt
│ └─◇ 0103 Using Text to Columns for data management and cleanup.srt
├─◆2. Replacing Data at the Character Level
│ └─◇ 0201 Harnessing the Find and Replace commands.srt
│ └─◇ 0202 Dealing with special characters and using wildcards.srt
│ └─◇ 0203 Getting rid of leading single quotes.srt
│ └─◇ 0204 Removing trailing minus signs while converting data to negative.srt
├─◆3. Adjusting Date-Like Data
│ └─◇ 0301 Converting dates with text functions.srt
│ └─◇ 0302 Using Text to Column for selected date formats.srt
│ └─◇ 0303 Using the DATEVALUE and TIMEVALUE functions.srt
│ └─◇ 0304 Converting between time units.srt
│ └─◇ 0305 Converting to or from Julian dates.srt
├─◆4. Number-Text Conversion Issues
│ └─◇ 0401 Converting text data to values.srt
│ └─◇ 0402 Error-checking options with Convert to Number.srt
│ └─◇ 0403 Managing leading zeroes in zip, numerical, and text codes.srt
├─◆5. Checking Spelling
│ └─◇ 0501 Correcting multiple misspellings.srt
│ └─◇ 0502 Using additional Spelling options.srt
├─◆6. Specialized Techniques
│ └─◇ 0601 Combining data from different columns via concatenation.srt
│ └─◇ 0602 Reviewing text functions.srt
│ └─◇ 0603 Splitting data into multiple columns via Text to Columns.srt
│ └─◇ 0604 Filling in missing title information.srt
├─◆Conclusion
│ └─◇ Next steps.srt

【本字幕由ACELY.CN独家制作发布】


┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译,对翻译结果中不当内容不承担任何责任!
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载!


>>>>>>>【点我下载】<<<<<<<

您的留言是我最大的支持!

你必须登录才能发表评论!

※ 本站内容未经允许一律严禁转载!Lynda教程及字幕交流群:214645753
※ 本站文件统一解压密码:acely.cn 或 www.cgsub.com