1 / 28

Excel Web Feature

Excel Web Feature. Creating Static and Dynamic Web Pages Using Excel. Objectives. Publish a worksheet and chart as a static or a dynamic Web page Display Web pages published in Excel in a browser Manipulate the data in a published Web page using a browser

shandi
Télécharger la présentation

Excel Web Feature

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 Web Feature Creating Static and Dynamic Web Pages Using Excel

  2. Objectives • Publish a worksheet and chart as a static or a dynamic Web page • Display Web pages published in Excel in a browser • Manipulate the data in a published Web page using a browser • Complete file management tasks with Excel

  3. Previewing the Workbook as a Web Page • Insert the Data Disk in drive A • Start Excel and then open the workbook, Home Wireless Fidelity Quarterly Sales, on drive A • Click File on the menu bar

  4. Previewing the Workbook as a Web Page

  5. Previewing the Workbook as a Web Page • Click Web Page Preview

  6. Previewing the Workbook as a Web Page • Click the 3-D Pie Chart tab at the bottom of the Web page

  7. Previewing the Workbook as a Web Page • After viewing the Web page preview of the Home Wireless Fidelity Quarterly Sales workbook, click the Close button on the right side of the browser title bar

  8. Saving an Excel Workbook as a Static Web Page to a Newly Created Folder • With the Home Wireless Fidelity Quarterly Sales workbook open, click File on the menu bar

  9. Saving an Excel Workbook as a Static Web Page to a Newly Created Folder • Click Save as Web Page • When Excel displays the Save As dialog box, type Home Wireless Fidelity Quarterly Sales Static Web Page in the File name text box • Click the Save as type box arrow and then click Single File Web Page • Click the Save in box arrow, select 3½ Floppy (A:), and then click the Create New Folder button • When Excel displays the New Folder dialog box, type Web Feature in the Name text box

  10. Saving an Excel Workbook as a Static Web Page to a Newly Created Folder

  11. Saving an Excel Workbook as a Static Web Page to a Newly Created Folder • Click the OK button in the New Folder dialog box

  12. Saving an Excel Workbook as a Static Web Page to a Newly Created Folder • Click the Save button in the Save As dialog box • Click the Close button on the right side of the Excel title bar to quit Excel

  13. Viewing and Manipulating the Static Web Page Using a Browser • If necessary, insert the Data Disk in drive A • Click the Start button on the Windows taskbar, point to All Programs on the Start menu, and then click Internet Explorer on the All Programs submenu • When the Internet Explorer window appears, type a:\web feature\home wireless fidelity quarterly sales static web page.mht in the Address box and then press the ENTER key

  14. Viewing and Manipulating the Static Web Page Using a Browser

  15. Viewing and Manipulating the Static Web Page Using a Browser • Click the 3-D Pie Chart tab at the bottom of the window • Use the scroll arrows to display the lower portion of the chart • Click the Close button on the right side of the browser title bar to close the browser

  16. Saving an Excel Chart as a Dynamic Web Page • If necessary, insert the Data Disk in drive A • Start Excel and then open the workbook, Home Wireless Fidelity Quarterly Sales, on drive A • Click File on the menu bar

  17. Saving an Excel Chart as a Dynamic Web Page

  18. Saving an Excel Chart as a Dynamic Web Page • Click Save as Web Page • When Excel displays the Save As dialog box, type Home Wireless Fidelity Quarterly Sales Dynamic Web Page in the File name text box • Click the Save as type box arrow and then click Single File Web Page • If necessary, click the Save in box arrow, select 3½ Floppy (A:) in the Save in list, and then select the Web Feature folder

  19. Saving an Excel Chart as a Dynamic Web Page

  20. Saving an Excel Chart as a Dynamic Web Page • Click the Publish button • When Excel displays the Publish as Web Page dialog box, click the Choose box arrow and then click Items on 3-D Pie Chart • Click the Add interactivity with check box in the Viewing options area • If necessary, click the Add interactivity with box arrow and then click Chart functionality

  21. Saving an Excel Chart as a Dynamic Web Page

  22. Saving an Excel Chart as a Dynamic Web Page • Click the Publish button and then click the Close button on the right side of the Excel title bar, and if necessary, click the No button in the Microsoft Excel dialog box

  23. Viewing and Manipulating the Dynamic Web Page Using a Browser • Click the Start button on the taskbar, point to All Programs on the Start menu, and then click Internet Explorer on the All Programs submenu. • When the Internet Explorer window appears, type a:\web feature\home wireless fidelity quarterly sales dynamic web page.htm in the Address box and then press the ENTER key

  24. Viewing and Manipulating the Dynamic Web Page Using Your Browser

  25. Viewing and Manipulating the Dynamic Web Page Using Your Browser • Click cell A2 and then enter 1600000 as the new value

  26. Viewing and Manipulating the Dynamic Web Page Using Your Browser • Click the Close button on the right side of the browser title bar

  27. Summary • Publish a worksheet and chart as a static or a dynamic Web page • Display Web pages published in Excel in a browser • Manipulate the data in a published Web page using a browser • Complete file management tasks with Excel

  28. Excel Web Feature Complete

More Related