Lynda.Com Excel 2007 Formatting Data iRONiSO

[Admin]

Lynda.Com Excel 2007 Formatting Data iRONiSO

Size :313MB

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.

Course Contents

Introduction
Welcome
Using the exercise files

1.Numeric Formatting Tools: Adjusting Numeric Formats Quickly
Working with the Numeric Formatting options
Learning the important formatting keystroke shortcuts
Setting special formats for dates, times, phone numbers, fractions, etc.
Building custom numeric formats
Building custom date formats

2.Fonts, Borders, and Cell Colors: Controlling Display Features
Applying and adjusting fonts and font colors
Adding custom formats with font color variations
Applying underline, strikethrough, subscript, and superscript formatting
Applying border styles and adjusting gridlines
Using fill color and patterns for cell backgrounds

3.Alignment Tools
Adjusting horizontal and vertical cell alignment
Creating angled text variations for greater variety and readability
Indenting data and dollar signs 02:27 3.1 MB
Simplifying title adjustments with the versatile Merge and Center commands
Controlling titles and headings with the Wrap Text and Shrink to Fit options

4.Other Valuable Formatting Tools
Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar
Applying different formatting styles within the same cell
Copying formats quickly with dragging techniques and the Format Painter
Formatting text from Word or the web with the Justify feature
Adding a background image to a worksheet

5.Row, Column, and Sheet Adjustments
Adjusting single and multiple row heights and column widths without commands
Working with rows, columns, and sheets
Working with the Hide/Unhide options

6.Displaying Data as an Outline
Setting up data for outlining
Using outlining symbols and levels

7.Essential Data Visualization Tools: Tables, Themes, Styles, and More
Converting data into a table and reformatting
Applying combinations of formats for selected cells
Setting themes for workbook-wide adjustments of colors, fonts, and effects
Understanding the options in Shape formatting
Fine-tuning shape effects
Learning the WordArt essentials for titles and headings

8.Adding Stunning Visual Effects to Pictures
Converting a chart to a picture and adding new images
Applying picture styles in a flash for added flair
Applying picture shapes and borders

9.Conditional Formatting: A Dynamic and Powerful Way to Accentuate Data
Creating value-based formatting using logical operators
Creating value-based formatting using data bars and color scales
Creating formats based on formulas

10.Specialized Power Formatting Techniques
Hiding repeating titles in a column to clarify printed output
Restoring missing title data in a column
Displaying large values without using formulas
Creating Elbow formatting to show row/column headings in the same cell
Removing the hyperlink attribute from multiple cells
Formatting a list for double-spaced printing

Download Links

Code:


http://hotfile.com/dl/33737593/9b2b051/LDCEXCL2007FMDRONiSO.part1.rar.html
http://hotfile.com/dl/33737107/b4ff36d/LDCEXCL2007FMDRONiSO.part2.rar.html
http://hotfile.com/dl/33737152/b1eb5c0/LDCEXCL2007FMDRONiSO.part3.rar.html
http://hotfile.com/dl/33737657/75aa839/LDCEXCL2007FMDRONiSO.part4.rar.html

No Password