Microsoft Office Professional 2007 Video Training NEW

Lessons Contents:

Lesson 1: Creating a Basic Worksheet
1.1 Explore the User Interface and the Ribbon
1.2 Customize the Quick Access Toolbar
1.3 Navigate and Select in Excel
1.4 Enter Data and Save a Workbook

Lesson 2: Performing Calculations
2.1 Create Basic Formulas
2.2 Calculate with Functions
2.3 Copy Formulas and Functions

Lesson 3: Modifying a Worksheet
3.1 Manipulate Data
3.2 Working with Cells, Columns, and Rows
3.3 Search for Data in a Worksheet
3.4 Spell Check a Worksheet

Lesson 4: Formatting a Worksheet
4.1 Modify Fonts
4.2 Add Borders and Color to Cells
4.3 Change Column Width and Row Height
4.4 Apply Number Formats
4.5 Using Styles

Lesson 5: Printing Workbook Contents
5.1 Print Workbook Contents Using Default Print Options
5.2 Setting Page Breaks

Lesson 6: Managing Large Workbooks
6.1 Format Worksheet Tabs
6.2 Manage Worksheets in a Workbook
6.3 Manage the View of Large Worksheets

Lesson 1: Getting Started with Word 2007
1.1 Exploring the Word window
1.2 Exploring the User Interface
1.3 Exploring the Ribbon
1.4 Document Navigation
1.5 Selection techniques
1.6 Viewing documents

Lesson 2: Creating a Word Document
2.1 Entering, Navigating, Selecting Text
2.2 Working with blocks of text
2.3 Searching for and replacing text
2.4 How to save your document
2.5 How to preview and print your document

Lesson 3: Formatting the Contents of a Document
3.1 Text Formatting
3.2 Copy Formatting
3.3 Find and Replace Formatting
3.4 Automatic Formatting
3.5 Paragraph Spacing and Indents
3.6 Setting Tabs and Aligning Text
3.7 Paragraph Alignment and Page Breaks
3.8 Adding Borders and Shading to Paragraphs
3.9 Applying Styles
3.10 Creating Lists

Lesson 4: Page Layout
4.1 Modifying the Orientation
4.2 Page Borders and Colors
4.3 Adding Headers and Footers
4.4 Modifying Content from Print Preview

Lesson 5: Proofing and Printing your Word Documents
5.1 Spelling and Grammar
5.2 Using AutoCorrect and Word Count

Lesson 6: Graphics
6.1 Adding and Using Graphics
6.2 Adding Symbols and Special characters
6.3 Watermarks

Lesson 7: Tables
7.1 How to Create a Table and Enter Data
7.2 How to Change the Table Structure
7.3 Formatting the Table
7.4 Converting Text to Table

Lesson 8: Proofing and Delivering Presentations
8.1 Working with Spell Check
8.2 How to Print Your Presentations

Lesson 1: Explore the Access 2007 Environment
1.1 Open Access 2007
1.2 Getting Started with Access 2007
1.3 Use a Database Template
1.4 Overview the User Interface
1.5 Navigating in the Databas

Lesson 2: Build a Database
2.1 Create a New Database
2.2 Create a Table
2.3 Manage Tables
2.4 Overview Table Relationships

Lesson 3: Manage Data in a Table
3.1 Add Table Data
3.2 Modify Table Data
3.3 Sort Records
3.4 Filter Records

Lesson 4: Working with Queries
4.1 Create a Query
4.2 Add Criteria to a Query
4.3 Sorting a Query Using Multiple Fields
4.4 Using AND and OR Operators

Lesson 5: Design Forms
5.1 Create a Form
5.2 View Data Using an Access Form
5.3 Create a Form Using the Form Wizard
5.4 Modify the Design of a Form
5.5 Format the Controls in a Form

Lesson 6: Generate Reports
6.1 View an Access Report
6.2 Create a Report
6.3 Create a Report Using the Report Wizard
6.4 Apply an AutoFormat to a Report
6.5 Prepare a Report for Print

Lesson 1: Basic Publications
1.1 Examining Publisher
1.2 Making a Quick Publication (Flyer)
1.3 Saving Publications
1.4 AutoRecover
1.5 Blank Publications (Invitation)
1.6 Adding Text
1.7 Inserting Graphics
1.8 Closing and Exiting Publisher

Lesson 2: Creating a Multi-Page Document
2.1 Creating a Newsletter
2.2 Inserting Text
2.3 Creating Text Boxes
2.4 Fitting & Linking Text in Text Boxes
2.5 Adding a Continued Notice
2.6 Copying and Moving Text Boxes
2.7 Resizing Text Boxes
2.8 Deleting Text Boxes
2.9 Textbox Alignment
2.10 Deleting and Inserting Pages

Lesson 3: Text Editing and Formatting
3.1 Editing Text
3.2 Paragraph Formatting
3.3 Finding and Replacing Text
3.4 Using AutoCorrect
3.5 Spell Check

Lesson 4: Publication Formatting
4.1 Choosing a Different Layout
4.2 Choosing a Color Scheme
4.3 Choosing a Font Scheme

Lesson 5: Working with Graphics
5.1 Inserting Pictures from Files
5.2 Formatting Picture Frames
5.3 Wrapping Text Around Pictures
5.4 Creating AutoShapes
5.5 Formatting AutoShapes
5.6 Deleting Autoshapes
5.7 Aligning and Distributing AutoShapes
5.8 Stacking Objects
5.9 Grouping and Ungrouping Objects
5.10 Using WordArt

Lesson 6: Distributing Publications
6.1 Emailing Newsletters
6.2 Printing to a Desktop Printer
6.3 Commercial Printing

Lesson 1: Getting Started with Microsoft Outlook 2007
1.1 Getting Started with Microsoft Outlook

Lesson 2: Email Basics
2.1 Setting up an Email Account
2.2 Working with Email Messages

Lesson 3: Creating and Sending Simple Email Messages
3.1 Using Spell Check
3.2 Properly Addressing Email Messages
3.3 Formatting Email Messages
3.4 Attaching Files to Messages
3.5 Forwarding and Replying to Email Messages
3.6 Printing and Deleting Messages

Lesson 4: Managing Your Emails
4.1 Setting Message Options
4.2 Handling Junk Mail
4.3 Moving and Copying Messages to Folders
4.4 Searching Folders
4.5 Deleting Folders
4.6 Opening and Saving Attachments
4.7 Flagging Messages

Lesson 5: Contact Management
5.1 Using Outlook for Managing Contacts
5.2 Editing Outlook Contacts
5.3 Navigating the Address Book
5.4 Using Distribution Lists
5.5 Deleting Contacts
5.6 Using Electronic Business Cards
5.7 Creating New Messages with the Address Book

Lesson 6: Working with Tasks
6.1 Using the Outlook Task List
6.2 Editing and Updating Tasks

Lesson 7: Working with Appointments and Events
7.1 Exploring the Outlook Calendar
7.2 Creating Appointments
7.3 Adding Categories to Outlook Items
7.4 Editing a Calendar Item

Lesson 8: Working with Meeting Requests and Responses
8.1 Working with Meetings in Outlook
8.2 Managing Meeting Responses

Lesson 9: Working with Notes
9.1 Using Notes in Outlook