Microsoft Office 2003
Illustrated Introductory
Introducing
Microsoft Office 2003
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 2
Objectives
Browse the World Wide Web with
Internet Explorer
Integrate Office information
Manage office tasks with Outlook
2003
Introducing Microsoft Office 2003 3
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 4
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 5
Defining the Office 2003 Suite
Most common Office suite programs:
– Word
– Excel
– Access
– PowerPoint
– Outlook
Introducing Microsoft Office 2003 6
Defining the Office 2003 Suite
(cont.)
Microsoft Word
– Documents
– Letters
– Faxes
– Memos
– Flyers
Introducing Microsoft Office 2003 7
Defining the Office 2003 Suite
(cont.)
Microsoft Excel
– Budgets
– Financial statements
– Payroll summaries
– Charts and graphs
Introducing Microsoft Office 2003 8
Defining the Office 2003 Suite
(cont.)
Microsoft Access
– Organize, track, and
update complex data.
– Customer database
– Inventory database
Introducing Microsoft Office 2003 9
Defining the Office 2003 Suite
(cont.)
Microsoft PowerPoint
– Create visual
presentations
• Performance
• Sales
• Strategy
• Training
• Business plan
• Marketing
Introducing Microsoft Office 2003 10
Defining the Office 2003 Suite
(cont.)
Microsoft Outlook
– Track and
organize:
• Appointments
• Contacts
– Send email
Introducing Microsoft Office 2003 11
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 12
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 13
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 14
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 15
Building a Worksheet
with Excel 2003 (cont.) Formatted
data
Excel can help you: Graphic
– Calculate results
accurately
– Perform what-if
analysis
– Perform complex
mathematical
formulas
– Create charts
Chart
Introducing Microsoft Office 2003 16
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 17
Managing Data with
Access 2003 (cont.)
Access can help you:
Table
– Enter data easily
– Retrieve data easily
– Create professional
forms and reports
– Add graphics to
reports
Introducing Microsoft Office 2003 18
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 19
Creating a Presentation with
PowerPoint 2003 (cont.)
PowerPoint can help Slide Graphic
you:
– Create and edit slides
– Combine information
from Office programs
– Add graphics
– Add special effects
Inserted Excel chart
Introducing Microsoft Office 2003 20
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 21
Browsing the World Wide Web
with Internet Explorer (cont.)
Internet Explorer Links
can help you:
– Display Web
sites
– Move between
Web sites
– Use multimedia
– Incorporate
Web
information
Web page
Introducing Microsoft Office 2003 22
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 23
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 24
Integrating Office Information
(cont.) Chart in Word
Chart in Excel
Chart in PowerPoint
Introducing Microsoft Office 2003 25
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 26
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 27
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
Introducing Microsoft Office 2003 28