Almost everyone using excel has at one point wanted to make a presentation look better whether it is a live presentation or you want to print something. Excel has a wealth of formatting features that will be covered in this OnDemand Video. In addition to seeing the best techniques for controlling the display of fonts, colors, and borders, this video will also provide you with the tools for formatting specific data types and a multiple methods for displaying your worksheets with zest and style.
Runtime: 92 minutes
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
All of your training, right here at Lorman.
Pay once and get a full year of unlimited training
in any format, any time!
- Live Webinars
- OnDemand Webinars
- MP3 Downloads
- Course Manuals
- Audio Recordings*
- Executive Reports
- White Papers and Articles
- Sponsored Live Webinars
Additional benefits include:
- State Specific Credit Tracker
- Members Only Newsletter
- All-Access Pass Course Concierge
* For audio recordings you only pay shipping
Questions? Call 877-296-2169 to speak with a real person.