Excel Web Feature - Microsoft Office - Lecture Slides, Slides of MS Microsoft Office skills

Here are some tutorials on MS office. Explaining excel and other features. This tutorial includes: Excel Web Feature, Dynamic Web Page, Manipulate the Data, Complete File Management Tasks, Saving an Excel Workbook, Browser, Saving an Excel Chart

Typology: Slides

2013/2014

Uploaded on 01/29/2014

jamil
jamil 🇮🇳

4

(12)

139 documents

1 / 28

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Excel Web Feature
Creating Static and Dynamic
Web Pages Using Excel
docsity.com
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18
pf19
pf1a
pf1b
pf1c

Partial preview of the text

Download Excel Web Feature - Microsoft Office - Lecture Slides and more Slides MS Microsoft Office skills in PDF only on Docsity!

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
  • Complete file management tasks with Excel

Previewing the Workbook

as a Web Page

Previewing the Workbook

as a Web Page

  • Click Web Page Preview

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

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

Saving an Excel Workbook as a Static

Web Page to a Newly Created Folder

Saving an Excel Workbook as a Static

Web Page to a Newly Created Folder

  • Click the OK button in the New Folder dialog box

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

Viewing and Manipulating the Static

Web Page Using a Browser

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

Saving an Excel Chart

as a Dynamic Web Page

Saving an Excel Chart

as a Dynamic Web Page

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