Becoming effective with Excel

Objectives

To effectively use formatting techniques to present data in an Excel spreadsheet.

Targeted audience

Professionals and technicians

Content

Controlling Typography

• Adjusting fonts, size, and color
• Applying underline and strikethrough
• Adding borders and adjusting the grid
• Adjusting cell fill
• Adjusting vertical and horizontal alignment
• Indenting data
• Merging cells and centering
• Controlling text wrapping in a cell

Copying and Cleaning

• Quickly copying formats with the Format Painter
• Pasting with formats
• Removing formats
• Quick formats

Adding Polish

• Using shapes and text boxes
• Adding images
• Conditional formatting with criteria
• Using sparklines
• Creating angled text for better results
• Sheets linked as images

Templates and Themes

• Using an existing template
• Creating your own template
• Applying styles and themes

Preparing for Printing

• Custom header and footer
• Setting up repeating elements at the top of pages
• Print preview and making adjustments

Formatting Data

• Standard formats for numbers and dates
• Creating a custom format for numbers and dates
• Special formats: social security number, phone number, postal codes
• Formatting 24-hour periods

Excel Tables

• Creating a table
• Using existing styles and creating your own style

Groups and Outlines

• Creating automatic groups
• Opening and closing groups with control buttons
• Creating subtotals
• Ungrouping a group