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

3
Objectives

• Browse the World Wide Web with Internet Explorer
• Integrate Office information
• Manage office tasks with Outlook 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.

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

6
Defining the Office 2003 Suite

• Most common Office suite programs
• Word
• Excel
• Access
• PowerPoint
• Outlook

7
Defining the Office 2003 Suite (cont.)

• Microsoft Word
• Documents
• Letters
• Faxes
• Memos
• Flyers

8
Defining the Office 2003 Suite (cont.)

• Microsoft Excel
• Budgets
• Financial statements
• Payroll summaries
• Charts and graphs

9
Defining the Office 2003 Suite (cont.)

• Microsoft Access
• Organize, track, and update complex data.
• Customer database
• Inventory database

10
Defining the Office 2003 Suite (cont.)

• Microsoft PowerPoint
• Create visual presentations
• Performance
• Sales
• Strategy
• Training
• Business plan
• Marketing

11
Defining the Office 2003 Suite (cont.)

• Microsoft Outlook
• Track and organize
• Appointments
• Contacts
• Send email

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

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

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
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

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
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

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
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

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
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

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
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

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

25
Integrating Office Information (cont.)
Chart in Word
Chart in Excel
Chart in PowerPoint
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

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

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 Internet Explorer to browse the Web
• Use Outlook to manage tasks