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

游客，本帖隐藏的内容需要积分高于 1 才可浏览，您当前积分为 0

资源信息： 中文名: Excel 2007数据处理教程 英文名: Lynda.Com.Excel.2007.Formatting.Data 资源格式: 光盘镜像 发行日期: 2010年03月19日 地区: 美国 对白语言: 英语 文字语言: 英文 概述:

资源简介: Lynda出品的Excel 2007: Formatting Data. 数据处理教程. 主讲：Dennis Taylor 教学时长：3小时8分 教学光盘提供有配套素材文件. Description： 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

目录: 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 资源来自网络收集 未经过一一的质量 安全等检测 只是把收集的资源和各位驴友分享 仅作网络学习交流使用 请勿用于商业用途 ! 希望各位下载的驴友能多多参与分流保源