Microsoft Office 2003 Illustrated Introductory, Premium Edition

1. Microsoft Office 2003 Illustrated Introductory, Premium Edition Introducing Microsoft Office 2003

2. Objectives • Define the Office 2003 Suite • Create a document with Word 2003 • Build a worksheet with Excel 2003 • Manage data with Access 2003 • Create a presentation with PowerPoint 2003 Introducing Microsoft Office 2003

3. Objectives • Browse the World Wide Web with Internet Explorer • Integrate Office information • Manage office tasks with Outlook 2003 Introducing Microsoft Office 2003

4. Unit Introduction • Microsoft Office is a collection of software programs • Each Office program is designed to complete specific tasks • Each Office program has similar buttons and commands to make switching among programs easy • Microsoft Office is known as a suite. Introducing Microsoft Office 2003

5. Defining the Office 2003 Suite • The Office 2003 suite is a collection of programs known as business productivity software • Helps people in business work better • Office documents are compatible with one another, so you can easily integrate information between files • Insert an Excel chart into a Word document Introducing Microsoft Office 2003

6. Defining the Office 2003 Suite • Most common Office suite programs: • Word • Excel • Access • PowerPoint • Outlook Introducing Microsoft Office 2003

7. Defining the Office 2003 Suite (cont.) • Microsoft Word • Documents • Letters • Faxes • Memos • Flyers Introducing Microsoft Office 2003

8. Defining the Office 2003 Suite (cont.) • Microsoft Excel • Budgets • Financial statements • Payroll summaries • Charts and graphs Introducing Microsoft Office 2003

9. Defining the Office 2003 Suite (cont.) • Microsoft Access • Organize, track, and update complex data. • Customer database • Inventory database Introducing Microsoft Office 2003

10. Defining the Office 2003 Suite (cont.) • Microsoft PowerPoint • Create visual presentations • Performance • Sales • Strategy • Training • Business plan • Marketing Introducing Microsoft Office 2003

11. Defining the Office 2003 Suite (cont.) • Microsoft Outlook • Track and organize: • Appointments • Contacts • Send email Introducing Microsoft Office 2003

12. Defining the Office 2003 Suite (cont.) • Internet Explorer • A program that lets you access information on the Internet and World Wide Web • A part of Windows or can be downloaded from the Web Introducing Microsoft Office 2003

13. Creating a Document with Word 2003 • Microsoft Word 2003 is a word processing program which allows you to create and edit text documents • Enter and format text • Add tables and graphics • Use electronic thesaurus, indexes, and footnotes Introducing Microsoft Office 2003

14. Creating a Document with Word 2003 (cont.) • Word can help you: • Enter text quickly • Organize information • Create error-free information • Combine text and graphics • Add special effects Table Graphic Introducing Microsoft Office 2003

15. Building a Worksheet with Excel 2003 • Microsoft Excel 2003 is a spreadsheet program that you use to analyze data, perform calculations, and create charts • Like paper spreadsheets, Excel has a worksheet area • Divided into columns and individual cells • A cell contains text, numbers, formulas, or a combination Introducing Microsoft Office 2003

16. Building a Worksheet with Excel 2003 (cont.) Formatted data • Excel can help you: • Calculate results accurately • Perform what-if analysis • Perform complex mathematical formulas • Create charts Graphic Chart Introducing Microsoft Office 2003

17. Managing Data with Access 2003 • Microsoft Access 2003 is a database management system which allows you to organize and link databases • A database is a collection of related information such as a list of employees • A table is a grid where you can arrange and analyze large amounts of data Introducing Microsoft Office 2003

18. Managing Data with Access 2003 (cont.) • Access can help you: • Enter data easily • Retrieve data easily • Create professional forms and reports • Add graphics to reports Table Introducing Microsoft Office 2003

19. Creating a Presentation with PowerPoint 2003 • Microsoft PowerPoint 2003 is a presentation graphics program that you can use to create handouts or electronic presentations • A slide is the “page” where you place text, graphics, and other objects • Slides make up a presentation and can be seen in an on-screen display called a slide show Introducing Microsoft Office 2003

20. Creating a Presentation with PowerPoint 2003 (cont.) Slide • PowerPoint can help you: • Create and edit slides • Combine information from Office programs • Add graphics • Add special effects Graphic Inserted Excel chart Introducing Microsoft Office 2003

21. Browsing the World Wide Web with Internet Explorer • The World Wide Web, known as the Web, is the text, graphics, and multimedia part of the Internet • Internet Explorer is a browser. • A program designed to help you view data on the Web • Web sites let you jump to other sites using links, special areas that take you to another location Introducing Microsoft Office 2003

22. Browsing the World Wide Web with Internet Explorer (cont.) • Internet Explorer can help you: • Display Web sites • Move between Web sites • Use multimedia • Incorporate Web information Links Web page Introducing Microsoft Office 2003

23. Integrating Office Information • Information created in one Office program can be used in another • An Excel chart can be used in a PowerPoint presentation • Word data can be used in an Excel worksheet • Word text can be used to create PowerPoint slides • Access data can be used in an Excel worksheet Introducing Microsoft Office 2003

24. Integrating Office Information (cont.) • Integration benefits include: • Create information once • Merge data • Export data • Create hyperlinks • A hyperlink is specially formatted text or a graphic that transfers you to another location or document Introducing Microsoft Office 2003

25. Integrating Office Information (cont.) Chart in Word Chart in Excel Chart in PowerPoint Introducing Microsoft Office 2003

26. Managing Office Tasks with Outlook 2003 • Microsoft Outlook 2003 is an electronic personal information manager • Helps you manage and keep track of appointments, events, contacts, and e-mail • An e-mail message is an electronic message sent to anyone with an e-mail address Introducing Microsoft Office 2003

27. Managing Office Tasks with Outlook 2003 (cont.) • Some of the benefits of Outlook: • Read and respond to e-mail • Create and manage a contact address book • Send file attachments with e-mail messages Introducing Microsoft Office 2003

28. Summary • Use Word to create a text document • Use Excel to create a spreadsheet • Use Access to create a database • Use PowerPoint to create a presentation • Use InternetExplorer to browse the Web • Use Outlook to manage tasks Introducing Microsoft Office 2003