Microsoft Office Professional 2007 Video Training

Learn Office Professional 2007's new features right away and put it to work for you in no time

Amazing eLearning presents premium self-study video training course for Microsoft Office Standard, Small Business and Professional 2007 Suite. These self-study lessons are in a format that lets you see the steps in the order they will be performed. Seeing the software in action and hearing instructors narrate each step is far more effective than reading a "how to" book. Textbooks and study guides with boring texts and limited images that make learning difficult can't compete with the CD training provided by these courses. You will learn how to work with Office Suite 2007 and become familiar with the Ribbon interface and other new features in lessons which include full motion video.

Our certified instructors show you exactly how to use the programs and clearly explain each step in an engaging manner without robotic voices or monotones. You get the benefits of one-on-one instruction and instructor-based learning at whatever location and time you choose at a fraction of the cost of the classroom lessons.

Features:

Excel, Word, PowerPoint, Outlook, Publisher and Access 2007

Training courses for Microsoft Office suite: Standard, Small Business & Professional

Learning office has never been so easy with new advanced training tools

Our certified instructor show you exactly how to use the program and clearly explain each step in an engaging manner without robotic voices or monotonies

Advanced training features such as Bookmarking, hands-on simulation and certificate of completion

177 Videos and 32 labs

Microsoft Office Professional 2007 Training Video CBT Features:

	Training Videos: An instructor introduces each learning module and gives you a preview of the topics that are covered. Instead of relying on reading written introductions, simply click on the video presentations for an interesting, informative summary of the concepts that you will be learning next. You will be learning these topics directly from an expert instructor who really knows the material.
	Hands-On Labs: Interactive hands-on lab scenarios are included for you to practice your skills. In fact, you don't even need the software on your computer in order to receive this hands-on training. Simulations are critical to the learning process. By modeling a real system and letting you perform the same tasks you would perform on the real system, you are reinforcing your knowledge.
	Player Controls: You can navigate freely with the player controls. You can play, pause, rewind, forward, and stop any video topic. The controls are familiar and easy to use. Simply click the control that matches the functions you want. If you are interrupted during your studies, click the pause button so that you won’t miss a single minute of the video training.
	Course Map: Choosing which topic you want to learn is easy with the convenient course map. Advanced users may skip ahead or repeat users can pick up where they left off. The course map allows you to pick and choose the topics that interest you and tailor the learning. You can even use it as a quick launch for reviewing specific topics.
	Search Function: Find the topics you need instantly. Just type in the word that describes your topic and view the search results. Don't waste countless minutes trying to find something you need now. The Search function is fast, accurate, and easy to use. Relevant search results and fast hyperlinks will jump you to your desired topic in a blink of an eye.
	Note Taking: Put away your notebook and pencil. Instead, jot down notes or questions for later reference by using the useful notepad feature. If an idea comes to mind or if you need to remind yourself of something important while studying, click on the notepad directly from the course interface and type out your thoughts without ever having to lift a pencil.
	Bookmarking: Self-paced study is designed to take place over several sessions which makes bookmarking extremely useful. You can exit your training and quickly reference areas of study you wish to revisit later by using bookmarks. If you want to pay special attention to a particular topic, simply use the bookmark feature so that you can spend extra time mastering the concept.
	Print: Do you need a hard copy? Sometimes, it’s just not practical to log on to your computer when you have a quick question or want to review. The print function lets you print out a hard copy for those times when you need to study offline. Anything that you see on the screen can be printed out for future reference.
	Certificate of Completion: Each interactive course comes with a certificate of completion. After you have finished the course, you just type in your name and print. It's that simple. Get recognized of your accomplishments with our courses.
	Multi-User Licensing: The best single and multi-user licensing agreement in the industry. Our licensing agreements accommodate individual students as well as companies with large training requirements. Single user licenses, single PCs licenses, multiple-user (non-concurrent) licenses, and unlimited corporate server site licenses are all available. This level of flexible licensing can’t be beat. No matter what you need, we have a license.

Outline

Microsoft Excel 2007 Basic

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

Microsoft Word 2007 Basic

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

Microsoft Word 2007 Basic

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

Microsoft Access 2007 Basic

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

Microsoft Publisher 2007

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

Microsoft Outlook 2007 Basic

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

Specs and Support

Total training time: ~48 hours
Content: CD-ROM disc (sealed in a DVD-case)

System Requirements:
Platform:

Windows Vista / XP / 2000 / 9x / NT
Processor: Pentium 133 Mhz or higher
RAM: 32MB
Hard drive space: 10MB
CD-ROM Drive speed: 24X

Technical Support: support@computerlearningpro.com