Excel Web Feature
Creating Static and Dynamic
Web Pages Using Excel
docsity.com
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
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
1 / 28
This page cannot be seen from the preview
Don't miss anything!
Related documents
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