Essential Guide to Office for the Web: HTML, Static and Dynamic Publishing
This comprehensive guide covers essential aspects of using Office for the Web, including HTML fundamentals, static and dynamic publishing techniques, and web queries with Excel. Learn how to browse, build, and publish web pages effectively, integrate features through Internet Explorer, and manage your FAS account and server space. Explore core HTML component basics, secure FTP, and telnet, along with advanced options for publishing content from Word, Excel, PowerPoint, and Access. Perfect for managers looking to enhance their web-enabled operations.
Essential Guide to Office for the Web: HTML, Static and Dynamic Publishing
E N D
Presentation Transcript
ISMT E-120 Desktop Applications for Managers Office for the Web
Office for the Web • HTML & Server Basics • Browsing • Static Publishing • Web Query with Excel • Dynamic publishing • Integration Through Internet Explorer
Office for the Web • HTML/Server Intro and Basics • Browsing • Static Publishing • Web Query with Excel • Dynamic publishing • Integration Through Internet Explorer
HTML/Server Intro and Basics • Your FAS account/server space • Basic HTML components • Secure FTP and telnet • Build and publish a page • Build and publish with an editor
Office for the Web • Browsing • Static Publishing • HTML/Server Intro and Basics • Web Query with Excel • Dynamic publishing • Integration Through Internet Explorer
Browsing • Word - Good • Excel – Pretty good • PowerPoint – No • Access – No
Office for the Web • Web-Enabled Features • Browsing • Static Publishing • HTML/Server Intro and Basics • Web Query with Excel • Dynamic publishing • Integration Through Internet Explorer
Static Publishing • Word: Save as Web Page • Excel: Save as Web Page • PowerPoint: Save as Web Page • Access: Export as a Web Page
Static Publishing: Word • Office Component Most Suited to Publishing Web Pages
Word: What Works Well • Text Basics - <P>, indents, basic tables, justification • Character Format Basics • Bold, Italic • Color • Underline • Hyperlinks • Lists • Bulleted • Numbered
Word: What Works Quite Well • Pictures • Convert to GIF files • Unless already JPEG • Charts, Equations, OLE objects • Convert to GIF files • Fonts • Fixed vs. Proportional • Special fonts are often lost • Point Size – relative size only
Fancy Character Formats Shadow, emboss Drop character Drawings Animations Fancy Page Layout Headers, Footers Footnotes, end notes Fancy Text Revision marks, comments Columns Text borders Word: What May Work with Some Variability
Static Publishing: Continued • Excel • Worksheets • Charts • PowerPoint • HTML • PowerPoint Animation • Access
Excel: What Works Well • Text, Numbers, Numeric Formats • Table Structures • Basic Formatting
Excel: What Works Quite Well • Table Formatting • Borders • Alignment • Background color • Hyperlinks • Can insert – may not updated correctly
Excel: What May Work With Some Variability • Some Cell Formatting • Patterns • Wrapping • Formulas
Static Publishing: PowerPoint • HTML • PowerPoint Animation
Static Publishing: Access • Export database objects • Tables • Reports • Forms
Office for the Web • HTML/Server Intro and Basics • Browsing • Static Publishing • Web Query with Excel • Dynamic publishing • Integration Through Internet Explorer
Web Query with Excel • Dynamic Web Query with Excel
Office for the Web • Web-Enabled Features • Browsing • Static Publishing • HTML/Server Intro and Basics • Web Query with Excel • Dynamic publishing • Integration Through Internet Explorer
Dynamic Publishing Example • CGI-enabled example – current grade query
Office for the Web • Web-Enabled Features • Browsing • Static Publishing • HTML/Server Intro and Basics • Web Query with Excel • Dynamic publishing • Integration Through Internet Explorer
Integration Through Internet Explorer • Internet Explorer as a Container
