中文名: 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

資源來自網絡收集 未經過一一的質量 安全等檢測
只是把收集的資源和各位驢友分享 僅作網絡學習交流使用 請勿用於商業用途 !
希望各位下載的驢友能多多參與分流保源