Microsoft Office

Introducing Office
An office suite is:
An interconnected bundle of programs that share resources with each other
Designed to help workers accomplish tasks they perform in an office
Three versions of Microsoft Office:
Standard
Includes Word, Excel, PowerPoint, and Outlook
Professional
Includes Standard version, Access, and FrontPage
Developer
Includes Professional version and Visual Basic
Slide

The Shared Office Interface and Tools
User interface – The method with which users interact with the computer system
Office suites share a common user interface
Elements of the user interface:
Title bar
Menu bar
Toolbars
Status bar
Task pane
Other shared resources:
Office Clipboard
Clip Organizer
Smart tags
Templates
Wizards
Slide

Title Bar
Slide
The name of the application and the name of the file being worked on
Window controls enable the window to be maximized, minimized, restored, or closed

Status Bar
Slide
The status bar contains specific information about the activities within a program, such as current page number and the number of pages in the document

Menu Bar
Slide
The menu bar contains the names of pull-down menus
Pull-down menus contain commands that can be used with the application

Menu Bar
Standard Menu Names:
File
Edit
View
Format
Tools
Help
Slide

Toolbars
Slide
The toolbars contain icons that represent the most commonly used commands
Standard toolbar
Formatting toolbar
Undocked toolbar

Clip Organizer
Slide
The clip organizer is a repository of clip art and images that can be inserted into a document

Office Clipboard
Slide
The office clipboard temporarily stores whatever was cut or copied from a document

Task Pane
Slide
The task pane contains options for opening, creating, and formatting documents as well as other tasks

Word 2007
Slide

What's on the Ribbon
1- Tabs.
2-Groups
3-Commands
Slide

Dilog box launchers in groups
Slide

Smart Tags
Slide
Smart tags are icons attached to items that are pasted, or text that is recognized as a place where options might occur

Templates
Slide
Templates are document frameworks that are created once and used many times

Wizards
Slide
Wizards provide a step by step process for solving problems

Microsoft Word
Features include:
Word processing with the power of desktop publishing
The ability to embed charts, graphics, tables, pictures, and other objects
Paragraph and text formatting
The potential to use and create custom templates
The means to link and embed documents with other Office programs
The capability to save files as documents, plain text, templates, or Web pages
Slide

Microsoft Word Features
Slide
My Dog Sam
Click to view Word features

Microsoft Excel
Excel is the most popular spreadsheet program
Spreadsheets are designed to store and manipulate numbers
Each Excel file is called a workbook
The user interface is similar to that of Microsoft Word
Slide

The Excel Worksheet Components
The worksheet is composed of columns and rows
The intersection of a row and column is called a cell
Two or more cells selected at the same time is called a range of cells
Text, numbers, formulas, and functions can be entered into cells
Charts can also be created in a worksheet
Slide

Excel Worksheet
Slide
Worksheet tabs

Columns
Slide
Column
D
Column
G

Rows
Slide
Row
14
Row
5

Cells
Slide
Cell
A1
Cell
E11

Range of Cells
Slide
Range
A1:D1
Range
G13:H23

Charts
Slide
Bar chart
Pie chart

Text and Numbers
Slide
Text or Label
Number

Formulas and Functions
Slide
Formula
Function

Microsoft Access
Access is a database management system (DBMS)
Databases manage data by enabling the user to organize the data in a way that it becomes useful and meaningful
Two types of databases exist:
Flat file database
Relational database
The user interface is similar to that of Word and Excel
Slide

Access Components
Objects – Used to manage and present data
Table – Stores data
Form – Collects data
Query – Questions of the database
Report – Presents data
Data Access Page – Post data to the Web
Slide

Access Interface
Slide
Click to view Object, Table, Form, Query, and Report

Microsoft PowerPoint
PowerPoint is used to create and deliver presentations
Text and graphics are entered onto a slide
Slide shows can be viewed using a monitor or video projector
Slide

PowerPoint Interface
Slide
Slide
Task Pane
Outline, Thumbnail view
Toolbars

Microsoft Outlook
Outlook is an e-mail and organizational communications tool that can be used to:
Send and receive e-mail
Maintain a calendar
Schedule meetings
Store contact information
Slide