【Lynda】Excel 2007: Advanced Formatting Techniques【CHN】中英文字幕[SRT]
==========教程信息=====================================================
教程名称：Excel 2007: Advanced Formatting Techniques
作者：Dennis Taylor
主题：Business, Spreadsheets
使用软件：Excel 2007
难度等级：中级
时长： 3h 8m
发布日期： Mar 19, 2010
┏ACELY STUDIO，2012
┃更多资源请访问
┃◆唯一发布站：ACELY.CN
┗◆我的博客：http://blog.sina.com.cn/u/1991840741
==========教程目录文件列表=============================================
Excel 2007- Advanced Formatting Techniques[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 Using the exercise files.srt
├─◆1. Numeric Formatting Tools- Adjusting Numeric Formats Quickly
│ └─◇ 0101 Working with the Numeric Formatting options.srt
│ └─◇ 0102 Learning the important formatting keystroke shortcuts.srt
│ └─◇ 0103 Setting special formats for dates, times, phone numbers, fractions, etc..srt
│ └─◇ 0104 Building custom numeric formats.srt
│ └─◇ 0105 Building custom date formats.srt
├─◆2. Fonts, Borders, and Cell Colors- Controlling Display Features
│ └─◇ 0201 Applying and adjusting fonts and font colors.srt
│ └─◇ 0202 Adding custom formats with font color variations.srt
│ └─◇ 0203 Applying underline, strikethrough, subscript, and superscript formatting.srt
│ └─◇ 0204 Applying border styles and adjusting gridlines.srt
│ └─◇ 0205 Using fill color and patterns for cell backgrounds.srt
├─◆3. Alignment Tools
│ └─◇ 0301 Adjusting horizontal and vertical cell alignment.srt
│ └─◇ 0302 Creating angled text variations for greater variety and readability.srt
│ └─◇ 0303 Indenting data and dollar signs.srt
│ └─◇ 0304 Simplifying title adjustments with the versatile Merge and Center commands.srt
│ └─◇ 0305 Controlling titles and headings with the Wrap Text and Shrink to Fit options.srt
├─◆4. Other Valuable Formatting Tools
│ └─◇ 0401 Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar.srt
│ └─◇ 0402 Applying different formatting styles within the same cell.srt
│ └─◇ 0403 Copying formats quickly with dragging techniques and the Format Painter.srt
│ └─◇ 0404 Formatting text from Word or the web with the Justify feature.srt
│ └─◇ 0405 Adding a background image to a worksheet.srt
├─◆5. Row, Column, and Sheet Adjustments
│ └─◇ 0501 Adjusting single and multiple row heights and column widths without commands.srt
│ └─◇ 0502 Working with rows, columns, and sheets.srt
│ └─◇ 0503 Working with the Hide Unhide options.srt
├─◆6. Displaying Data as an Outline
│ └─◇ 0601 Setting up data for outlining.srt
│ └─◇ 0602 Using outlining symbols and levels.srt
├─◆7. Essential Data Visualization Tools- Tables, Themes, Styles, and More
│ └─◇ 0701 Converting data into a table and reformatting.srt
│ └─◇ 0702 Applying combinations of formats for selected cells.srt
│ └─◇ 0703 Setting themes for workbook-wide adjustments of colors, fonts, and effects.srt
│ └─◇ 0704 Understanding the options in Shape formatting.srt
│ └─◇ 0705 Fine-tuning shape effects.srt
│ └─◇ 0706 Learning the WordArt essentials for titles and headings.srt
├─◆8. Adding Stunning Visual Effects to Pictures
│ └─◇ 0801 Converting a chart to a picture and adding new images.srt
│ └─◇ 0802 Applying picture styles in a flash for added flair.srt
│ └─◇ 0803 Applying picture shapes and borders.srt
├─◆9. Conditional Formatting- A Dynamic and Powerful Way to Accentuate Data
│ └─◇ 0901 Creating value-based formatting using logical operators.srt
│ └─◇ 0902 Creating value-based formatting using data bars and color scales.srt
│ └─◇ 0903 Creating formats based on formulas.srt
├─◆10. Specialized Power Formatting Techniques
│ └─◇ 1001 Hiding repeating titles in a column to clarify printed output.srt
│ └─◇ 1002 Restoring missing title data in a column.srt
│ └─◇ 1003 Displaying large values without using formulas.srt
│ └─◇ 1004 Creating Elbow formatting to show row column headings in the same cell.srt
│ └─◇ 1005 Removing the hyperlink attribute from multiple cells.srt
│ └─◇ 1006 Formatting a list for double-spaced printing.srt
├─◆Conclusion
│ └─◇ Goodbye.srt
◇
【本字幕由ACELY.CN独家制作发布】
┏
┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译，对翻译结果中不当内容不承担任何责任！
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载！
┗