Transcript Tutorial 2: Formatting a Workbook

Excel Tutorial 2:
Formatting a Workbook
Microsoft Office 2010
®
What You Will Do In Tutorial 2
XP
•
•
•
•
Format text, numbers, and dates
Change fonts and font colors
Add fill colors and background images
Create formulas to add, subtract, and divide
values
• Apply number formats
• Align, indent, and rotate cell contents
2
What You Will Do In Tutorial 2
•
•
•
•
•
•
XP
Merge a range into a single cell
Copy and paste formats
Apply built-in cell styles
Change the theme of a workbook
Create formulas to add and subtract values
Apply a built-in table style and select table
style options
3
Objectives
XP
• Highlight cells with conditional formats
• Hide worksheet rows
• Define the print area, insert page breaks, and
add print titles
• Create headers and footers
• Select page margins
4
Visual Overview
XP
5
Worksheet Formatting
XP
6
XP
Working with Colors and Backgrounds
• Changing a fill color
7
XP
Working with Colors and Backgrounds
• Background images do not print
8
Formatting Calculated Values
XP
• Create formulas to add, subtract, and divide
values
9
Applying Number Formats
XP
10
XP
Options in the Format Cells Dialog Box
• Border tab
11
Copying and Pasting Formats
XP
• Use Paste Options Button to paste formatting
from a copied range along with its contents
12
Visual Overview
XP
13
XP
Table Styles and Page Formatting
14
Applying Cell Styles
XP
15
Working with Themes
XP
16
Creating Formulas to Add and
Subtract Values
XP
• Use this data to identify trends
17
Working with Table Styles
XP
• Specifies formats (e.g., font color, fill color) for
each element
• More efficient than formatting individual cells
• Ensures that table’s formatting reflects any
changes made to the table
18
Selecting Table Style Options
XP
19
Highlighting Cells with Conditional
Formats
XP
• Always include a legend – a key that shows
each color used in the worksheet and what it
means
20