MS Office Complete

• MS Word 2007

• MS Excel 2007

• MS PowerPoint 2007

• MS Access 2007

• MS FrontPage 2007

This Page has links to:

• Video Lessons
• Audio Instructions
• PDF or JPEGs of how the exercise should look upon completion

MS Word 2007

• Word 2007: Exercise 1:

  • 01 - Introduction to MS Word 2007

  • 02 - Basic Editing Features

  • 03 - Viewing Options

  • Audio, Ex. 1, Trainer

  • PDF Trainer

• Word 2007: Exercise 2:

  • 04- Essential Basics

  • Audio

  • PDF

• Word 2007: Exercise 3:

  • 05 - Spell Check, Synonyms

  • Audio

  • PDF

• Word 2007: Exercise 4:

  • 06- Selecting Text

  • 07 - Spacing

  • 08 - Aligning Text

  • 09- Autocorrect

  • Audio

  • PDF

• Word 2007: Exercise 5:

  • 10- Change Case, Dates, Envelopes

  • Audio

  • PDF

• Word 2007: Exercise 6:

  • 11 - Tabs

  • Audio

  • PDF

• Word 2007: Exercise 7:

  • 12 - Formatting text and the Format Painter

  • Audio a

  • Audio b

  • PDF a

  • PDF b

• Word 2007: Exercise 8:

  • Audio a

  • Audio b

  • PDF a

  • PDF b

• Word 2007: Exercise 9:

  • there is no 9

• Word 2007: Exercise 10:

  • 13 - Saving Documents

  • Audio

  • PDF

• Word 2007: Exercise 11:

  • 14 - Multiple Documents and Split Screen

  • Audio a

  • Audio b

  • PDF a

  • PDF b

• Word 2007: Exercise 12:

  • 15 - Moving and Copying Text

  • Audio

  • PDF

• Word 2007: Exercise 13:

  • Audio

  • PDF

• Word 2007: Exercise 14:

  • 16 - Document Properties

  • Audio 1

  • Audio 2
     

• Word 2007: Exercise 15:

  • Audio 1

  • Audio 2

  • PDF 1

  • PDF 2

• Word 2007: Exercise 16:

  • Audio a

  • Audio b

  • PDF a

  • PDF b

• Word 2007: Exercise 18:

  • 12 - Formatting text and the Format Painter

  • Audio

  • PDF

• Word 2007: Exercise 19:

  • 17 - How to Insert and Use Symbols

  • Audio

  • PDF

• Word 2007: Exercise 20:

  • 18 - Indenting Text

  • Audio

  • PDF

• Word 2007: Exercise 21:

  • 19 - Bulleted and Numbered Lists

  • 20 - Sorting

  • Audio

  • PDF

• Word 2007: Exercise 22:

  • 21- Using and Creating Styles

  • Audio

  • PDF

• Word 2007: Exercise 23:

  • 22 - Margins and Page Orientation

  • Audio

  • PDF

• Word 2007: Exercise 24:

  • 23 - Themes

  • Audio

  • PDF

• Word 2007: Exercise 25:

  • Audio

  • PDF

• Word 2007: Exercise 29:

  • 24 - Hyperlinks

  • Audio

• Word 2007: Exercise 33:

  • 25 - Tables (part 1)

  • Audio

  • View

• Word 2007: Exercise 34:

  • 26 - Tables (part 2)

  • Audio

  • View

• Word 2007: Exercise 35:

  • Audio

  • View

• Word 2007: Exercise 36:

  • Audio

  • View

• Word 2007: Exercise 37:

  • Audio

  • View

• Word 2007: Exercise 39:

  • 27 - Mail Merge

  • Audio

  • View

• Word 2007: Exercise 40:

  • Audio

  • View

• Word 2007: Exercise 46:

  • 28 - Multi-Page Documents

  • Audio

  • View

• Word 2007: Exercise 47:

  • 29 - Footnotes and Find and Replace

  • Audio

  • View

  • View

• Word 2007: Exercise 52:

  • 30 - Columns

  • Audio

  • View

• Word 2007: Exercise 53:

  • 31 - Drop Caps and Borders

  • Audio

  • View

• Word 2007: Exercise 54:

  • 32 - Clipart

  • Audio

  • View

• MS Word 2007

• MS Excel 2007

• MS PowerPoint 2007

• MS Access 2007

• MS FrontPage 2007

MS Excel 2007

