Slide 1

Slide 2

Committed to Shaping the Next Generation of IT Experts. Robert T. Grauer, Ph. D. rgrauer@miami.edu Download this presentation from www.prenhall.com/grauer (Click link to Office 2003 on home page)www.prenhall.com/grauer Whats New in Microsoft Office 2003?

Slide 3

Robert Grauer 2004 www.prenhall.com/grauer From a Suite to a System... Microsoft Office has evolved from a suite of personal productivity products to a comprehensive and integrated system. Building on the familiar tools that many people already know, the Microsoft Office System includes servers, services, and desktop programs designed to work together to help address a broad array of business problems.

Slide 4

Robert Grauer 2004 www.prenhall.com/grauer So, Whats Really New... At the enterprise level it is all about sharing data, integration, and collaboration Tight integration between Office 2003 and SharePoint Services facilitates document sharing; no longer necessary to worry about large attachments or which version of a document you are working on. XML enables data to be shared across the enterprise without regard to the program or operating system At the individual level Its evolutionary rather than revolutionary; it is after all Office 11; but there are many worthwhile new features Whats New depends on what you are upgrading from; i.e., it is more dramatic from Office 2000 then from Office XP

Slide 5

Robert Grauer 2004 www.prenhall.com/grauer Servers and Services (Partial List) Microsoft Exchange Server 2003 E-mail based collaboration services with improved security, reliability, and ease of access Microsoft Office Live Communications Server 2003 Provides presence and instant messaging Microsoft SharePoint Portal Server 2003 Share documents from within Word, Excel, or PowerPoint Microsoft Office Live Meeting 2003 Enables real-time interactive presentations over the Internet for groups ranging from 2 to 2000 Microsoft Office Online Significantly enhanced Web site for all versions of Office

Slide 6

Robert Grauer 2004 www.prenhall.com/grauer The Microsoft Office 2003 Programs The Office Core programs: Microsoft Office Word 2003 Microsoft Office Excel 2003 Microsoft Office Outlook 2003 Microsoft Office PowerPoint 2003 Microsoft Office Access 2003 Other Office Programs: Microsoft Office Publisher 2003 Microsoft Office FrontPage 2003 Microsoft Office Project 2003 Microsoft Office Visio 2003 Microsoft Office OneNote 2003 - New in 2003! Microsoft Office InfoPath 2003 - New in 2003!

Slide 7

Robert Grauer 2004 www.prenhall.com/grauer Microsoft Office 2003 Editions Retail Editions choose carefully Professional Edition (Word, Excel, Outlook with Business Contact Manager, PowerPoint, Access, and Publisher) Small Business Edition (Word, Excel, Outlook with Business Contact Manager, PowerPoint, and Publisher) Standard Edition (Word, Excel, Outlook, and PowerPoint) Student and Teacher Edition (Word, Excel, Outlook, and PowerPoint) All programs can be purchased individually (OneNote and InfoPath are purchased separately) Click here for information on other editions (pre- installed, volume-licensed, and academic-licensed) Click here for information

Slide 8

Robert Grauer 2004 www.prenhall.com/grauer About the Upgrade Full compatibility in file formats between Office 2003, Office XP, and Office 2000. Word, Excel, PowerPoint formats are identical to those in Office 97 Access 2003 format is identical to Access 2002, but it uses the Access 2000 format by default External pressure to upgrade all new machines ship with Office 2003. Requires Windows 2000 with service pack (SP3), Windows XP, or a later version

Slide 9

Robert Grauer 2004 www.prenhall.com/grauer A New Web Site for Microsoft Office New logo for Office 2003, but the site applies to all versions of Office Test your knowledge of Office applications New address - office.microsoft.com

Slide 10

Robert Grauer 2004 www.prenhall.com/grauer What is XML? XML (eXtensible Markup Language) is an industry standard for structuring data across applications, operating systems, and hardware devices Latest of evolution of Markup Languages SGML Standardized General Markup Language HTML Hypertext Markup Language XML is data about data i.e., it describes the data and not the formatting

Slide 11

Robert Grauer 2004 www.prenhall.com/grauer So What is a Markup Language? Rich Text HTML XML 2 bedroom/2 bath $600 per month (305) 111-2222 2 bedroom/2 bath $600 per month (305) 111-2222 2 bedroom/2 bath $600 per month (305) 111-2222

Slide 12

Robert Grauer 2004 www.prenhall.com/grauer XML tags are created by the user Define additional tags as you need them What is eXtensible? 2 bedroom/2 bath Immediate Occupancy $600 per month Swimming pool; close to campus (305)111-2222 1 month

Slide 13

Robert Grauer 2004 www.prenhall.com/grauer A Simple XML Editor Notepad can be used to create and edit XML XML specification (optional) Comment statement Root element permits multiple occurrences of Apartment element within one document XML tags have element name between brackets and are case sensitive; the ending tag has a slash in front of the name

Slide 14

