1 / 34

Excel 2002

Excel 2002. Chapter 8. Enhancing the Display of Workbooks. Performance Objectives. Save an Excel workbook as a Web page Preview a Web page using Web Page Preview Create and modify a hyperlink Insert, size, move, and format a clip art image Create, size, move, and customize WordArt

josephlucas
Download Presentation

Excel 2002

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel 2002 Chapter 8 Enhancing the Display of Workbooks

  2. Performance Objectives • Save an Excel workbook as a Web page • Preview a Web page using Web Page Preview • Create and modify a hyperlink • Insert, size, move, and format a clip art image • Create, size, move, and customize WordArt • Draw and customize shapes, lines, and autoshapes using buttons on the Drawing toolbar

  3. Saving as a Web Page key a name click Save

  4. Preview in Web Page Preview

  5. Creating Hyperlinks automatic formatting of hyperlinks when a web address is typed, it is formatted as a hyperlink (underlined and blue) to turn off automatic formatting… Tools, AutoCorrect Options remove the check mark

  6. Creating Hyperlinks select text or image Insert Hyperlink button or Insert, Hyperlink enter Web address link to other files or programs

  7. Modifying a Hyperlink edit right-click hyperlink remove right-click hyperlink

  8. narrowing a search Inserting Images Insert Clip Art on Drawing toolbar or

  9. Sizing, Moving, or Deleting an Image Sizing • drag sizing handles • middle sizing handles resizes one direction • corner sizing handles changes width and height Moving Deleting select image and press Delete key position pointer inside image and drag to desired position

  10. Picture Toolbar Insert Picture Color More Contrast Less Contrast More Brightness Less Brightness Crop Rotate Left Line Style Compress Pictures Format Picture Set Transparent Color Reset Picture

  11. Downloading Images Insert, Picture, Clip Art… must have Internet access search download or copy and paste into Excel

  12. Creating WordArt distort or modify text Company Logos Headings

  13. Creating WordArt double-click a style OR

  14. Entering Text press Enter if you want to move to the next line

  15. Sizing and Moving Sizing drag sizing handles Moving drag with four-headed arrow delete by pressing Delete key

  16. WordArt Toolbar Insert WordArt Edit Text WordArt Gallery Format WordArt WordArt Shape WordArt Same Letter Heights WordArt Vertical Text WordArt Alignment WordArt Character Spacing

  17. Format WordArt use options to customize

  18. Changing Shapes

  19. Drawing Toolbar Drawing button OR right-click on a toolbar click Drawing at drop-down list

  20. Drawing Toolbar Draw Select Objects AutoShapes Line Arrow Fill Color Rectangle Insert Picture Oval Insert Clip Art Text Box Line Color Font Color Insert WordArt Line Style Insert Diagram or Organization Chart Dash Style Arrow Style Shadow Style 3-D Style

  21. Drawing Shapes double-click the shape button to draw the same shape more than once - after drawing, click the buttonagain to deactivate it line drawing hold down the Shift key while drawing to keep all sides equal/straight - circle- square- line enclosed object

  22. Changing Colors Adding Fill Color Changing Line Color

  23. Aligning and Distributing

  24. Creating AutoShapes click desired shape - drag and draw

  25. Flipping and Rotating

  26. Commands Review How do you save a workbook as a Web page?

  27. Commands Review How do you preview a workbook in Web Page Preview?

  28. Commands Review How do you create a hyperlink? select text or image Insert Hyperlink button or Insert, Hyperlink

  29. Commands Review How do you display the Insert Clip Art Task Pane? Insert Clip Art on Drawing toolbar or

  30. Commands Review How do you display the Microsoft Design Gallery Live Web site? Insert, Picture, Clip Art… must have Internet access

  31. Commands Review How do you display the WordArt Gallery? double-click a style OR

  32. Commands Review How do you display the Format WordArt dialog box?

  33. Commands Review How do you display the Drawing toolbar? Drawing button OR right-click on a toolbar click Drawing at drop-down list

  34. Coming Next Workplace Ready Assessing Proficiency

More Related