Transcript Office xp Unit A - Scott Marino`s personal Web Site

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