Learn Microsoft Office Pro 2007 & QuickBooks Pro 2008

• Watch 34 recorded videos and step-by-step demonstrations featuring narrations by our certified instructors
• Learn by doing - Innovative hands-on labs to reinforce your learning
• Control your own pace of learning by using player controls, course map, search function, note taking, bookmarking and print.
• Get Certificate of Completion at the end of training
• For an engaging, dynamic, and effective alternative to instructor-led classes, choose this CD training at its finest.
• Review accounting basic concepts and terms with our special bonus: Accounting Crash Course

This cd training course is an exceptional training program that brings multimedia components such as video, audio, and simulated software together into a dynamic learning experience unlike any other. You?ll participate in pre and post assessments so you can measure how much you currently know and how far you?ve come after the course. These assessments also highlight areas that you may need to focus your studies on or examine further.

By engaging in the QuickBooks Pro video training, you will see instructors conducting classroom sessions as well as see the software in full-motion video. Other multimedia components round out the demonstrations by showing you the steps graphically using a step-by-step approach. Narrations clearly explain each step so you can follow along and fully understand what you are seeing.

By choosing the Quick Books Training CD course, you are choosing a self-directed means of learning. This method puts you in charge of your schedule. If you want to take your time and focus on one unit at a time, you can. If you want to work through several units in one sitting, you can do that as well. You?ll find a pace that is comfortable for the amount of time you have as well as your personal learning style.

Table of contents

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 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

  
  
  

  Microsoft PowerPoint 2007 Basic

  Lesson 1: The PowerPoint Environment

  1.1 Exploring the PowerPoint Environment

  1.2 Customizing Quick Access Toolbar

  
  
  Lesson 2: How to Navigate Presentations
  
  

  2.1 Navigation Steps in PowerPoint

  2.2 Different Presentation Views

  2.3 Rearranging and Deleting Slides

  
  
  Lesson 3: Creating and Formatting Slides

  3.1 Working with Themes

  3.2 Adding Slides to Your Presentations

  3.3 Entering and Modifying Text

  3.4 Formatting Paragraphs in a Slide

  
  
  Lesson 4: Adding Graphics and Drawing Objects to Your Presentations
  
  

  4.1 Inserting Pictures

  4.2 Inserting ClipART

  4.3 Creating and Modifying Shapes

  4.4 Inserting WordART

  
  
  Lesson 5: Modifying Objects

  5.1 How to Change an Object?s Orientation

  5.2 Grouping and Ungrouping Objects

  5.3 Arranging Your Objects

  
  
  Lesson 6: Adding Tables and Charts

  6.1 How to Create Tables

  6.2 Formatting Tables

  6.3 How to Insert Tables from Microsoft Word

  6.4 How to Add a Chart

  6.5 Modifying Charts

  6.6 Working with Diagrams

  
  
  Lesson 7: Modifying Presentations

  7.1 Working with Slide Masters

  7.2 Setting up Slide Shows

  7.3 Adding Transitions

  7.4 Adding Animation Effects

  7.5 How to Package Your Presentations

  
  
  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