• Excel 2007: Exercise 1:

  • 01 - Introduction to MS Excel

  • 02 - Entering and Editing Data

  • 03 - Columns and Rows

  • Audio

  • View

• Excel 2007: Exercise 2:

  • 04 - Formatting Options

  • 05- Copying Formulas

  • 06- Sheets and Sheet Options

  • Audio

  • View

• Excel 2007: Exercise 3:

  • 07 - How to use functions

  • 08- Creating and Designing Charts

  • 09- How to write and use an IF statement

  • Audio

  • View

• Excel 2007: Exercise 4:

  • 10 - Viewing Options

  • 11- Printing Options

  • 12 - Paste Special

  • Audio

  • View

• Excel 2007: Exercise 5:

  • 13 - How to work with 2 windows.

  • 14 - 3 Dimensional Formulas

  • Audio

• Budget Project

  • 15- Budget Project

  • Instructions

• MS Word 2007

• MS Excel 2007

• MS PowerPoint 2007

• MS Access 2007

• MS FrontPage 2007

MS PowerPoint 2007

• PowerPoint 2007: Exercise 1:

  • 00 - Introduction and Layouts

  • Audio

  • View

• PowerPoint 2007: Exercise 2:

  • 01 - Themes

  • Audio

• PowerPoint 2007: Exercise 3:

  • 02 - Clipart and Backgrounds

  • Audio

  • View

  • View

• PowerPoint 2007: Exercise 4:

  • 03 - Views, Moving and Copying Slides

  • Audio

  • View

  • View

  • View

• PowerPoint 2007: Exercise 5:

  • 04 - Using the Outline Tab

  • 05 - Headers, Footers and Backgrounds

  • Audio

  • View

• PowerPoint 2007: Exercise 6:

  • 06 - Printing Options

  • Audio

• PowerPoint 2007: Exercise 7:

  • Audio

• PowerPoint 2007: Exercise 9:

  • 07 - Working with Placeholders and Text Formatting

  • Audio

  • View

• PowerPoint 2007: Exercise 10:

  • 08- Bullets, Numbers and Paragraph Options

  • Audio

  • View

• PowerPoint 2007: Exercise 11:

  • 09 - Text Boxes and Word art

  • Audio

  • View

• PowerPoint 2007: Exercise 12:

  • 10 - Tables

  • 11 - Excel Sheets in Slides

  • Audio

  • View

• PowerPoint 2007: Exercise 13:

  • 12 - How to Create Charts

  • 13 - How to Create Smart Art

  • Audio

  • View

• PowerPoint 2007: Exercise 14:

  • 14 - How to Use Rulers, Guides and Gridlines

  • 15- How to Insert and Edit Various Objects

  • Audio

  • View

• PowerPoint 2007: Exercise 15:

  • 16 - How to Insert and Edit Pictures

  • Audio

  • View

• PowerPoint 2007: Exercise 17:

  • 17 - Slide master

  • 18 - How to Create and Use Templates

  • Audio

  • View

  • View

• PowerPoint 2007: Exercise 20:

  • 19 - How to Animate Your Slideshow

  • Audio

• PowerPoint 2007: Exercise 21:

  • 20 - How to Create Links

  • Audio

• PowerPoint 2007: Exercise 22:

  • 21- Running Your Slideshow

  • Audio

• MS Word 2007

• MS Excel 2007

• MS PowerPoint 2007

• MS Access 2007

• MS FrontPage 2007

MS Access 2007

• Introduction to MS Access

• Audio

• Picture

• Entering and Editing Records

• Audio

• Picture

• Finding and sorting records

• Audio

•  Saving Filters as Queries

• Audio

• Designing Queries

• Audio

• Querie Review Exercises(2)

• Audio

• Audio

• Creating Tables

• Audio

• Picture

• Design Properties

• Audio

• Table Design Review Exercises (2)

• Audio 1

• Picture

• Audio 2

• Datasheet Layout Options

• Audio

• How to build a Lookup Field

• Audio

• Creating and Designing Forms

• Audio

• MS Word 2007

• MS Excel 2007

• MS PowerPoint 2007

• MS Access 2007

• MS FrontPage 2007

MS FrontPage 2007

2- Themes

3- Shared Borders and Link Bars

4- Page Banners

5- Tables and Aligning Text

6- Bullets and Horizontal Lines

7-Photo Galleries

8- Creating Forms

• MS Word 2007

• MS Excel 2007

• MS PowerPoint 2007

• MS Access 2007

• MS FrontPage 2007