Microsoft Office 2007 Basic and Intermediate

Objective:

Participants will learn how to use the most common office skill such as Ms Word 2007, Ms Excel 2007, Ms Power Point 2007 and Ms Access 2007. Participants must be PC literate and has some basic knowledge of Windows Operating Systems.

Microsoft Word 2007 Basic and Intermediate

Course Content:

Getting Started

Starting Microsoft Word
Screen Layout
Menu
The Microsoft Office Button
The Ribbon (Formerly the Toolbars)
Quick Access Toolbar

Working with New Document

Creating a New Document
Open an Existing Document
Saving a Document
Renaming Documents
Working on Multiple Documents
Document Views
Close a Document

Editing Documents

Typing and inserting Text
Selecting Text
Inserting Additional Text
Rearranging Blocks of Text
Deleting Blocks of Text
Cutting, copying, and pasting text
Search and Replace Text
The undo and redo commands

Formatting Text

Applying Styles
Changing Font and Size
Font Styles and Effects
Change Text Color
Highlight Text
Copy Formatting
Clear Formatting

Formatting Pages

Page Margin and Orientation
Applying a Page Border and color
Creating Headers and Footers
Creating a Page Breaks

Formatting Paragraphs

Change Paragraph Alignment
Indent Paragraphs
Add Borders and Shading
Creating Styles
Change Spacing Between Paragraphs
Creating Bulleted and Number Lists

Adding Tables

Creating a Table
Working with a Table
Entering Data in a Table
Adjusting Column Width
Adjusting Row Height
Inserting and Deleting Rows and Columns
Modifying the table structure and format a table
Sorting Information in a Table
Creating Table Formulas

Proofing and Printing Documents

Checking spelling and grammar
Previewing and printing documents

Working with Columns

Creating Multiple column
To Use Different Column Formatting on the Same Page
To Modify Existing Columns

Working with Graphics and Objects

Symbols and Special Characters
Equations
Illustrations, Pictures, Clip art, Shapes and SmartArt
Applying watermarks
Inserting WordArt

Microsoft Excel 2007 Basic and Intermediate

Getting Started

Spreadsheets
Microsoft Office Button
Ribbon
Quick Access Toolbar
Mini Toolbar

Working with a Workbook

Create a Workbook
Save a Workbook
Open a Workbook
Entering Data

Manipulating Data

Select Data
Copy and Paste
Cut and Paste
Undo and Redo
Auto Fill

Modifying a Worksheet

Insert Cells, Rows and Columns
Delete Cells, Rows and Columns
Find and Replace
Go To Command
Spell Check

Performing Calculations

Excel Formulas
Calculate with Functions
Function Library
Relative, Absolute, & Mixed Functions
Linking Worksheets

Formatting a Worksheet

Convert Text to Columns
Modify Fonts
Format Cells Dialog Box
Add Borders and Colors to Cells
Formatting Value
Creating a Custom Number Format
Change Column Width and Row Height
Hide or Unhide Rows and Columns
Merge Cells
Align Cell Contents

Developing a Workbook

Format Worksheet Tabs
Reposition Worksheets in a Workbook
Insert and Delete Worksheets
Copy and Paste Worksheets

Page Properties and Printing

Set Print Titles
Create a Header and a Footer
Set Page Margins
Change Page Orientation
Set Page Breaks
Print a Range

Charts

Create a Chart
Modify a Chart
Chart Tools

Sort and Filter

Basic Sorts
Custom Sorts
Filter

Customize the Layout

Split a Worksheet
Freeze and Unfreeze Rows & Columns
Hide and Unhide Worksheets

Microsoft Power Point 2007 Basic and Intermediate

Getting Started

Microsoft Office Toolbar
The Ribbon
Quick Access Toolbar
Mini Toolbar
Navigation
Slide Views

Creating a Presentation

New Presentation
Save a Presentation
Add Slides
Themes

Working with Content

Enter Text
Select Text
Copy and Paste
Cut and Paste
Undo/Redo
Spell Check

Formatting Text

Change Font Typeface and Size
Font Styles and Effects
Change Text Color
WordArt
Change Paragraph Alignment
Indent Paragraphs
Text Direction

Adding Content

Resize a Textbox
Bulleted and Numbered Lists
Nested Lists
Formatting Lists

Graphics

Adding a Picture
Adding ClipArt
Editing Picture and ClipArt
Adding Shapes
Adding SmartArt

Tables

Create a Table
Enter Data in a Table
Modify Table Structure and Format Table

Charts

Create a Chart
Edit Chart Data
Modify a Chart
Chart Tools
Paste a Chart from Excel

Slide Effects

Slide Transitions
Slide Animation
Animation Preview
Slide Show Options

Printing

Create a speaker notes
Print Presentation

Microsoft Access 2007 Basic & Intermediate

Getting Started

Microsoft Office Toolbar
The Ribbon
Quick Access Toolbar
Navigation
Tabbed Document Window Viewing

Database Term

Creating a New Database

New Database
Database Templates

Create a Table

Table Views
Adding New Fields
Data Types
Types of fields properties
Setting Number format
Setting Date/Time format
Setting Yes/No format

Working with a Table

Moving around in the datasheet view
Edit Records
Delete records
Changing table structure
Delete Table
Rename Table

Edit a Table

Changing view to datasheet view
Change Font
Change Cell Effects
Move a Column
Hide/Unhide Column
Freeze/Unfreeze column

Keys

Primary Key

Table Relationships

One-to-One Relationship
One-to-Many Relationship
Creating a Table Relationship
Print a Table Relationship Report

Managing Data

Add Records to a Table
Find and Replace
Totals
Sort Records
Filter