Robert Grauer 2004 www.prenhall.com/grauer Internet Explorer is XML-Aware Plus and minus signs show collapsed and expanded elements Nested elements are indented for ease of understanding Data is in bold face XML tags are in color

Slide 15

Robert Grauer 2004 www.prenhall.com/grauer An Iterative Process Create document in Notepad, then view document in Internet Explorer Open editor to modify document Click Refresh button to view updated document Enter and save the changes Deliberate error case does not match

Slide 16

Robert Grauer 2004 www.prenhall.com/grauer Errors are Not Permitted Internet Explorer will not open a document with errors XML tags are case sensitive; these tags do not match Open editor to correct the error Enter, then save the changes, and then click Refresh button to see document in Internet Explorer Explanation of the error is provided

Slide 17

Robert Grauer 2004 www.prenhall.com/grauer There is a Better Way... InfoPath 2003 enables a developer to create XML forms in the familiar Office environment Underlying schema is displayed in a task pane

Slide 18

Robert Grauer 2004 www.prenhall.com/grauer InfoPath 2003 User View The user enters data into a form which is converted to an XML document InfoPath is included in the Office 2003 Enterprise edition, but not in Office Professional; see office.microsoft.com/infopath for additional information

Slide 19

Robert Grauer 2004 www.prenhall.com/grauer In Conclusion... XML (eXtensible Markup Language) is a public standard and not a Microsoft product. The XML syntax, known officially as the XML recommendation, was developed by the World Wide Web Consortium (www.w3.org), a public organization with the sole purpose of creating standards or recommendations for the Internet.www.w3.org XML is supported in all Office 2003 applications; we continue by looking at the individual applications.

Slide 20

Robert Grauer 2004 www.prenhall.com/grauer Whats New in Outlook? A new interface Faster download Automatic junk mail filter Improved Rules Wizard New Search Folders Follow Up folder created automatically different color flags for different messages Create additional folders for specific individuals Contact picture

Slide 21

Robert Grauer 2004 www.prenhall.com/grauer A New Interface Reading pane is displayed at the left of the window as opposed to the bottom

Slide 22

Robert Grauer 2004 www.prenhall.com/grauer Faster Download Images are no longer downloaded by default

Slide 23

Robert Grauer 2004 www.prenhall.com/grauer Automatic Junk Mail Filter Junk mail filter is built in automatically Additional options will block specific senders

Slide 24

Robert Grauer 2004 www.prenhall.com/grauer Improved Rules Wizard Create rule from a template Or use the Wizard to create your own rule This rule automatically deletes all messages sent by Sobig.F worm

Slide 25

Robert Grauer 2004 www.prenhall.com/grauer New Search Folders Different color flags enable you to prioritize messages Create search folders for specific individuals or lists

Slide 26

Robert Grauer 2004 www.prenhall.com/grauer Contact Picture Meet Bob Bobs e-mail and Web page

Slide 27

Robert Grauer 2004 www.prenhall.com/grauer Whats New in Word? Reading View Research Pane Compare Documents side by side Selective Protection Document Workspace Support for XML Single File Web Page Web Page Wizard is gone creating a Web site is more difficult then before

Slide 28

Robert Grauer 2004 www.prenhall.com/grauer Reading View Reviewing toolbar Document Map facilitates navigation

Slide 29

Robert Grauer 2004 www.prenhall.com/grauer Research Pane Link to dictionary and/or an encyclopedia is available directly from the task pane

Slide 30

Robert Grauer 2004 www.prenhall.com/grauer Compare Documents Side by Side Will scroll in both documents simultaneously

Slide 31

Robert Grauer 2004 www.prenhall.com/grauer Selective Protection Choose the parts of a document to protect

Slide 32

Robert Grauer 2004 www.prenhall.com/grauer Document Workspace Consistent Interface Access to SharePoint Services without leaving the Office Application

Slide 33

Robert Grauer 2004 www.prenhall.com/grauer Support for XML... Multiple rsums are received by an organization, but cannot be processed electronically The solution is to convert the documents to XML, then process the results in an application where you can search and select for specific requirements

Slide 34

Robert Grauer 2004 www.prenhall.com/grauer Map the Document XML task pane Map text in the Word document to elements in the XML schema; schema is created independently

Slide 35

Robert Grauer 2004 www.prenhall.com/grauer Save the XML Document Specify XML as file type Save data only

Slide 36

Robert Grauer 2004 www.prenhall.com/grauer The XML Document Reference to the schema Plus and minus signs show collapsed and expanded elements Internet Explorer is XML-aware

Slide 37

Robert Grauer 2004 www.prenhall.com/grauer Single File Web Page Format HTML format requires supporting folder MHTML format has all objects in one document

Slide 38

Robert Grauer 2004 www.prenhall.com/grauer Web Page Wizard is Gone... You can still create a Web site, but you have to understand what you are doing. You create each page individually, then use the Frames toolbar to link the various pages to one another

