Excel Web Feature

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 Files for Students 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 USB flash
  drive, 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 Files for Students
  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 Files for Students
  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
  USB flash drive 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