Microsoft Office Professional 2007 Video Training Courses
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. |
Table of contents
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 Calculations2.1 Create Basic Formulas
2.2 Calculate with Functions
2.3 Copy Formulas and Functions
Lesson 3: Modifying a Worksheet3.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 Worksheet4.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 Contents5.1 Print Workbook Contents Using Default Print Options
5.2 Setting Page Breaks
Lesson 6: Managing Large Workbooks6.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 Document2.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 Document3.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 Layout4.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 Documents5.1 Spelling and Grammar
5.2 Using AutoCorrect and Word Count
Lesson 6: Graphics6.1 Adding and Using Graphics
6.2 Adding Symbols and Special characters
6.3 Watermarks
Lesson 7: Tables7.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 Presentations8.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 Document2.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 Document3.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 Layout4.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 Documents5.1 Spelling and Grammar
5.2 Using AutoCorrect and Word Count
Lesson 6: Graphics6.1 Adding and Using Graphics
6.2 Adding Symbols and Special characters
6.3 Watermarks
Lesson 7: Tables7.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 Presentations8.1 Working with Spell Check
8.2 How to Print Your Presentations
Microsoft Access 2007 Basic
Lesson 1: Explore the Access 2007 Environment1.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 Database2.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 Table3.1 Add Table Data
3.2 Modify Table Data
3.3 Sort Records
3.4 Filter Records
Lesson 4: Working with Queries4.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 Forms5.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 Reports6.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 Publications1.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 Document2.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 Formatting3.1 Editing Text
3.2 Paragraph Formatting
3.3 Finding and Replacing Text
3.4 Using AutoCorrect
3.5 Spell Check
Lesson 4: Publication Formatting4.1 Choosing a Different Layout
4.2 Choosing a Color Scheme
4.3 Choosing a Font Scheme
Lesson 5: Working with Graphics5.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 Publications6.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 20071.1 Getting Started with Microsoft Outlook
Lesson 2: Email Basics2.1 Setting up an Email Account
2.2 Working with Email Messages
Lesson 3: Creating and Sending Simple Email Messages3.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 Emails4.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 Management5.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 Tasks6.1 Using the Outlook Task List
6.2 Editing and Updating Tasks
Lesson 7: Working with Appointments and Events7.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 Responses8.1 Working with Meetings in Outlook
8.2 Managing Meeting Responses
Lesson 9: Working with Notes9.1 Using Notes in Outlook
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@amazingelearning.com
Return to top 