Microsoft Office 2003 Training on DVDs
 Microsoft Office 2003 training course (Professional Edition) covers the features, and functionality that can help organizations and
their employees connect to coworkers, information, and business processes quickly and effectively.
Advances in intranet collaboration through integration with the collaboration and information-sharing portal, Microsoft Office SharePoint Portal Server 2003, enable employees to access and
share information both internally and externally. Support for information rights management (IRM) and industry-standard Extensible Markup Language (XML) provide a platform on which to
quickly build cost-effective solutions that can have an immediate impact in your business and productivity.
Our DVD training course is a full multi-media presentation. Included on each DVD is a course book as well as lessons files that are covered on each DVD. Let our instructors take you step
by step through your training. Each level covers 2 hours of training. A total of over 20 hours of training.
Twenty DVD Training Courses Consists of the Following
|
New DVDs Complete Set of 20 Courses and Workbooks -- Microsoft Office 2003 Training CD's ( Word, Excel, Access, Outlook,
PowerPoint )
|
mkof03dv
|
$599.95
|
|
Microsoft Access Tutorial course outline DVDs
Level 1
Introduction
Database Concepts
Relational Databases
Task Pane
Tables
Forms
Queries
Reports
Database Wizard
Database Development
Building a Database
Table Essentials
Table Wizard
Relationships with Wizards
Setting up Field Names
Setting Data Types
Setting a Primary Key
Datasheet View
Add New Record
Delete Record
Office Clipboard
Table Appearance
Column Width
Changing Font & Cell Effects
Managing Columns Appearance
Filter Techniques
Sorting Records
Finding a Record
Filtering By Selection
Query Essentials
Relationships
Query Wizard
Adding Criteria
Using Comparison Operators
Using Wildcards
Level 2
Form Essentials
Using the Form Wizard
Creating Forms with AutoForm
Report Essentials
Using the Report Wizard
Adding a Calculated Control
Using Print Preview
Using the Label Wizard
Field Properties
Field Size
Date and Time
Context Sensitive Help
Yes & No Fields
Default Value
Validation Rule
Indexed Field
Create a Lookup
Inserting a Lookup Field
Lookup Wizard
Limit to List
Importing & Exporting Data
Export to Excel
Importing from Access Databases
Importing Data from Excel
Linking Data from Excel
Creating a Shared Database
Using the Database Splitter
Relationships
Creating Table Relationships
Enforcing Referential Integrity
Understanding Cascade Options
Printing Database Information
Level 3
Advanced Query Techniques
Using Parameter Queries
Establishing Multiple Parameters
Setting up Calculated Fields
Creating Summary Queries
Using Access & HTML
Access and HTML
Using Hyperlinks
Publish Database to HTML Format
Data Access Pages
Using Data Access Pages
Merging Access into Word
The Access Mail Merge Wizard
Creating the Form Letter
Running the Merge
Action Queries
Make Table Query
Running an Append Query
Running a Delete Query
Running an Update Query
Printing Queries
Database Maintenance
Compact & Backup
Using Compact & Repair Utility
Using Backup & Restore Tool
Training Course Instructor: Casey McNeal
Casey has been speaking professionally for over nine years. His diverse professional background and his life as a stand-up comic
Microsoft Excel Course Tutorial Outline on DVDs
Level 1
Getting Started
Starting Excel
Workbooks and Worksheets
Task Pane
Menu Bar and Shortcut Menus
Toolbars
Navigation and Mouse Pointer
Entering Data
Data Entry
Auto-Fill Entry
Erasing Data
AutoComplete and Preselections
Undo and Redo
Saving, Opening and Closing Files
File Save and File Save As
Opening a File
Closing a File
Creating a New Workbook
Entering Formulas
Methods of Entering Formulas
Repeating Formulas in Adjacent Fields
Formula Operators
Additional Formulas
Basic Excel Functions
Totals and Averages
Function Overview
Formatting
Adjusting Column Widths and Row Heights
Formatting Toolbar
Numeric Formatting
Changing Worksheet Layout
Inserting Columns, Rows and Cells
Deleting Columns, Rows and Cells
Moving Cells
Copying Cells
Printing
Using Print Preview and Page Setup
Printing Controls
Printing
Excel Help System
Using Excel Online Help
Using Excel Offline Help
Level 2
Additional Formatting
Cell Alignment and Orientation
Borders
Centering Text Across Columns
Hiding and Unhiding Columns and Rows
Conditional Formatting
Formatting Based on Values and Multiple Conditions
Avoiding Overlapping Conditions
Using a Formula to Control Formatting
Specialized Numeric Formatting
Custom Category
Special Category
Cell References
Absolute References
Mixed References
Range Names
Naming and Using Range Names
Additional Creation Methods
Pasting a List of Range Names in a Worksheet
Deleting Range Names
Assigning a Name to a Value
Formula Auditing Techniques
Using the Formula Auditing Toolbar
Tracing Dependent Cells
Tracing Precedent Cells
Cell Protection Techniques
Locking/Unlocking Selected Cells
Protecting/Unprotecting a Worksheet
Find and Replace
Matching Entire Cells and Case Factors
Formulas and Wildcard Characters
Find and Replace by Format
Adjusting Worksheet Views
Freeze/Unfreeze Panes
Horizontal and Vertical Split Screens
Customizing Toolbars
Adding and Removing Buttons
Economizing Buttons and Resetting Toolbars
Creating New Tool Bars
Level 3
The "IF" Function
"IF" Functions and Relational Operators
Using Text in "IF" Functions
Logical Operators ("AND" and "OR") with "IF" Functions
Nested "IF" Functions
Getting Table Data with "VLOOKUP" Function
Dates and Time
Using Dates as Values
Entering a Series of Dates
Date/Time Techniques
Multi-Sheet Workbooks
Renaming Sheets and Coloring Tabs
Inserting and Deleting Sheets
Moving, Copying and Grouping Sheets
Formulas Across Multiple Sheets
Multiple Workbooks
Opening and Displaying Multiple Workbooks
Moving and Copying Sheets Across Workbooks
Linking Formulas Across Workbooks
Locating and Maintaining Links
Features and Settings
Show/Hide Gridlines and Formulas
Recently Used File List and New Workbook Settings
Other Settings and Features
Overview of Charting
Quick Chart Creation
Chart Types
Titles, Gridlines and Scaling
Formatting Basics
Printing and Copying Charts
Overview of Database Features
Sorting Data
Creating Subtotals
Filtering
Pivot Tables
Additional Topics
Templates
Saving a Skeleton Workbook as a Template
Creating a New Workbook from a Template
Editing a Template
Protection
Workbook Protection
File Password
Macro Security
Sharing Workbooks
Establishing Sharing
Tracking Changes
Merging Workbooks
Exporting Data From Excel
Exporting to Access
Exporting to Word
Saving as a Text File
Saving as a New Folder
Importing Data to Excel
Importing Data Using the File Open Command
Importing or Copying External Data
Hyperlinks
Tools Research
Excel and the Web
Importing Web Data
Saving Excel Data as a Webpage
Customizing Excel Environment
Creating a New Menu
Creating a Macro
Running a Macro
Editing a Macro
Special Topics
Functions
Statistical Functions
Date and Time Functions
Financial Functions
Mathematical Functions
Formula Troubleshooting
Formula Watch Window
Evaluate Formula Feature
Data Analysis Tools
Goal Seek
Solver
Scenarios
Data Table
Consolidating Data
Consolidate By Position
Consolidate By Category
Managing a List
Creating a List
Adding Data to a List
Adding Totals
File Properties
File Properties
Workbook/Worksheet
Worksheet Styles
Autoformatting
Showing Multiple Worksheets
Comparing Workbooks
Level 8: Tips & Tricks For Excel 2003
Tips, Tricks & Shortcuts
Navigation Shortcuts
Selection Shortcuts
Data Entry Shortcuts
Operational Shortcuts
Formula and Functions Tips
Numeric Formatting
Data Expansion
Drag & Drop
Graphical Shortcuts
MS Excel Training Instructor
Dennis P. Taylor has spent over 14 years presenting PC software training to individuals in classrooms and seminars,
including employees at Amoco, IBM, and many other companies. He specializes in spreadsheet software and has co
-authored several books for spreadsheets. Five years ago, he turned his attention to Excel spreadsheets and has
become an Excel training specialist. Dennis brings a combination of in-depth knowledge and training experience to this course. Watch and Learn in minutes with Dennis.
Microsoft MS Outlook 2003 training tutorial course on DVDs Outline
Level 1
Introduction to Outlook
Starting Outlook
Getting to Know the Outlook Interface
Exploring Outlook
Using the Reading Pane
Creating New Folders
Using a Toolbar
Using Outlook Today
Using Views
Sending Email
Composing a New Message
Formatting a Message
Replying to & Forwarding Messages
Redirecting Responses Automatically
Message Options
Attachments
Using Address Books
Adding & Editing a Contact
Sending a Message from the Address Book
Creating & Using Distribution Lists
Importing & Exporting Address Books
Displaying Contacts in Various Views
Printing in Outlook
Printing Items in Outlook
Print Options
Cleaning up Outlook
Deleting Items
Recovering Deleted Items
Getting Help
Getting Help & Online Help
Level 2
Using the Calendar
Setting Up your Work Schedule
Calendar Views & Display Options
Additional Display Settings
Open Other Users' Folders / Shared Calendars
Planning Meetings & Appts.
Creating, Editing, & Recurring Appts.
Setting and Responding to Appts. Reminders
Creating, Sending and Responding to Meeting Reminders
Finding an Appointment
Using Tasks
Creating a Task
Creating and Responding to a Task Request
Scheduling Time for A Task
Setting Task Default Options
Using the Journal
Creating a Journal Entry
Creating Automatic Journal Entries
Editing a Journal Entry
Working with Journal Entry Views
Using Notes
Creating & Using Notes
Configuring & Viewing Notes
Organizing Messages
Using Organize
Creating Personal Folders
Moving & Copying Messages
Automating Your Mailbox
Toolbars
Customizing Tool Bars
Creating a New Tool Button
Customizing Views
Creating Custom Views
Using Views
Using Outlook's Anti-Spam Tools
Enabling Outlook's Junk Email
Assigning Delegates
Delegate Permissions
Sharing Folders
Level 3
Advanced Mail Message Options
Automatic Spell Checking
Creating a Signature in Outlook
Setting the Default Message Font
Setting the Default Stationary
Finding, Recalling, & Resending Messages
Finding Mail Messages
Using Activities Tab
Search Folders
Recalling & Resending
Archiving Outlook Data
Using AutoArchiving
Retrieving Archived Items
Disabling AutoArchive
Setting Archive Properties for Items
Public Folders
Creating a Public Folder
MS Outlook 2003 Trainer
Course Instructor: Diane Poremsky
Author of Microsoft Press's Outlook books
Internationally recognized Outlook expert
Industry Leading IT Trainer
Microsoft Certified Instructor
Microsoft Powerpoint Tutorial Training Courses Outline for DVDs
Level 1
Working in PowerPoint
Introduction to PowerPoint
Customizing PowerPoint
Changing Commands
Getting Help
Starting a Presentation
The DoD Model
Basics of Slide Layout
A Visual Overview
Managing Content in the Outline
Getting Content Just Right
AutoCorrect and AutoFormat
Importing Outlines from Word
Additional Content Tips
Level 2
Working with Slides-Text-Pictures
Introduction to Internetworking
Working with Place Holders
Working with Text Objects
Pictures
Compressing Pictures
Working with ClipArt
Editing Objects
Formatting Objects
Level 3
Organization Charts & Diagrams
Introduction to Diagrams
Creating Charts & Diagrams
Creating Free-Form Diagrams
Creating Data-Driven Charts
PowerPoint
Inserting Charts from Excel
Inserting Data & Text Table
PowerPoint
Integrating Applications
Aligning Text with Tables
Adding Video & Sound
Adding Video
Adding Sound
Animating PowerPoint Objects
Custom Animation
Animating Text
Animating Charts
Creating Motion Paths
Collaborating on a Presentation
Reviewing a Presentation with Outlook
Reviewing a Presentation without Outlook
Delivering a Presentation Remotely
Packaging a Presentation
Creating Web-Based Presentations
Slide Transitions
Customizing Color Schemes
Working with Slide Masters
Restoring the Formatting
PowerPoint 2003 Level 4
Formatting the Slide Background
Formatting the Slide Background
Designs & Masters
Designing Masters
Master Slides
Preparing a Presentation for Delivery
Rearranging & Organizing Slides
Creating Custom Slide Shows
Summary Slides
Configuring Slide Timing
Working with Hyperlinks & Action Buttons
Navigating with Hyperlinks
Using Action Buttons
Presenting a PowerPoint Slide Show
Setup Show
Launching & Navigating a Slide Show
Marking Up Slides During a Presentation
Using Advanced Presentation
Printing Presentations
Printing
Printing in Color and B&W
Printing Handouts & Notes
Exporting a Presentation to Word
Collaborating on a Presentation
Reviewing a Presentation with Outlook
Reviewing a Presentation without Outlook
Delivering a Presentation Remotely
Packaging a Presentation
Creating Web-Based Presentations
MS PowerPoint Training Instructor
Course Instructor: Dan Holme
Dan is one of the best technical instructors in the nation, with an innate understanding of how to communicate
complex topics and ensure that a course is educational and entertaining. With degrees from both Yale and
Thunderbird and 14 years of international public speaking experience, Dan's energetic style and communications techniques ensures your success.
Microsoft Word Training Tutorial Course Outline on DVDs
Level 1
First Steps in Word
Starting Word
The Word Window
Creating Content
Fundamental File Operations
Working Comfortably in Word
Fundamentals of Working in Word
Copy and Paste
Select and Do
Help
Working Productively in Word
Navigating Word Documents Efficiently
Selecting Efficiently
Working as a Power User
Templates
New Word Documents
The Blank Document
Template
Custom Templates
Managing Templates
Level 2
Content
Creating Content
Inserting Symbols & Characters
Spelling & Grammar
AutoFormat & Auto Correct
Automating Content Creation
Using Word Reference Materials
Working with Fields
Formatting Word Documents
The Format Menu
Paragraph Formats
Bullets & Numbering
Borders & Shading
The Format Painter
Styles
How to Un-Format a Document
Aligning Text with Tables & Tabs
Tables
Tabs
Managing Documents
Save and Save As
Level 3
Sections
Pagination
Page Setup
Headers & Footers
Creating Multiple Sections
Headers & Footers in Multiple Sections
Newspaper Columns
Making Long Documents Accessible
Juggling Projects
Tables of Contents
Document Tables & indices
Endnotes-Footnotes & Cross References
Auto Summarize
Master Documents
Macros
Creating Macros with the Recorder
Playing Macros
Macro Security
Editing & Managing Macros
Level 4
Reviewing Documents
Highlighting
Collaborative Reviews
Compare & Merge
Comparing Document Versions
Sealing & Protecting Documents
Forms
Creating Forms
Advanced Forms
Protecting Sections of Complex Forms
Fill-in-Fields
Working with Web Documents
Saving & Opening Web Documents
Publishing to the Web
Working with Hyperlinks
Applying Themes
Structuring Documents with XML
Level 5
Photos ClipArt & WordArt
Inserting & Positioning Pictures
Photo Alteration
Compressing Pictures
ClipArt
WordArt
Drawing
Basic Objects
Creating Freeform Diagrams
Organization Charts & Diagrams
Charts
Final Format Tips
Creating Text Boxes
Page Borders
Page Background & Watermark
Envelopes, Labels & Mail Merge
Envelopes & Labels
MS Word Training Instructor
Course Instructor: Dan Holme
Dan is one of the best technical instructors in the nation, with an innate understanding of how to communicate
complex topics and ensure that a course is educational and entertaining. With degrees from both Yale and
Thunderbird and 14 years of international public speaking experience, Dan's energetic style and communications techniques ensures your success.
|
