Microsoft Office XP Illustrated Introductory, Enhanced

1. Microsoft Office XP Illustrated Introductory, Enhanced Introducing Microsoft Office XP

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

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

4. Unit Introduction • Microsoft Office is a set 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 XP Unit A

5. Defining the Office XP Suite • The Office XP suite is a set 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 XP Unit A

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

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

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

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

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

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

12. Defining the Office XP 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 XP Unit A

13. Creating a Document with Word 2002 • Microsoft Word 2002 is a word processing program which allows you to create and edit text documents. • Enter and format text • Format text with a bold or italic attribute • Add tables and graphics to any document • Use electronic thesaurus, indexes, and footnotes Introducing Microsoft Office XP Unit A

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

15. Building a Worksheet with Excel 2002 • Microsoft Excel 2002 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 XP Unit A

16. Building a Worksheet with Excel 2002 (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 XP Unit A

17. Managing Data with Access 2002 • Microsoft Access 2002 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 XP Unit A

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

19. Creating a Presentation with PowerPoint 2002 • Microsoft PowerPoint 2002 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 XP Unit A

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

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 XP Unit A

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 XP Unit A

23. Integrating Office Information • Information created in one Office program can be used in another. • Excel chart can be used in a PowerPoint presentation • 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 XP Unit A

24. Integrating Office Information (cont.) Chart in Word Chart in Excel Chart in PowerPoint Introducing Microsoft Office XP Unit A

25. Managing Office Tasks with Outlook 2002 • Microsoft Outlook 2002 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 XP Unit A

26. Managing Office Tasks with Outlook 2002 (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 XP Unit A