Slide 39

Robert Grauer 2004 www.prenhall.com/grauer A Web Site is More Difficult... Create a folder for the site Use Word to create the home page Determine the visual design for the site Specify Single File Web Page format Create Under Construction page and duplicate as necessary Create navigation page with links to the pages at the site Use Frames toolbar tool bar for navigation

Slide 40

Robert Grauer 2004 www.prenhall.com/grauer Create Each Document Individually Place documents in folder by themselves This document holds the two frames of the Web site The Home Page Under Construction Page to facilitate development Documents in Single File Web Page format

Slide 41

Robert Grauer 2004 www.prenhall.com/grauer Add Frames for Navigation Frames toolbar enables horizontal or vertical navigation

Slide 42

Robert Grauer 2004 www.prenhall.com/grauer Whats New in Excel? Support for XML Compare workbooks side by side Research task pane Create List command Enhanced statistical functions Document Workspace

Slide 43

Robert Grauer 2004 www.prenhall.com/grauer Support for XML Additional fields can be added through Excel XML data is mapped into Excel workbook

Slide 44

Robert Grauer 2004 www.prenhall.com/grauer Compare Workbooks Compare Side by Side Toolbar Synchronize Scrolling

Slide 45

Robert Grauer 2004 www.prenhall.com/grauer Research Task Pane Research task pane retrieves corporate information Web query retrieves current price from the Internet (available since Excel 97)

Slide 46

Robert Grauer 2004 www.prenhall.com/grauer Create List Command The Create List command turns on the AutoFilter and highlights the list with a border; it does not do anything that cannot be done with ordinary Excel commands

Slide 47

Robert Grauer 2004 www.prenhall.com/grauer Enhanced Statistical Functions Analysis TookPak is an add-in with more than 30 statistical functions, many of which are enhanced for 2003

Slide 48

Robert Grauer 2004 www.prenhall.com/grauer Document Workspace Consistent Interface Access to SharePoint Services without leaving the Office Application

Slide 49

Robert Grauer 2004 www.prenhall.com/grauer Whats New in Access? Increased security detects VBA code Object Dependencies Error checking in design view (green triangle) Back Up Command Support for XML

Slide 50

Robert Grauer 2004 www.prenhall.com/grauer Increased Security Security warning detects VBA code (typically in every form) Dialog box is similar to Excel

Slide 51

Robert Grauer 2004 www.prenhall.com/grauer Object Dependencies The switchboard form is dependent on the Switchboard Items table Option button specifies the type of dependency

Slide 52

Robert Grauer 2004 www.prenhall.com/grauer Error Checking Green triangle (similar to Excel) indicates an error in the underlying control

Slide 53

Robert Grauer 2004 www.prenhall.com/grauer New Back Up Command Todays date is added to the file name

Slide 54

Robert Grauer 2004 www.prenhall.com/grauer Support for XML Export query as XML schema and data

Slide 55

Robert Grauer 2004 www.prenhall.com/grauer View XML Data Schema is saved in separate document Data is saved as XML document

Slide 56

Robert Grauer 2004 www.prenhall.com/grauer Use Notepad to add Style Sheet Edit file to include XML style sheet Data for Benjamin Grauer

Slide 57

Robert Grauer 2004 www.prenhall.com/grauer View XML Data on Web XML document has been modified Data for Benjamin Grauer

Slide 58

Robert Grauer 2004 www.prenhall.com/grauer Whats New in PowerPoint? Package for CD New Slide Show Toolbar Permanent Slide Show Annotations Research Task Pane Document Workspace

Slide 59

Robert Grauer 2004 www.prenhall.com/grauer Package for CD Command PowerPoint Viewer enables you to view the presentation without installing PowerPoint

Slide 60

Robert Grauer 2004 www.prenhall.com/grauer New Slide Show Toolbar Easy navigation throughout the show New pen options

Slide 61

Robert Grauer 2004 www.prenhall.com/grauer Permanent Slide Show Annotations Annotations are added as in previous versions of PowerPoint Annotations may now be stored with the presentation

Slide 62

Robert Grauer 2004 www.prenhall.com/grauer Research Task Pane Research pane available in Word, Excel, and PowerPoint Choose from a variety of resources

Slide 63

Robert Grauer 2004 www.prenhall.com/grauer Document Workspace Consistent Interface Access to SharePoint Services without leaving the Office Application

Slide 64

Robert Grauer 2004 www.prenhall.com/grauer Microsoft Office OneNote 2003 OneNote is designed for the Tablet PC, but it is useful with any PC

Slide 65

Robert Grauer 2004 www.prenhall.com/grauer Learn More About Office 2003 Click feedback to e-mail Bob Download this presentation

Slide 66

Robert Grauer 2004 www.prenhall.com/grauer Unique to the Grauer Series..

Slide 67

Robert Grauer 2004 www.prenhall.com/grauer rgrauer@miami.edu www.prenhall.com/grauer