BTT1O

Click Here to go to MS Office 2007 Complete, which has videos and related exercises in sequence

Video	Text	Exercise	Other
01-Introduction to MS Word 2007
02 - Basic Editing Features
03 - Viewing Options
04- Essential Basics
05 - Spell Check, Synonyms
06- Selecting Text
07 - Spacing
08 - Aligning Text
09- Autocorrect
10- Change Case, Dates, Envelopes
11 - Tabs
12 - Formatting text and the Format Painter
13 - Saving Documents
14 - Multiple Documents and Split Screen
15 - Moving and Copying Text
16 - Document Properties
12 - Formatting text and the Format Painter
17 - How to Insert and Use Symbols
18 - Indenting Text
19 - Bulleted and Numbered Lists
20 - Sorting
21- Using and Creating Styles
22 - Margins and Page Orientation
23 - Themes
24 - Hyperlinks
25 - Tables (part 1)
26 - Tables (part 2)
27 - Mail Merge
28 - Multi-Page Documents
29 - Footnotes and Find and Replace
30 - Columns
31 - Drop Caps and Borders
32 - Clipart

33 - Build Your Own Dreamboard	Instructions	Audio Instructions	Fun Project
34 - Textboxes and Wordart	Poster Exercise		Fun Project
35 - Tracing Objects			Fun Project
36 - Creating Your Own Clipart	Instructions		Fun Project
37 - Build Your Own Phone or Cellphone	Instructions		Fun Project
38 - Build and Personalize Your Own Calendar	Instructions		Fun Project
39 - Design and Build Your Own Pooltable	Instructions		Fun Project
40 - Design and Build Your Own House	Instructions		Fun Project

Video	Text	Exercise	Other
01 - Introduction to MS Excel
02 - Entering and Editing Data
03 - Columns and Rows
04 - Formatting Options
05- Copying Formulas
06- Sheets and Sheet Options
07 - How to use functions
08- Creating and Designing Charts
09- How to write and use an IF statement
10 - Viewing Options
11- Printing Options
12 - Paste Special
13 - How to work with 2 windows.
14 - 3 Dimensional Formulas
Application Exercise: Budget Project		Instructions
Application Exercise		DVD Store
Application Exercise		Baseball Manager

Video	Text	Exercise	Other
00 - Introduction and Layouts
01 - Themes
02 - Clipart and Backgrounds
03 - Views, Moving and Copying Slides
04 - Using the Outline Tab
05 - Headers, Footers and Backgrounds
06 - Printing Options
07 - Working with Placeholders and Text Formatting
08- Bullets, Numbers and Paragraph Options
09 - Text Boxes and Word art
10 - Tables
11 - Excel Sheets in Slides
12 - How to Create Charts
13 - How to Create Smart Art
14 - How to Use Rulers, Guides and Gridlines
15- How to Insert and Edit Various Objects
16 - How to Insert and Edit Pictures
17 - Slide master
18 - How to Create and Use Templates
19 - How to Animate Your Slideshow
20 - How to Create Links
21- Running Your Slideshow

Video	Text	Exercise	Other
Introduction to MS Access
Entering and Editing Records
Finding and sorting records
Saving Filters as Queries
Designing Queries
Creating Tables
Design Properties
Datasheet Layout Options
How to build a Lookup Field
Creating and Designing Forms

Video	Text	Exercise	Other
1-How to Start Your Website
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