Microsoft Excel Xp Training on CD-ROM - Training Resources

Word 2002 Basic Lesson 1: Touring The Word Window Introduction Lesson Objectives Opening Word 2002 The Title Bar Menu Bar Overview Standard Toolbar Overview Formatting Toolbar Overview Displaying Other Toolbars Repositioning A Toolbar Docking A Toolbar Hiding A Toolbar Overview Of Task Panes Switching Between Task Panes Showing & Hiding The Task Pane Horizontal Ruler Overview The Status Bar Exploring Views Print  more...

Word 2002 Advanced Lesson 1: Building Tables & Charts Introduction Lesson Objectives Opening Word The Task Pane Inserting Headers & Footers Inserting A Picture In A Header Formatting Text In A Header Defining A Style The Style & Formatting Task Pane Switching Between Headers & Footers Inserting Text In A Footer Inserting Page Numbers Inserting A Section Break Creating A Different Header & Footer Creating A New  more...

Office XP Professional Suite of 17 The Office XP Deluxe Professional Suite of 17 includes the following: Access 2002: Basic (ID#8933) Access 2002: Intermediate (ID#8932) Access 2002: Advanced(ID#8931) Excel 2002: Basic (ID#8936) Excel 2002: Intermediate (ID#8937) Excel 2002: Advanced (ID#8938) Outlook 2002: Volume 1 and Volume 2 (ID#8939) Powerpoint 2002: Basic (ID#8940) Powerpoint 2002: Intermediate (ID#8941) Powerpoint 2002:  more...

Office XP Professional Suite of 14 The Office XP Professional Suite of 14 includes the following: Access 2002: Basic (ID#8933) Access 2002: Intermediate (ID#8932) Access 2002: Advanced(ID#8931) Excel 2002: Basic (ID#8936) Excel 2002: Intermediate (ID#8937) Excel 2002: Advanced (ID#8938) Outlook 2002: Volume 1 and Volume 2 (ID#8939) Powerpoint 2002: Basic (ID#8940) Powerpoint 2002: Intermediate (ID#8941) Powerpoint 2002: Advanced  more...

Excel 2000 - Proficient User DiscoverWare's Discover Excel 2000 is an interactive productivity tool for users of Microsoft Excel 2000. Excel 2000 builds on the spreadsheet capabilities of previous versions of the program to provide powerful tools for creating and sharing professional worksheets online and on the Web. Topics include basic spreadsheet concepts, workbook and file management, using formulas and functions, editing  more...

Access 2000 User Series Access 2000 Beginning (2 Hours 6 Minutes) 1.0 Introduction (26 Minutes) 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 (33 Minutes) 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  more...

Access 2000 Advanced Access 2000 Advanced (2 Hours 3 Minutes) 1.0 Building and Modifying Forms (51 Minutes) 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 (26 Minutes) 2.1 Understanding Report  more...

Excel 2000 Beginning Beginning (2 Hours 16 Minutes) 1.0 The Excel Screen (32 Minutes) 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 (27 Minutes) 2.1 Data Entry Techniques 2.2 Auto-Fill Entry Techniques 2.3 Erasing Data 2.4 Auto Complete  more...

Excel 2000 Intermediate Intermediate (2 Hours 5 Minutes) 1.0 Changing Worksheet Layout (26 Minutes) 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 (6 Minutes) 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 (25 Minutes)  more...

Excel 2000 Advanced Advanced (2 Hours 2 Minutes) 1.0 Adjusting Worksheet Views (13 Minutes) 1.1 Freeze/Unfreeze Panes 1.2 Horizontal & Vertical Split screen 2.0 Auditing Techniques (12 Minutes) 2.1 Using the Auditing Toolbar 2.2 Tracing Dependant Cells 2.3 Tracing Precedent Cells 3.0 Using Functions (18 Minutes) 3.1 Paste Function 3.2 The PMT Function 3.3 Expanding the use of standard functions 4.0 Logical Functions  more...

PowerPoint 2000 Advanced PowerPoint 2000 Advanced (1 Hour 30 Minutes) 1.0 Working Visual Elements (3 Minutes) 1.1 Adding Textured Backgrounds 1.2 Applying Diagonal Borders to a Table 2.0 Using Data from other Sources (20 Minutes) 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 (12 Minutes)  more...

Excel 2000 User Set of 3 Beginning (2 Hours 16 Minutes) 1.0 The Excel Screen (32 Minutes) 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 (27 Minutes) 2.1 Data Entry Techniques 2.2 Auto-Fill Entry Techniques 2.3 Erasing Data 2.4 Auto Complete  more...

PowerPoint 2000 Set of 3 PowerPoint 2000 Beginning (1 Hour 29 Minutes) 1.0 Getting a round in PowerPoint (4 Minutes) 1.1 The PowerPoint Screen 2.0 Creating a Presentation (23 Minutes) 2.1 Types of Slides & Work Views 2.2 Creating a Presentation with a template & or Wizard 2.3 Creating a Presentation from Existing Slides 2.4 Deleting Slides in different Views 2.5 Inserting Headers and Footers 2.6 Sending a Presentation Via  more...

Access 2000 Advanced LESSON_STR   Access 2000 Advanced Lesson 1: Working With Menus And Toolbars,Opening An Existing Database,Access Sample Databases, Installing The Northwind Database, The Show Me Menu, Customizing Toolbars And Menus, Customizing Toolbars, Customizing Menus, Creating Custom Toolbars, Adding Commands To A Custom Toolbar, Sorting Records, Hiding A Toolbar, Deleting A Toolbar, Grouping Toolbar Commands,  more...

Word 2000 Introduction Word 2000 Basic Word 2000 Basic Lesson 1: Word Window Features, Introduction, Opening Word, The Title Bar, The Menu Bar, The Standard Toolbar, The Formatting Toolbar, The Ruler, The Status Bar, The Print Layout View, The Normal View, The Web Layout View, The Outline View, The Vertical Scroll Bar, The Horizontal Scroll Bar, Words Personalized Menus, The File Menu, The Insert Menu, The Format Menu,  more...

Excel 2000 Introduction Excel 2000 Basic Excel 2000 Basic Lesson 1: Getting Started, Introduction, Opening Excel 2000, What is Excel?, The Office Assistant, Office Assistant Options, The Title Bar, The Menu Bar, The Standard Toolbar, The Formatting And Formula Toolbar, The Drawing Toolbar And Minimizing Excel, Maximizing Excel, Minimizing A Spreadsheet, Restoring A Spreadsheet, Maximizing A Spreadsheet, The Horizontal  more...

Excel 2000 Intermediate LESSON_STR Excel 2000 Intermediate Lesson 1: Getting To Know The Worksheet Window, Introduction, Opening Excel, Splitting Your Worksheet Vertically, Splitting Your Worksheet Horizontally, Removing The Split Bars From Your Worksheet, Freezing Panes, Unfreezing Panes, Freezing Multiple Panes, Unfreezing Multiple Panes, Hiding Columns And Rows Using The Format Menu, Hiding Columns And Rows Using Your  more...

Excel 2000 Advanced LESSON_STR   Excel 2000 Advanced Lesson 1: Working With Records And Filters, Opening Excel, Bringing Data From A Web Page Into Excel, Hiding Toolbars, Increasing Your Field Of View, The Sort Dialog Box, "Then by" Sorting, Using AutoFilter, Using Custom AutoFilter, Using The Data Form Dialog Box, Verifying A Record, Change A Record, Deleting A Record, Disabling AutoFilter, Removing Filters,  more...

Excel 2000 Suite The Excel 2000 consists of the following courses: Excel 2000 Introduction Excel 2000 Intermediate Excel 2000 Advanced To review individual course descriptions, please return to the previous page and select the desired title(s). Save $30 by ordering the suite.  more...

Office 2000 Standard Suite The Microsoft Office 2000 Standard Training Suite consists of the following courses: Word 2000: Introduction (ID#6819) Word 2000: Intermediate (ID#6820) Word 2000: Advanced (ID#6821) Excel 2000: Introduction (ID#6822) Excel 2000: Intermediate (ID#6823) Excel 2000: Advanced (ID#6824) PowerPoint 2000: Introduction (ID#6825) PowerPoint 2000: Intermediate (ID#6826) PowerPoint 2000: Advanced (ID#6827)  more...

Office 2000 Professional Suite The Microsoft Office 2000 Professional Training Suite consists of the following courses: Word 2000: Introduction (ID#6819) Word 2000: Intermediate (ID#6820) Word 2000: Advanced (ID#6821) Excel 2000: Introduction (ID#6822) Excel 2000: Intermediate (ID#6823) Excel 2000: Advanced (ID#6824) PowerPoint 2000: Introduction (ID#6825) PowerPoint 2000: Intermediate (ID#6826) PowerPoint 2000: Advanced  more...

PowerPoint XP Comprehensive DiscoverWare's Discover PowerPoint XP is an interactive productivity tool for users of Microsoft PowerPoint XP. PowerPoint XP builds on the presentation features of previous versions of the program to provide powerful tools for creating and sharing professional documents online and on the Web. Topics cover PowerPoint basics, creating presentations, working with slides, working with text, graphics,  more...

Office XP Proficient The Office XP Proficient Suite includes the following: Access XP Proficient & Expert (ID#8872) Excel XP Proficient & Expert (ID#8873) Outlook XP Proficient & Expert (ID#8874) PowerPoint XP Comprehensive (ID#8875) Word XP Proficient & Expert (ID#8876) To review individual descriptions, please select the corresponding product ID number under Related Courses below.  more...

Office XP Expert The Office XP Expert Suite includes the following: Access XP Proficient & Expert (ID#8872) Excel XP Proficient & Expert (ID#8873) Outlook XP Proficient & Expert (ID#8874) PowerPoint XP Comprehensive (ID#8875) Word XP Proficient & Expert (ID#8876) To review individual descriptions, please select the corresponding product ID number under Related Courses below.  more...

Excel 2002 Set of 3 Excel 2002: Set of 3 includes the following: Excel 2002: Basic Excel 2002: Intermediate Excel 2002: Advanced To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Excel 2002 Basic Lesson 1: The Excel 2002 Interface Introduction Lesson Objectives Opening Excel About Workbooks The Title Bar Menu Bar Overview Standard Toolbar Overview Formatting Toolbar Overview Displaying Other Toolbars Repositioning A Toolbar Docking A Toolbar Hiding A Toolbar Overview Of Task Panes Switching Between Task Panes Hiding The Task Pane Showing The Task Pane The Formula Bar The Insert Function  more...

Excel 2002 Intermediate Lesson 1: The Document Window Introduction Lesson Objectives Opening Excel Opening An Existing Workbook Splitting A Worksheet Vertically Splitting A Worksheet Horizontally Removing Splits Freezing Panes Unfreezing Panes The Watch Window Adding A Watch Deleting A Watch Hiding A Column Displaying A Hidden Column Hiding Rows Manually Hiding Rows And Columns Inserting A Column The Insert Options  more...

Excel 2002 Advanced Lesson 1: Sorting & Filtering Data Introduction Lesson Objectives Opening Excel Importing Data From A Web Page The New Web Query Dialog Box Selecting A Table Navigating Pages Web Query Options Saving A Web Query Placing Data The External Data Toolbar Editing A Query Data Range Properties Refreshing Data Running A Saved Query Full Screen View Sorting Data Then By Sorting Using AutoFilter Using  more...

Excel XP Essentials Set of 3 Beginning 1.0 The Excel Screen 1.1 Overview 1.2 Screen Elements 2.0 Entering Data 2.1 Data Entry Techniques 2.2 AutoFill Entry Techniques 2.3 Erasing Data 2.4 AutoComplete 2.5 Undo & Re-do 3.0 Entering Formulas 3.1 Three Methods of Entering Formulas 3.2 Repeating a Formula in Adjacent Cells 3.3 Formulas Beyond Addition & Subtraction 4.0 Basic Excel Functions 4.1 Summation  more...

Office XP Essentials Set of 15 The Office XP Essentials: Set of 15 includes the following: Excel XP Essentials: Set of 3 (ID#8185) Word XP Essentials: Set of 3 (ID#8186) PowerPoint XP Essentials: Set of 3 (ID#8187) Access XP Essentials: Set of 3 (ID#8188) Outlook XP Essentials: Set of 3 (ID#8189) To review individual descriptions, please select the corresponding product ID number under Related Courses below.  more...

SQL Server 2000 Data Warehousing Set of 5 Data Warehousing Level 1 1.0 Introduction 1.1 Topic Overview 1.2 Transactional vs. Analytical Data Systems 1.3 Data Warehouse Defined 1.4 Data Warehouses vs. Data Marts/OLAP 2.0 Dimensional Modeling & Planning 2.1 Entity-Relationship Modeling vs. Dimensional Modeling 2.2 Elements of the Dimensional Model 2.3 The Role of User Requirements 2.4 Identifying Source Data 2.5 Implementing  more...

Excel 2002 Intermediate Lesson 1: The Document Window Introduction Lesson Objectives Opening Excel Opening An Existing Workbook Splitting A Worksheet Vertically Splitting A Worksheet Horizontally Removing Splits Freezing Panes Unfreezing Panes The Watch Window Adding A Watch Deleting A Watch Hiding A Column Displaying A Hidden Column Hiding Rows Manually Hiding Rows And Columns Inserting A Column The  more...

Excel 2000 Intermediate LESSON_STR Excel 2000 Intermediate Lesson 1 : Getting To Know The Worksheet Window, Introduction, Opening Excel, Splitting Your Worksheet Vertically, Splitting Your Worksheet Horizontally, Removing The Split Bars From Your Worksheet, Freezing Panes, Unfreezing Panes, Freezing Multiple Panes, Unfreezing Multiple Panes, Hiding Columns And Rows Using The Format Menu, Hiding Columns  more...

Excel 2002 Basic Lesson 1: The Excel 2002 Interface Introduction Lesson Objectives Opening Excel About Workbooks The Title Bar Menu Bar Overview Standard Toolbar Overview Formatting Toolbar Overview Displaying Other Toolbars Repositioning A Toolbar Docking A Toolbar Hiding A Toolbar Overview Of Task Panes Switching Between Task Panes Hiding The Task Pane Showing The Task Pane The Formula Bar The  more...

Word 2002 Advanced Lesson 1: Building Tables & Charts Introduction Lesson Objectives Opening Word The Task Pane Inserting Headers & Footers Inserting A Picture In A Header Formatting Text In A Header Defining A Style The Style & Formatting Task Pane Switching Between Headers & Footers Inserting Text In A Footer Inserting Page Numbers Inserting A Section Break Creating A Different Header & Footer  more...

Word 2002 Basic Lesson 1: Touring The Word Window Introduction Lesson Objectives Opening Word 2002 The Title Bar Menu Bar Overview Standard Toolbar Overview Formatting Toolbar Overview Displaying Other Toolbars Repositioning A Toolbar Docking A Toolbar Hiding A Toolbar Overview Of Task Panes Switching Between Task Panes Showing & Hiding The Task Pane Horizontal Ruler Overview The Status Bar  more...

Visual Basic 6 0 Power Developer Set of 9 LV 9-17 Level 9 (2 Hours 13 Minutes) 1.0 Package & Deployment Wizard (29 min) 1.1 What is a Setup 1.2 Steps to Distribution 1.3 VB Runtime Files 1.4 Setup Runtime Files 1.5 Types of Setups 1.6 Creating a Package 1.7 Deploying the Package 1.8 Testing the Setup 2.0 Advanced Common Controls (1 Hour 1 min) 2.1 Flex Grid Control 2.2 Hierarchical Flex Grid Control 2.3 Tree View & List View  more...

PowerPoint 2000 Set of 3 PowerPoint 2000 Beginning (1 Hour 29 Minutes) 1.0 Getting a round in PowerPoint (4 Minutes) 1.1 The PowerPoint Screen 2.0 Creating a Presentation (23 Minutes) 2.1 Types of Slides & Work Views 2.2 Creating a Presentation with a template & or Wizard 2.3 Creating a Presentation from Existing Slides 2.4 Deleting Slides in different Views 2.5 Inserting Headers and Footers 2.6 Sending a  more...

Office 2000 Standard Set of 9 The Microsoft Office 2000 Standard Setincludes the following tutorial applications: Word 2000: Beginning (ID#1810) Word 2000: Intermediate (ID# 1815) Word 2000: Advanced (ID# 1818) Excel 2000: Beginning (ID# 1718) Excel 2000: Intermediate (ID#1722) Excel 2000: Advanced (ID#1728) PowerPoint 2000: Beginning (ID#1758) PowerPoint 2000: Intermediate (ID#1762) Outlook 2000: Beginning  more...

Office 2000 Professional Set of 13 The Microsoft Office 2000 Professional Set includes the following application tutorials: Word 2000: Beginning (ID#1810) Word 2000: Intermediate (ID#1815) Word 2000: Advanced (ID# 1818) Excel 2000: Beginning (ID#1718) Excel 2000: Intermediate (ID#1722) Excel 2000: Advanced (ID#1728) Access 2000: Beginning (ID#1686) Access 2000: Intermediate (ID#1697) Access 2000: Advanced (ID#1704)  more...

Excel 2000 User Set of 3 Beginning (2 Hours 16 Minutes) 1.0 The Excel Screen (32 Minutes) 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 (27 Minutes) 2.1 Data Entry Techniques 2.2 Auto-Fill Entry Techniques 2.3 Erasing Data  more...

Word 2000 Tables Forms Word 2000 Tables & Forms (1 Hour 51 Minutes) 1.0 Building Tables (25 Minutes) 1.1 Creating Tables 1.2 Entering Text 1.3 Selecting a Table 1.4 Modifying a Table 2.0 Formatting Tables (21 Minutes) 2.1 AutoFormat & Formatting Tools 2.2 Changing Columns & Rows 2.3 Tables & Borders Toolbar 3.0 More Power with Tables (27 Minutes) 3.1 Calculations 3.2 Sorting 3.3 Inserting Data  more...

Visual Basic 6 0 Automation Programming LV 14 Level 14 Automation Programming (2 Hours 14 Minutes) 1.0 Introduction to Automation Programming (5 min) 1.1 What is Automation 1.2 How to use Automation 1.3 Programming the Server 2.0 Automating Microsoft Excel (26 min) 2.1 Help on Excel 2.2 Excel Object Hierarchy 2.3 Declaring Excel 2.4 Looking at the Code 2.5 Printing and Loading Data from an Access Database 2.6 Building a  more...

Visual Basic 6 0 Component Development LV 11 Level 11 Component Development (2 Hours) 1.0 Introduction to ActiveX Technology (6 min) 1.1 COM 1.2 DCOM 1.3 Compound Documents 1.4 In-Place Activation 1.5 Active X Container 1.6 Active X Server Components 1.7 Active Automation 2.0 Creating ActiveX Components (39 min) 2.1 Types of Components 2.2 Building an Active X DLL 2.3 Compiling the DLL 2.4 Debugging the DLL 2.5  more...

PowerPoint 2000 Advanced PowerPoint 2000 Advanced (1 Hour 30 Minutes) 1.0 Working Visual Elements (3 Minutes) 1.1 Adding Textured Backgrounds 1.2 Applying Diagonal Borders to a Table 2.0 Using Data from other Sources (20 Minutes) 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  more...

Access 2000 User Set of 5 Access 2000 Beginning (2 Hours 6 Minutes) 1.0 Introduction (26 Minutes) 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 (33 Minutes) 2.1 Viewing and Navigating Table Data 2.2 Editing Table Data 2.3 Adding Records to a Table 2.4 Selecting and Deleting  more...

Excel 2000 - Proficient User DiscoverWare's Discover Excel 2000 is an interactive productivity tool for users of Microsoft Excel 2000. Excel 2000 builds on the spreadsheet capabilities of previous versions of the program to provide powerful tools for creating and sharing professional worksheets online and on the Web. Topics include basic spreadsheet concepts, workbook and file management, using formulas and functions,  more...

Access 2000 Application Developer Set of 16 Access 2000 Application Development Level 1 (2 Hours 5 Minutes) 1.0 Access as a Development Tool (37 Minutes) 1.1 Types of Applications You Can Develop 1.2 What Exactly is a Database 1.3 Getting to Know the Database Objects 1.4 Object Naming Conventions 1.5 Hardware Requirements 1.6 Getting Started Developing an Application 2.0 Tables (39 Minutes) 2.1  more...

Access 2000 Application Developer Set of 16 Access 2000 Application Development Level 1 (2 Hours 5 Minutes) 1.0 Access as a Development Tool (37 Minutes) 1.1 Types of Applications You Can Develop 1.2 What Exactly is a Database 1.3 Getting to Know the Database Objects 1.4 Object Naming Conventions 1.5 Hardware Requirements 1.6 Getting Started Developing an Application 2.0 Tables (39 Minutes) 2.1  more...

Access 2000 Application Developer Set of 16 Access 2000 Application Development Level 1 (2 Hours 5 Minutes) 1.0 Access as a Development Tool (37 Minutes) 1.1 Types of Applications You Can Develop 1.2 What Exactly is a Database 1.3 Getting to Know the Database Objects 1.4 Object Naming Conventions 1.5 Hardware Requirements 1.6 Getting Started Developing an Application 2.0 Tables (39 Minutes) 2.1  more...

Access 2000 Advanced Access 2000 Advanced (2 Hours 3 Minutes) 1.0 Building and Modifying Forms (51 Minutes) 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 (26 Minutes) 2.1  more...

Access 2000 Application Developer Set of 16 Access 2000 Application Development Level 1 (2 Hours 5 Minutes) 1.0 Access as a Development Tool (37 Minutes) 1.1 Types of Applications You Can Develop 1.2 What Exactly is a Database 1.3 Getting to Know the Database Objects 1.4 Object Naming Conventions 1.5 Hardware Requirements 1.6 Getting Started Developing an Application 2.0 Tables (39 Minutes) 2.1 Building a New Table 2.2  more...

Access 2000 Application Developer LV 12 Application Development Level 12 (1 Hour 53 Minutes) 1.0 Automation: Communicating with Other Applications (1 Hour 2 Minutes) 1.1 Automation Terms 1.2 Declaring an Object Variable 1.3 Creating an Automation Object 1.4 Manipulating an Automation Object 1.5 Controlling Excel from Access & Closing an Excel Automation Object 1.6 Creating a Graph from Access 1.7 Controlling Word from Access  more...

Excel 2000 Beginning Beginning (2 Hours 16 Minutes) 1.0 The Excel Screen (32 Minutes) 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 (27 Minutes) 2.1 Data Entry Techniques 2.2 Auto-Fill Entry Techniques 2.3 Erasing Data  more...

Excel 2000 Intermediate Intermediate (2 Hours 5 Minutes) 1.0 Changing Worksheet Layout (26 Minutes) 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 (6 Minutes) 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  more...

Excel 2000 Advanced Advanced (2 Hours 2 Minutes) 1.0 Adjusting Worksheet Views (13 Minutes) 1.1 Freeze/Unfreeze Panes 1.2 Horizontal & Vertical Split screen 2.0 Auditing Techniques (12 Minutes) 2.1 Using the Auditing Toolbar 2.2 Tracing Dependant Cells 2.3 Tracing Precedent Cells 3.0 Using Functions (18 Minutes) 3.1 Paste Function 3.2 The PMT Function 3.3 Expanding the use of standard  more...

Office 2000 Professional Set of 13 The Microsoft Office 2000 Professional Set includes the following application tutorials: Word 2000: Beginning (ID#1810) Word 2000: Intermediate (ID#1815) Word 2000: Advanced (ID# 1818) Excel 2000: Beginning (ID#1718) Excel 2000: Intermediate (ID#1722) Excel 2000: Advanced (ID#1728) Access 2000: Beginning (ID#1686) Access 2000: Intermediate (ID#1697) Access 2000: Advanced (ID#1704)  more...

Office XP Professional Suite of 17 The Office XP Deluxe Professional Suite of 17 includes the following: Access 2002: Basic (ID#8933) Access 2002: Intermediate (ID#8932) Access 2002: Advanced(ID#8931) Excel 2002: Basic (ID#8936) Excel 2002: Intermediate (ID#8937) Excel 2002: Advanced (ID#8938) Outlook 2002: Volume 1 and Volume 2 (ID#8939) Powerpoint 2002: Basic (ID#8940) Powerpoint 2002: Intermediate (ID#8941) Powerpoint  more...

Excel 2002 Advanced Lesson 1: Sorting & Filtering Data Introduction Lesson Objectives Opening Excel Importing Data From A Web Page The New Web Query Dialog Box Selecting A Table Navigating Pages Web Query Options Saving A Web Query Placing Data The External Data Toolbar Editing A Query Data Range Properties Refreshing Data Running A Saved Query Full Screen View Sorting Data Then By Sorting Using  more...

Excel 2002 Set of 3 Excel 2002: Set of 3 includes the following: Excel 2002: Basic Excel 2002: Intermediate Excel 2002: Advanced To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Office 2000 Standard Suite The Microsoft Office 2000 Standard Training Suite consists of the following courses: Word 2000: Introduction (ID#6819) Word 2000: Intermediate (ID#6820) Word 2000: Advanced (ID#6821) Excel 2000: Introduction (ID#6822) Excel 2000: Intermediate (ID#6823) Excel 2000: Advanced (ID#6824) PowerPoint 2000: Introduction (ID#6825) PowerPoint 2000: Intermediate (ID#6826) PowerPoint 2000:  more...

Office XP Professional Suite of 14 The Office XP Professional Suite of 14 includes the following: Access 2002: Basic (ID#8933) Access 2002: Intermediate (ID#8932) Access 2002: Advanced(ID#8931) Excel 2002: Basic (ID#8936) Excel 2002: Intermediate (ID#8937) Excel 2002: Advanced (ID#8938) Outlook 2002: Volume 1 and Volume 2 (ID#8939) Powerpoint 2002: Basic (ID#8940) Powerpoint 2002: Intermediate (ID#8941) Powerpoint 2002:  more...

SQL Server 7 0 Data Warehousing Set of 4 SQL 7.0 Data Warehousing Level 1 (1 Hr 41 Mins) 1.0 Prerequisites (28 Mins) 1.1 Course Prerequisites 1.2 System Setup 1.3 Defining Data Warehousing 1.4 Operational & Analytical Systems 1.5 Comparing Transactional and Data Warehousing Solutions 1.6 Data Marts 1.7 Know the Flow 1.8 Microsoft Data Warehouse Tools 1.9 Data Warehouse Characteristics 2.0 Designing a Data Warehouse (1 Hr  more...

SQL Server 7 0 Data Warehousing Level 3 SQL 7.0 Data Warehousing Level 3 (1 Hr 28 Mins) 1.0 Storing & Processing Cubes (32 Mins) 1.1 MOLAP, ROLAP, & HOLAP Storage Structures 1.2 Comparing ROLAP & MOLAP 1.3 Review & Compare Storage Options 1.4 Storing Partitions & Processing Cubes 1.5 Calculated Members 1.6 The Virtual Cube, Cube Security & Roles 2.0 Analyzing Data Using Clients (28 Mins) 2.1 Navigating Warehouse Data &  more...

Office XP Proficient The Office XP Proficient Suite includes the following: Access XP Proficient & Expert (ID#8872) Excel XP Proficient & Expert (ID#8873) Outlook XP Proficient & Expert (ID#8874) PowerPoint XP Comprehensive (ID#8875) Word XP Proficient & Expert (ID#8876) To review individual descriptions, please select the corresponding product ID number under Related Courses below.  more...

Office XP Expert The Office XP Expert Suite includes the following: Access XP Proficient & Expert (ID#8872) Excel XP Proficient & Expert (ID#8873) Outlook XP Proficient & Expert (ID#8874) PowerPoint XP Comprehensive (ID#8875) Word XP Proficient & Expert (ID#8876) To review individual descriptions, please select the corresponding product ID number under Related Courses below.  more...

Access 2000 Expert 1. Access 2000 (Expert) Basics Work With Toolbars The Menu Bar & Other Toolbars Install Add-In Programs What Is An Add-In? Install & Load Add-Ins Unload Add-Ins Work With Previous Versions Of Access Access 2000 & Previous Versions Of Access Access 2000 & Access 97 Access 2000 & Access 95 Convert A Database Set Startup Options Set Startup Options Help In Access 2000 The  more...

Office 2000 5-in-1 - Proficient The Discover Office 2000 (5-in1) – Proficient set includes the following courses: Discover Access 2000 - Proficient (ID#7108) Discover Excel 2000 - Proficient (ID#1389) Discover PowerPoint 2000 - Proficient (ID#1402) Discover Outlook 2000 - Proficient (ID#7111) Discover Word 2000 - Proficient (ID#1410) To review individual course descriptions, please select the corresponding  more...

Excel XP Proficient Expert ...P a is an interactive productivity tool for users of Microsoft Excel XP. Excel XP builds on the spreadsheet capabilities of previous versions of the program to provide powerful tools for creating and sharing professional worksheets online and on the Web. Topics cover basic spreadsheet concepts, workbook and file management, using formulas and functions, editing and formatting tools,  more...

PowerPoint XP Comprehensive DiscoverWare's Discover PowerPoint XP is an interactive productivity tool for users of Microsoft PowerPoint XP. PowerPoint XP builds on the presentation features of previous versions of the program to provide powerful tools for creating and sharing professional documents online and on the Web. Topics cover PowerPoint basics, creating presentations, working with slides, working with text, graphics,  more...