Microsoft® Excel® Formatting Issues and Techniques

Agenda

Overview of the Home Tab Formatting Tools and the Format Cells Dialog Box – Thousands of Tools

Numeric Formatting Variations, Including Keystroke Shortcuts

Using Angled, Vertical, and Horizontal Text Displays for Variety and Improved Readability

Inserting/Deleting/Hiding/Revealing Columns and Rows With Speed and Assurance

Using Font Colors and Cell Background Colors

Using the Format Painter and Dragging Techniques to Quickly Copy Formats to Multiple Locations

Using Automatic Outlining to Instantly Expand and Collapse Row and Column Data

Applying Conditional Formatting (Colors, Icons, Other Formatting) Based on Content

Formatting Tools
• Saving Time With Keyboard Shortcuts
• Formatting Numeric Data With Cell Formats
• Using Conditional Formatting
• Hiding Repeating Column Information
• Printing Double-Spaced Data in a Flash
• Elbow Formatting
• Converting Data to a Table for Both Enhanced Visual and Analytic Capabilities
• Using Wrap Text, Merge and Center, and Shrink-To-Fit Options
• Controlling the Use of Gridlines and Borders for Printing and On-Screen Appearances
• Using Underline, Strikethrough, Subscript and Superscript Formatting
• Designing Your Own Custom Formatting for Numeric, Date and Time Cells
• Use Styles and Themes to Establish Consistent Visual Displays While Adding Additional Eye-Appeal
• Use Sparklines (For Excel® 2010 Users Only) to Quickly Display Numerical Data Via In-Cell Charts
• Use Built-In Formatting Tools for S.S. Numbers, Phone Numbers, Dates and Times

Faculty

Dennis Taylor

Taylor Associates

• Founder of Taylor Associates
• More than 20 years of experience working with Excel®
• Taught thousands of classes and seminars throughout the United States and Canada
• Presented more than 700 Excel® webinars and is the author or co-author of six books on spreadsheet software