Font size:

Interactive Instructor-Based Office 2000 Professional Video Training Course on DVD-ROM. Computer Based Training (CBT) and Video Based Training (VBT) have emerged as the premier training tools in recent years. KeyStone Self-Paced CBT/VBT courses are known for their high quality in-depth content. Compared to traditional training methods, KeyStone courses cost less and users can learn faster while taking advantage of some of the best trainers in the industry. They are easy to use, comfortable to follow, perfect for training at the office, on the road, or at home.

Courses included: • Access 2000: Beginner, Intermediate, and Advanced • Excel 2000: Beginner, Intermediate, and Advanced • FrontPage 2000: Beginner, Intermediate, and Advanced • Outlook 2000: Beginner, Intermediate, and Advanced • PowerPoint 2000: Beginne

Course outline: 1.0 Introduction to Access 2000 1.1 Starting Access 1.2 Opening an Existing Database 1.3 The Access Desktop 1.4 The Database Window 1.5 A Preview of the Database Components 2.0 Working with an Existing Database 2.1 Viewing and Navigating Table Data 2.2 Editing Table Data 2.3 Adding Records to a Table 2.4 Selecting and Deleting Records 2.5 Find and Replace 2.6 Modifying the Appearance of a Datasheet 2.7 Spell-Check and Auto-correct 3.0 Form Basics 3.1 Moving from Record to Record 3.2 Finding 3.3 Sorting 3.4 Filtering 3.5 AutoForms 3.6 Using a Form Wizard 3.7 Conditional Formatting 4.0 Report Basics 4.1 Moving from Page to Page 4.2 Zooming In and Out 4.3 Viewing Multiple Pages 4.4 Printing 4.5 AutoReports and the Report Wizard 4.6 Page Setup 5.0 Printing Database Objects 5.1 Printing Table Datasheets 5.2 Printing Queries 5.3 Printing Forms 5.4 Printing Reports 6.0 Getting Help 6.1 The Office Assistant and Index Searching 6.2 Context-Sensitive Help and Printing Help Topics 7.0 Database Maintenance and Shortcuts 7.1 Backing Up and Restoring a Database 7.2 Compacting and Repairing a Database 7.3 Converting a Database to a Previous Version 7.4 Organizing Database Objects into Groups Access 2000: Intermediate Level 1.0 Planning and Designing a Database 1.1 Evaluating Inputs and Outputs 1.2 Normalization 1.3 Creating a Database Using a Wizard 1.4 Creating a Database from Scratch 2.0 Building and Modifying Tables 2.1 Creating Tables Using a Wizard 2.2 Creating Tables from Scratch and Data Types 2.3 Setting Primary Keys 2.4 Field Properties 2.5 Input Masks 2.6 The Lookup Wizard 2.7 Indexes 3.0 Working with Relationships 3.1 Introduction to Relationships 3.2 Benefits of Relationships 3.3 Types of Relationships 3.4 Referential Integrity 3.5 Indexes and Relationships 3.6 Printing Relationships 4.0 Designing Simple Queries 4.1 Selecting Fields and Ordering the Query Result 4.2 Refining Queries with Criteria 4.3 Updatability of Query Results 4.4 Queries Based on Multiple Tables Access 2000: Advanced Level 1.0 Building and Modifying Forms 1.1 Adding Controls 1.2 Selecting Controls 1.3 Moving, Sizing and Deleting Controls 1.4 Aligning Controls 1.5 Changing Control Properties 1.6 Changing the Tab Order Controls 1.7 Form Properties 1.8 Working with Combo Boxes and List Boxes 2.0 Building and Modifying Reports 2.1 Understanding Report Bands 2.2 Working with Controls 2.3 Creating Groups and Totals Reports 2.4 Working with Report Properties 2.5 Modifying Selection Criteria 3.0 Database Startup Options 3.1 Setting the Application, Icon, and Startup Form 3.2 Designing other Startup Information 4.0 Importing, Exporting and Linking 4.1 Exporting to Another Database 4.2 Exporting to an Excel Spreadsheet 4.3 Exporting to ASCII 4.4 Exporting to HTML 4.5 Importing from Another Access Database 4.6 Importing Spreadsheet Data 4.7 Importing ASCII Data 4.8 Importing from HTML 4.9 Linking to Another Access Database 4.10 Linking to Another Type of Database 4.11 The Linked Table Manager Excel 2000: Beginner Level 1.0 The Excel Screen 1.1 The Excel Workbook and Worksheets 1.2 Title Bar & Menu Bar 1.3 Toolbars 1.4 Formula Bar 1.5 Columns & Rows 1.6 Navigation 1.7 Sheet Names & the Status Bar 1.8 Mouse Pointers & Shortcut Menus 2.0 Entering Data into a Worksheet 2.1 Data Entry Techniques 2.2 Auto-Fill Entry Techniques 2.3 Erasing Data 2.4 Auto Complete 3.0 Entering Formulas 3.1 Three Methods of Entering Formulas 3.2 Repeating a Formula 3.3 Formulas Beyond Addition and Subtraction 4.0 Basic Functions 4.1 Summation 4.2 Recalculating Effects (Change one cell and five others change) 4.3 Averages 5.0 Formatting 5.1 The Formatting Toolbar 5.2 Adjusting Column-width and Row-height 5.3 Numeric Formatting 6.0 Saving, Opening & Closing Files 6.1 File Save or File Save As 6.2 Opening a File 6.3 Closing a File 6.4 Creating a New Workbook Excel 2000: Intermediate Level 1.0 Changing Worksheet Layout 1.1 Inserting Columns, Rows and Cells 1.2 Deleting Columns, Rows and Cells 1.3 Moving Cells 1.4 Copying Cells 2.0 Additional Formatting 2.1 Formatting Cell Attributes and Alignment 2.2 Borders 2.3 Numeric Formatting 2.4 Center Text Across Columns 2.5 Hiding & Unhiding Columns & Rows 3.0 Printing 3.1 Using Print Preview and Page Setup 3.2 Printing Controls 3.3 Using Page Break Preview 4.0 Using Cell References 4.1 Absolute References 4.2 Mixed References 5.0 Tools Options Command 5.1 Show/Hide Gridlines 5.2 Show/Hide Formulas 5.3 Recently Used Files List 5.4 Sheets in New Workbook 5.5 Default Settings Excel 2000: Advanced Level 1.0 Adjusting Worksheet Views 1.1 Freeze/Unfreeze Panes 1.2 Horizontal & Vertical Split Screen 2.0 Auditing Techniques 2.1 Using the Auditing Toolbar 2.2 Tracing Dependent Cells 2.3 Tracing Precedent Cells 3.0 Using Functions 3.1 Paste Function 3.2 The PMT Function 3.3 Expanding the Use of Standard Functions 4.0 Logical Functions 4.1 IF Functions and Relational Operators 4.2 Using Words in IF Functions 4.3 Using IF Functions with Arithmetic Operators 4.4 Using Logical Operators with the IF Function 4.5 Nested IF Functions 4.6 Using the VLOOKUP Function 5.0 Date & Time Functions 5.1 Using Dates as Values 5.2 Entering a Series of Dates 5.3 Date/Time Entry Techniques 6.0 Multi-Sheet Workbooks 6.1 Re-Naming & Re-Ordering Sheets 6.2 Inserting and Deleting Sheets 6.3 Moving, Copying and Grouping Sheets 6.4 Formulas Across Multiple Sheets FrontPage 2000: Beginner Level 1.0 Welcome to FrontPage 2000 1.1 Looking Around 1.2 Building Your First Web 2.0 Page Editor 2.1 Text Formatting 2.2 Other Formatting Features 2.3 Paragraph Formatting 2.4 Saving your Changes 2.5 Normal View 2.6 HTML View 2.7 Preview 2.8 Summary of Topics 3.0 Navigation View 3.1 Introduction to Navigation View 3.2 Viewing Your Site 3.3 Opening a Page 3.4 Adding a Page 3.5 Moving a Page 3.6 Renaming a Page 3.7 Deleting a Page 3.8 Summary of Topics 4.0 Appendix - Installing FrontPage 2000 4.1 Introduction to Installing 4.2 What You Will Need 4.3 Launching Setup 4.4 Configuring Options 4.5 Summary of Topics FrontPage 2000: Intermediate Level 1.0 Folder View 1.1 Viewing Your Site 1.2 Sorting by Column 1.3 Opening a Page 1.4 Adding & Moving a Page 1.5 Deleting a Page 1.6 Adding a Folder 2.0 Themes 2.1 What are Themes and Selecting a Theme 2.2 Theme Options 2.3 Customizing a Theme 2.4 Summary of Topics 3.0 Hyperlinks 3.1 What is a Hyperlink? 3.2 Defining a Hot Spot 3.3 Defining an Action 3.4 Summary of Topics 4.0 The Task View 4.1 What is a Task? 4.2 Completing a Task 4.3 Defining a New Task 4.4 Reassigning a Task 5.0 Security 5.1 Web Server 5.2 User Accounts 5.3 Browse, Author, Administer Access FrontPage 2000: Advanced Level 1.0 Tables 1.1 What is a Table? 1.2 Inserting a Table 1.3 Table Properties 2.0 Forms 2.1 What is a Form? 2.2 Building a Form 2.3 Retrieving Form Results 3.0 Cascading Style Sheets 3.1 What is a Style? 3.2 Styles in FrontPage 2000 3.3 Creating & Linking a Style Sheet 4.0 Frames 4.1 What is a Frame and Building a Framed Page 4.2 Frame Properties 5.0 Special Effects 5.1 Dynamic HTML 5.2 Page Transitions 5.3 Browser Compatibility 6.0 Publishing Your Web 6.1 Open Existing Web 6.2 Publish to Web Server 6.3 Verifying Your Web Site Outlook 2000: Beginner Level 1.0 Getting Started 1.1 Setting Up a Profile 1.2 Personal folders vs. Exchange Server 1.3 The Welcome Dialog and the Office Assistant 1.4 Getting Comfortable with Outlook 1.5 The Outlook Bar 1.6 Viewing Drive Letters and Folders 1.7 Creating Outlook Bar Shortcuts 1.8 Browsing Web Sites & Using Favorites 1.9 Getting Help 1.10 Changing Outlook Profiles 1.11 The Outlook Today View 2.0 Sending & Receiving Messages 2.1 The Outlook Messaging Window 2.2 Reading & Replying to Messages 2.3 Sorting Messages 2.4 Forwarding a Message 2.5 Organizing your Messages Into Folders 2.6 Printing Messages & Print Options 2.7 Address Books 2.8 Composing & Sending New Messages 2.9 Deleting Messages 2.10 The Office 2000 Clipboard 3.0 The Outlook Calendar 3.1 Working Within a Separate Calendar Window 3.2 Displaying your Schedule 3.3 Appointments & Events 3.4 Editing an Appointment or Event 3.5 Copying, Moving, & Deleting 3.6 Scheduling Multi-day Events 3.7 Recurring Appointments & Events 3.8 Turning an Email Message into an Appointment 3.9 Customizing the Calendar 3.10 Customizing Menu & Tool Bars 3.11 Printing & Setting Print Options 3.12 Saving as a Web Page 3.13 Setting Meetings & Calendar Options 4.0 Working with Contacts 4.1 Modifying and Creating Contacts 4.2 Categorizing Contacts 4.3 Deleting a Contact 4.4 Contact Information via Email & Printing Contact Information 4.5 Manually Recording in a Journal 4.6 Linking, Following up on, & Sorting Contacts 4.7 Having Outlook Dial the Phone 4.8 Dragging and Dropping 4.9 Contacts & other Office 2000 Programs 4.10 Customizing the Menu Bar and Task Bar Outlook 2000: Intermediate Level 1.0 Enhanced Messaging Techniques 1.1 Customizing Outlook Today 1.2 Formatting Messages 1.3 Microsoft Word as Your E-mail Editor 1.4 WordMail Templates (Themes) & Custom Signatures 1.5 Resending Messages 1.6 Recalling a Message 1.7 Distribution Lists 1.8 Personal Address Books 1.9 File Attachments 1.10 The Find & Advanced Find Features 2.0 Working with the Task List 2.1 One-Time Tasks 2.2 Assigning Tasks to Others 2.3 Accepting, Declining & Tracking the Progress of Tasks 2.4 Assigning Delegate Access 2.5 Recurring Tasks 2.6 Changing Task Views 2.7 Organizing Tasks 2.8 Creating Tasks from E-mail Messages 2.9 New Appts, Events, & E-mail Messages 2.10 Customizing the Task Bar 3.0 Outlook Notes 3.1 Working with Outlook Notes 4.0 Using the Outlook Journal 4.1 Custom Options & Recording Tasks 4.2 Journal Entries 5.0 Faxing with Outlook 5.1 Installing Microsoft Fax 5.2 Adding & Configuring the Fax Service 5.3 Sending & Customize Faxes 5.4 Receiving a Fax 6.0 Working with Newsgroups in Outlook 6.1 Newsreader Features 6.2 Newsgroup Postings 7.0 Customizing Outlook 7.1 Setting General Preferences 7.2 Customizing the Menu Bar & the Task Bar 7.3 Time Zone Settings Outlook 2000: Advanced Level 1.0 Advanced Information Services 1.1 Multiple Personal Folder Files 1.2 Working Offline 1.3 Quick Synchronization Group 2.0 Advanced Messaging Features 2.1 Dial-up Networking & Remote Mail 2.2 Using Stationery to Create HTML Messages 2.3 Email Signatures 2.4 Adding a Vcard to a Message 2.5 Using Public Folders Offline 2.6 Exchange Server 5.5 Undelete 2.7 The Rules Wizard 2.8 Granting Folder Permission to Others 2.9 Assigning Delegates 2.10 Handling Junk Email 2.11 Office 2000 Documents 2.12 Mail Merge with Word 3.0 Advanced Messaging Options 3.1 Custom Views 3.2 Flagging Specific Messages 3.3 Conducting a Vote 3.4 Delivery Date & Other Options 3.5 Archive Mail Messages 3.6 Importing & Exporting Data to Other E-mail Programs 4.0 Group Collaboration Features 4.1 Public Folders 4.2 Net Folders 4.3 Using the iCalendar Feature 4.4 Importing & Exporting Data PowerPoint 2000: Beginner Level 3.0 Advanced Messaging Options 3.1 Custom Views 3.2 Flagging Specific Messages 3.3 Conducting a Vote 3.4 Delivery Date & Other Options 3.5 Archive Mail Messages 3.6 Importing & Exporting Data to Other E-mail Programs 4.0 Group Collaboration Features 4.1 Public Folders 4.2 Net Folders 4.3 Using the iCalendar Feature 4.4 Importing & Exporting Data 4.0 Working with Text 4.1 Spell Check & Promotion and Demotion 4.2 Aligning Text 4.3 Adding a Text Box 4.4 Fonts 4.5 Office Clipboard 5.0 Working with Visual Elements 5.1 Adding Clip Art 5.2 Adding Shapes & Word Art 5.3 Grouping 5.4 Fill Features 5.5 Adding Tables 5.6 Tips for Beginners PowerPoint 2000: Intermediate Level 1.0 Customizing a Presentation 1.1 Bullets and Numbering 1.2 Animating Text 1.3 Slide Transitions 1.4 Speaker Notes 2.0 Creating Output 2.1 Previewing Presentations in Black and White 2.2 Printing Slides 2.3 Printing Handouts 2.4 Printing Speaker Notes 2.5 Printing the Outline View 3.0 Delivering a Presentation 3.1 Starting a Slide Show 3.2 Using the On-Screen Navigation Tools 3.3 The Pen Tool 3.4 Printing Overhead Transparencies 4.0 Managing Files 4.1 Saving Presentations 4.2 Publishing to the Web 4.3 Hyperlinks 4.4 The Office Assistant 5.0 Advanced Features 5.1 Automatically Create a Summary Slide 5.2 Automatically Create an Agenda Slide 5.3 Creating our own Design Template 5.4 Auto Content Wizard 6.0 Modifying a Presentation 6.1 Applying animation effects 6.2 Inserting animated GIF's 6.3 Adding an Action Button 6.4 Customizing a Color Scheme 6.5 Creating a Custom Background 6.6 Changing Tab Formatting 6.7 Hiding Slides 6.8 Adding a Presentation within a Presentation 6.9 Setting automatic Slide Timings PowerPoint 2000: Advanced Level 1.0 Working Visual Elements 1.1 Adding Textured Backgrounds 1.2 Applying Diagonal Borders to a Table 2.0 Using Data from Other Sources 2.1 Exporting an Outline to Word 2.2 Importing an Outline from Word 2.3 Adding a Table from Word 2.4 Inserting an Excel Chart 2.5 Adding Sound 2.6 Adding Video 3.0 Creating Output 3.1 Saving a Slide as a Graphic 3.2 Generate Meeting Notes 3.3 Changing the Output Format ( Page Setup ) 3.4 Export to 35mm Slides 4.0 Delivering a Presentation 4.1 Save Presentation for Use on Another Computer ( Pack N' Go ) 5.0 Managing Files 5.1 Saving Embedded Fonts in a Presentation 5.2 Saving HTML to a Specific Target Browser 6.0 Toolbars 6.1 Customizing the Toolbar 6.2 Creating a Toolbar 7.0 Working with Charts & Graphs 7.1 Building and Modifying a Chart or Graph 7.2 Building an Organization Chart 7.3 Animating an Organization Chart 8.0 Collaborating with Workgroups 8.1 Broadcasting Overview 8.2 Setting Up the Presentation for Broadcasting 8.3 Viewing a Presentation on the Web 8.4 Using Net Meeting to Schedule a Broadcast Publisher 2000: Beginner Level 1.0 Getting Started 1.1 Creating a New Publication 1.2 Exploring the Publisher Desktop 1.3 Navigating about a Publication 1.4 Zooming In and Out 1.5 Saving Your Work 1.6 The Save Reminder 1.7 Closing and Opening a Publication 2.0 Using the Objects Toolbar 2.1 Changing the Placement of the Objects Toolbar 2.2 Inserting Text Frames 2.3 Introduction to Word Art 2.4 Adding Pictures 3.0 Working with a Publication 3.1 Entering Text 3.2 Formatting Text 3.3 Additional Formatting 3.4 Moving, Copying, and Deleting Text 3.5 Inserting and Deleting Pages 3.6 Selecting Objects 3.7 Moving and Sizing Objects 3.8 Deleting Objects 3.9 Layering Objects 3.10 Working with Guides and Rulers 3.11 Modifying the Page Setup 3.12 Working with the Publication Background 4.0 Getting Help 4.1 The Assistant 4.2 Using the Help Index & Printing Help 4.3 Getting Help Over the Internet & Customizing the Assistant 5.0 Printing a Publication 5.1 Checking the Printer Setup 5.2 Selecting Printer Options & Sending Your Work to the Printer 5.3 Troubleshooting Printing Publisher 2000: Intermediate Level 1.0 Wizards & Design Sets 1.1 Using Wizards 1.2 Customizing a Wizard Document 1.3 Working with Design Sets 1.4 Using Special Paper 1.5 The Design Gallery Object 2.0 Advanced Text Techniques 2.1 Connecting and Disconnecting Frames 2.2 Importing Text 2.3 Editing Articles in Word 2.4 Search and Replace 2.5 The Spell Checker and AutoCorrect 2.6 Indents, Bullets, Numbered Lists, and Tabs 2.7 Other Cool Text Techniques 2.8 Wrapping Text Around Other Objects 2.9 Working with Styles 3.0 Advanced Page Techniques 3.1 Different Backgrounds for Left-Hand and Right-Hand Pages 3.2 Accommodating Unique Pages 3.3 Adding Page Numbers 3.4 Changing the Starting Page Number 3.5 Continued On and Continued From 3.6 Creating Multi-column Text Frames 3.7 Wrapping Text Around Other Elements 4.0 Advanced Object Techniques 4.1 Inserting Drawing Objects 4.2 Grouping Objects 4.3 Aligning Objects 4.4 Rotating Objects Publisher 2000: Advanced Level 1.0 Advanced Graphic Techniques 1.1 Cropping a Picture 1.2 Inserting Pictures From the Web 1.3 Finding Clips with Keywords 1.4 Scaling Pictures 1.5 Re-Coloring Pictures 1.6 Rotating Pictures 1.7 Adding Borders and Shadows 1.8 Customizing the Clip Art Gallery 2.0 Border Art 2.1 Creating Border Art 2.2 Customizing Border Art 3.0 Word Art 3.1 Creating a Word Art Object 3.2 Changing Text Formatting 3.3 Character Spacing 3.4 Special Effects, Shading, Shadowing & Borders 3.5 Editing a Word Art Object 4.0 Miscellaneous Cool Advanced Features 4.1 Personal Information 4.2 The Design Checker 4.3 Sound 4.4 Video 5.0 Tables 5.1 Adding a Table & Creating a Header 5.2 Entering Data into the Table 5.3 Selecting Cells, Rows and Columns 5.4 Inserting and Deleting Rows and Columns 5.5 Formatting Tables Data 6.0 Advanced Printing Techniques 6.1 Working with an Outside Printer 6.2 Specialized Printing Techniques 7.0 OLE 7.1 Inserting and Updating an OLE Object Word 2000: Beginner Level 1.0 Getting Started 1.1 Starting Word 2000 1.2 Touring the Word Window 2.0 Creating New Documents 2.1 Entering Text 2.2 Saving Your Work 2.3 Printing & Closing a Document 2.4 Working with a Template 2.5 Using a Wizard 3.0 Revising Documents 3.1 Opening a Document 3.2 Moving in a Document 3.3 Basic Editing 3.4 Adding a Date 3.5 Click and Type 3.6 Envelopes & Labels 3.7 Multiple Page Documents 4.0 Getting Help 4.1 Office Assistant 4.2 Help Window 4.3 Context Sensitive Help 5.0 Essential Skills 5.1 Selecting Text 5.2 Copying & Moving Text 5.3 The Office Clipboard 5.4 Undo, Redo, Repeat, & AutoCorrect 5.5 AutoComplete 6.0 Character Formatting 6.1 Changing Font Formatting 6.2 The Formatting Toolbar 6.3 Symbols & Special Characters 6.4 AutoFormat As You Type 7.0 Paragraph Formatting 7.1 Paragraph Alignment 7.2 Line Spacing 8.0 Document Formatting 8.1 Margins & Paper Size 8.2 Controlling Page Breaks 9.0 Proofing Documents 9.1 Spelling & Grammar 9.2 Thesaurus 10.0 Previewing & Printing a Document 10.1 Previewing a Document 10.2 Printing a Document 11.0 Shortcuts 11.1 Shortcut Menus 11.2 Keyboard Shortcuts 11.3 Exiting Out of Word Word 2000: Intermediate Level 1.0 Document Management 1.1 Document V 1.2 Working with Multiple Document Windows 1.3 File Management 2.0 Additional Editing Tools 2.1 Find & Replace 2.2 AutoText 2.3 Format Painter 3.0 Customizing Word 3.1 Toolbars 3.2 Personalized Menus 3.3 Defaults 3.4 Options 4.0 More Paragraph Formatting 4.1 Tabs 4.2 Indents 4.3 Bullets, Numbering, & Line Breaks 4.4 Special Spacing 4.5 Sorting Text 4.6 Borders & Shading 5.0 Page Numbers, Headers & Footers 5.1 Numbering Pages 5.2 Headers & Footers 6.0 Section Formatting 6.1 Using Sections 6.2 Newspaper Columns 7.0 Introduction to Graphics 7.1 Basics Word 2000: Advanced Level 1.0 Tables 1.1 Creating a Table 1.2 Navigating and Modifying a Table 1.3 Formatting a Table 2.0 Automatic Formatting and Styles 2.1 Applying Styles 2.2 Creating Your Own Styles 2.3 Modifying Existing Styles 3.0 Document Templates 3.1 Personalizing Word's Templates 3.2 Creating Your Own Styles 3.3 Automating with Field Codes 4.0 Long Documents & Reports 4.1 Cross-references & Bookmarks 4.2 Footnotes 4.3 Tables of Contents 4.4 Indexes 4.5 Outlines 4.6 Document Map 5.0 Sharing Documents 5.1 Comments 5.2 Tracking Changes 5.3 Protecting Documents 5.4 Saving Different Versions 6.0 Macros 6.1 Creating & Running Macros 6.2 Editing Macros 6.3 Automatic Macros ' Access 2000: Beginner Level 1.0 Introduction to Access 2000 1.1 Starting Access 1.2 Opening an Existing Database 1.3 The Access Desktop 1.4 The Database Window 1.5 A Preview of the Database Components 2.0 Working with an Existing Database 2.1 Vie
Register Now
Microsoft Office 2000 Professional - Instructor-based Video Training Online course
  • Course ID:
    194692
  • Duration:
    n/a
  • Price:
    $411