《Excel 2007数据处理教程》(Lynda.Com.Excel.2007.Formatting.Data)[光盘镜像]

  • 状态: 精华资源
  • 摘要:
  • 时间: 2010/09/05 14:14:52 发布 | 2010/09/05 16:56:41 更新
  • 分类: 教育  计算机 


精华资源: 673

全部资源: 675

相关: 分享到新浪微博   转播到腾讯微博   分享到开心网   分享到人人   分享到QQ空间   订阅本资源RSS更新   美味书签  subtitle
中文名Excel 2007数据处理教程

IPB Image


Lynda出品的Excel 2007: Formatting Data. 数据处理教程.

主讲:Dennis Taylor




Making important information presentable is what sets successful business reports and presentations apart from staid, unintelligible data. In Excel 2007: Formatting Data, author Dennis Taylor shares simple and powerful tips for making information readable and understandable, including automation techniques that take the drudgery out of formatting even the largest amounts of data. This course covers techniques for accentuating and emphasizing specific cells and adding style and readability to worksheets. Exercise files accompany this course.

Topics include:
Saving time with keyboard shortcuts
Adjusting fonts, cell borders, and fills
Setting themes
Formatting numeric data with cell formats
Using the Conditional Formatting feature
Hiding repeating column information
Printing double-spaced data
Elbow formatting

IPB Image

IPB Image


Introduction 02:17
Welcome 01:35
Using the exercise files 00:42
29:32 1. Numeric Formatting Tools: Adjusting Numeric Formats Quickly
Working with the Numeric Formatting options 06:40
Learning the important formatting keystroke shortcuts 05:25
Setting special formats for dates, times, phone numbers, fractions, etc. 05:41
Building custom numeric formats 06:29
Building custom date formats 05:17
24:16 2. Fonts, Borders, and Cell Colors: Controlling Display Features
Applying and adjusting fonts and font colors 03:25
Adding custom formats with font color variations 03:15
Applying underline, strikethrough, subscript, and superscript formatting 05:26
Applying border styles and adjusting gridlines 07:10
Using fill color and patterns for cell backgrounds 05:00
17:46 3. Alignment Tools
Adjusting horizontal and vertical cell alignment 03:40
Creating angled text variations for greater variety and readability 03:13
Indenting data and dollar signs 02:27
Simplifying title adjustments with the versatile Merge and Center commands 03:16
Controlling titles and headings with the Wrap Text and Shrink to Fit options 05:10
19:56 4. Other Valuable Formatting Tools
Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar 04:09
Applying different formatting styles within the same cell 03:23
Copying formats quickly with dragging techniques and the Format Painter 05:55
Formatting text from Word or the web with the Justify feature 04:51
Adding a background image to a worksheet 01:38
21:38 5. Row, Column, and Sheet Adjustments
Adjusting single and multiple row heights and column widths without commands 07:00
Working with rows, columns, and sheets 07:26
Working with the Hide/Unhide options 07:12
08:05 6. Displaying Data as an Outline
Setting up data for outlining 05:40
Using outlining symbols and levels 02:25
22:31 7. Essential Data Visualization Tools: Tables, Themes, Styles, and More
Converting data into a table and reformatting 06:25
Applying combinations of formats for selected cells 02:56
Setting themes for workbook-wide adjustments of colors, fonts, and effects 02:44
Understanding the options in Shape formatting 04:09
Fine-tuning shape effects 03:46
Learning the WordArt essentials for titles and headings 02:31
07:44 8. Adding Stunning Visual Effects to Pictures
Converting a chart to a picture and adding new images 02:55
Applying picture styles in a flash for added flair 02:19
Applying picture shapes and borders 02:30
14:14 9. Conditional Formatting: A Dynamic and Powerful Way to Accentuate Data
Creating value-based formatting using logical operators 04:11
Creating value-based formatting using data bars and color scales 05:00
Creating formats based on formulas 05:03
20:20 10. Specialized Power Formatting Techniques
Hiding repeating titles in a column to clarify printed output 03:39
Restoring missing title data in a column 04:21
Displaying large values without using formulas 04:12
Creating Elbow formatting to show row/column headings in the same cell 03:06
Removing the hyperlink attribute from multiple cells 02:41
Formatting a list for double-spaced printing 02:21
00:17 Conclusion
Goodbye 00:17

资源来自网络收集 未经过一一的质量 安全等检测
只是把收集的资源和各位驴友分享 仅作网络学习交流使用 请勿用于商业用途 !
希望各位下载的驴友能多多参与分流保源 happy.gif






(?) [公告]留口水、评论相关规则 | [活动]每日签到 轻松领取电驴经验

  1. 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
  2. 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
  3. 勿催片。请相信驴友们对分享是富有激情的,如果确有更新版本,您一定能搜索到。
  4. 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。
  5. 如果您发现自己的评论不见了,请参考以上4条。