Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-1
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Microsoft Excel 2007 – Level 1
ADDING VISUAL INTEREST TO WORKBOOKS
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-2
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Performance ObjectivesPerformance Objectives
• Save a workbook as a Web page• Create and modify a hyperlink• Insert symbols and special characters• Insert, size, move, and format a clip art image• Draw, format, and copy shapes• Insert, size, move, and format a picture image• Insert, format, and type text in a text box• Insert a picture image as a watermark• Insert and format SmartArt diagrams• Insert and format WordArt
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-3
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Save a Workbook as a Web PageSave a Workbook as a Web Page
Type a name
Click to displaySet Page Title
dialog box
Click to displayPublish as WebPage dialog box
Click the Office button, then Save As
Change Save as Type to Single File Web Page
(*.mht, *.mhtml)
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-4
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Publish as Web Page Dialog BoxPublish as Web Page Dialog Box
Check if you wantthe worksheet to
display automaticallyin the user’s default
Web browser
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-5
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Open a Workbook in Internet ExplorerOpen a Workbook in Internet Explorer
Open Internet Explorer
Click File, then Open
Navigate to the file by clicking
Browse;after locating the
file, click OK
Filename and
location
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-6
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Creating HyperlinksCreating Hyperlinks
A hyperlink is text or an object that you can click to go to a different file, an HTML page on the Internet, or an HTML page on an intranet
Click cell and type web address
By default, text that looks like a web address is automatically formatted as a
hyperlink
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-7
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Creating Hyperlinks…/2Creating Hyperlinks…/2
To turn off Automatic formatting of hyperlinks
Click the Office button, then Excel
Options
Click Proofing, then AutoCorrect Options
Clear checkbox
Click OK
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-8
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Creating Hyperlinks…/3Creating Hyperlinks…/3
Select text or image
Type Web address or filename
Click Insert tab
Then click the Hyperlink button
or Ctrl + K
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-9
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Modifying a HyperlinkModifying a Hyperlink
Right-click the hyperlink Right-click the hyperlinkTo EditTo Edit To RemoveTo Remove
Click Click
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-10
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Inserting Symbols / Special CharactersInserting Symbols / Special Characters
Click in desired cell, then click Insert tab, Symbol
button and double-click desired symbol
OR Click desired Symbol and click Insert Click
Change Font set
as desired
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-11
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Click in desired
cell, then
Insert tab
Click Symbol button and click Special Characters
tab
ORClick desired Character and click
Insert Click
Double click
Inserting Symbols/Special Characters.../2Inserting Symbols/Special Characters.../2
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-12
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Inserting Images in a WorkbookInserting Images in a Workbook
Insert a picture or clip art using buttons in the Illustrations group in
the Insert tab
The Picture Tools Format tab displays when inserting or selecting a picture
or ClipArt
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-13
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Inserting Images in a Workbook../2Inserting Images in a Workbook../2
Customize and format using options in Picture Tools Format tab
Recolor, Adjust Brightness and Contrast, Compress or Reset Picture
Apply Predesigned Styles
Position, align, text wrapping
and rotate image
Crop and Size
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-14
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Sizing an ImageSizing an Image
Drag sizing handles
Middle handles change width or height
Corner handles change width and height
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-15
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Moving and Deleting an ImageMoving and Deleting an Image
Moving an ImageMoving an ImagePosition pointer inside image until it displays as a four-headed arrow, then drag to desired position
Deleting an ImageDeleting an ImageSelect image andpress Delete key
To move an image in small increments, hold down the Ctrl key while pressing one of the
arrow keys on the keyboard
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-16
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Insert Clip Art in a WorkbookInsert Clip Art in a Workbook
Click the Insert tab, then Clip Art
Type desired topic in Search
BoxClick Go
Click desired image
Resize image using sizing handles
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-17
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Insert a Shape in a WorkbookInsert a Shape in a Workbook
Click Insert tab,
then Shapes button
Click desired Shape
Drag in worksheet to create Shape
To copy a Shape… Select
Shape, Click Copy button and
Paste in desired location
ORHold down
Ctrl key while
dragging Shape
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-18
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Insert a Picture in a WorkbookInsert a Picture in a Workbook
Insert a picture using buttons in the Illustrations group in the Insert tab
Navigate to folder and double-click
picture
Customize and format using options in Picture Tools Format
tab
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-19
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Insert a Picture in a Workbook…/2Insert a Picture in a Workbook…/2
Drag the image to the desired
position;use sizing handles to
change its size
Delete a selected image by pressing the Delete key or by right-clicking the picture and clicking
Delete at the shortcut menu
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-20
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Insert a Text Box in a WorkbookInsert a Text Box in a Workbook
Customize a text box – use Drawing Tools Format tab
Click the Insert tab, then Text Box
Drag in worksheet to create text box and type desired
textDivisionDelete by selecting
the text box and pressing the Delete
key
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-21
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Insert a Picture as a WatermarkInsert a Picture as a Watermark
A watermark is a lightened image that displays behind data in a file. Watermark functionality is not
available in Excel, but you can insert a picture in a header or footer and then resize and format it to display behind
each page of the worksheet
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-22
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Insert a Picture as a Watermark…/2Insert a Picture as a Watermark…/2
Click the Insert tab , then Header and Footer
Click the Picture button Navigate to desired
picture and double click
Resize and format using the Format
Picture button
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-23
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Insert SmartArt DiagramsInsert SmartArt Diagrams
Click the Insert tab, then Smart Art button
Double-click desired diagram
Read a description of
the graphic here
Choose graphic
category from
options in this panel
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-24
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Insert SmartArt Diagrams…/2Insert SmartArt Diagrams…/2
Select the Shape in the diagram and type
desired text
Click the Text Pane button to type into the Text Pane box
SmartArt Tools Design tab,
Create Graphic group
OR
Click the Text Pane button again to close Text Pane
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-25
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Insert a SmartArt Diagram…/3Insert a SmartArt Diagram…/3
Select the diagram, then click theDesign tab to use the SmartArt Tools
Change diagram layout, add objects, apply a style or reset to original
formatting
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-26
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Creating WordArtCreating WordArt
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-27
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Creating WordArt…/2Creating WordArt…/2
Click the Insert tab then the WordArt button
Type desired text
here
Choose desired
style
Use white sizing
handles to change
height and widthMove the Text box by dragging
a border when mouse pointer changes to a four-headed
arrowTo remove WordArt style from text and retain the text,
click the More button in the WordArt Styles group and
click Clear WordArt
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-28
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
How do you save a Workbook as a Web page?
Click to displaySet Page Title
dialog box
Click to displayPublish as WebPage dialog box
Click the Office button, then Save As
Change Save as Type to Single file web page
(*.mht, *.mhtml)
Type a name
Features Summary
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-29
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
How do you preview a Web page?Open Internet Explorer
Click file, then Open
Navigate to the file by clicking Browse,
then click OK
Filename
Features Summary
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-30
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
How do you insert a Hyperlink?
Click cell and type web address
Features Summary
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-31
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Click Insert tab, Hyperlink button or Ctrl + K
How do you display the Insert Hyperlink Dialog Box?
Features Summary
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-32
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
How do you display the Symbol dialog box?
Click Symbol button
Features Summary
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-33
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
How do you display the Clip Art task pane?
Click the Insert tab, then Clip Art
Features Summary
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-34
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
How do you insert a SmartArt Graphic?
Click the Insert tab,
then SmartArt button
Double-click
desired diagram
Features Summary
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-35
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
How do you insert WordArt?
Click the Insert tab then the WordArt button
Choose desired
style
Features Summary
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-36
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
How do you insert a Text Box?
Click the Insert tab, then Text Box
Features Summary
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-37
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
How do you insert a Picture?
Click Insert, then Picture and navigate to
the desired picture
Features Summary
Copyright 2007, Paradigm Publishing Inc.
EXCEL 2007Chapter 8
BACK NEXT END
8-38
LINKS TO
OBJECTIVES• Save a Workbook as
a Web Page• Create and Modify a
Hyperlink• Insert Symbols and
Special Characters• Insert, Format, Size,
Move, and Delete Images
• Insert Clip Art• Draw, Format and
Copy Shapes• Insert, Size , Move
and Format a Picture• Insert a Text Box• Insert a Watermark• Insert and Format
SmartArt Diagrams• Insert and Format
WordArt• Features Summary
Coming NextComing Next
ASSESSING PROFICIENCY