Excel Training on CD-ROM
Excel Training Provider? - Tell us about your Training!
 online course |
 instructor-led class |
 learn at home |
 group study |
 self-directed study |
 cd-based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer-based learning |
 discount pricing |
 online tutorial |
From 123-CBT Computer Based Training
Access 2000 Application Developer Set of 16
... 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
1.8 Controlling PowerPoint from Access
1.9 Controlling Access from Other Applications
2.0 Exploiting the Power of the Windows API (50 Minutes)
2.1 Declaring an External Function to the
more...
Access 2000 Application Developer Set of 16
... 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
1.8 Controlling PowerPoint from Access
1.9 Controlling Access from Other Applications
2.0 Exploiting the Power of the Windows API (50 Minutes)
2.1 Declaring an External Function to the
more...
Access 2000 Application Developer Set of 16
... 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
1.8 Controlling PowerPoint from Access
1.9 Controlling Access from Other Applications
2.0 Exploiting the Power of the Windows API (50 Minutes)
2.1 Declaring an External Function to the
more...
... 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
1.8 Controlling PowerPoint from Access
1.9 Controlling Access from Other Applications
2.0 Exploiting the Power of the Windows API (50 Minutes)
2.1 Declaring an External Function to the
more...
Access 2000 Application Developer Set of 16
... 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
1.8 Controlling PowerPoint from Access
1.9 Controlling Access from Other Applications
2.0 Exploiting the Power of the Windows API (50 Minutes)
2.1 Declaring an External Function to the
more...
... 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
1.8 Controlling PowerPoint from Access
1.9 Controlling Access from Other Applications
2.0 Exploiting the Power of the Windows API (50 Minutes)
2.1 Declaring an External Function to the
more...
Excel 2000 Intermediate
...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
more...
...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
more...
Excel 2000 - Proficient User
...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 and formatting
more...
...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 and formatting
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
more...
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
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 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
...
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
1.8 Controlling PowerPoint from Access
1.9 Controlling Access from Other Applications
2.0 Exploiting the Power of the Windows API (50 Minutes)
2.1 Declaring an External Function to the Compiler
2.2
more...
...
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
1.8 Controlling PowerPoint from Access
1.9 Controlling Access from Other Applications
2.0 Exploiting the Power of the Windows API (50 Minutes)
2.1 Declaring an External Function to the Compiler
2.2
more...
Access 2000 Application Developer LV 12
...
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
1.8 Controlling PowerPoint from Access
1.9 Controlling Access from Other Applications
2.0 Exploiting the Power of the Windows API (50 Minutes)
2.1 Declaring an External Function to the Compiler
2.2
more...
...
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
1.8 Controlling PowerPoint from Access
1.9 Controlling Access from Other Applications
2.0 Exploiting the Power of the Windows API (50 Minutes)
2.1 Declaring an External Function to the Compiler
2.2
more...
Excel 2000 Beginning
...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
3.0
more...
...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
3.0
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
more...
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
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
more...
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
more...
PowerPoint 2000 Advanced
...om 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)
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 35 mm Slides
4.0 Delivering a Presentation (4 Minutes)
4.1 Save Presentation for use on another computer ( Pack N' Go )
more...
...om 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)
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 35 mm Slides
4.0 Delivering a Presentation (4 Minutes)
4.1 Save Presentation for use on another computer ( Pack N' Go )
more...
Excel 2000 User Set of 3
...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
3.0
more...
...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
3.0
more...
Office 2000 Professional Set of 13
...: 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) PowerPoint 2000: Beginning (ID#1758) PowerPoint 2000: Intermediate (ID#1762) PowerPoint 2000: Advanced (ID#1766) Outlook 2000:
more...
...: 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) PowerPoint 2000: Beginning (ID#1758) PowerPoint 2000: Intermediate (ID#1762) PowerPoint 2000: Advanced (ID#1766) Outlook 2000:
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...
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...
PowerPoint 2000 Set of 3
...om 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)
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 35 mm Slides
4.0 Delivering a Presentation (4 Minutes)
4.1 Save Presentation for use on another computer ( Pack N' Go )
more...
...om 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)
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 35 mm Slides
4.0 Delivering a Presentation (4 Minutes)
4.1 Save Presentation for use on another computer ( Pack N' Go )
more...
Visual Basic 6 0 Power Developer Set of 9 LV 9-17
... 2.7 Creating an Active X EXE 2.8 Running the DLL from Excel 2.9 Differences between an Active X DLL & EXEs 3.0 Active X Components (18 min) 3.1 Registering 3.2 Versioning 3.3 Error Handling 4.0 Call-Backs and Events (22 min) 4.1 What is a Call Back 4.2 The Server Side 4.3 The Client Side 4.4 Disconnecting 4.5 Raising Events 5.0 Threads and Instancing (21 min) 5.1 Threads
more...
... 2.7 Creating an Active X EXE 2.8 Running the DLL from Excel 2.9 Differences between an Active X DLL & EXEs 3.0 Active X Components (18 min) 3.1 Registering 3.2 Versioning 3.3 Error Handling 4.0 Call-Backs and Events (22 min) 4.1 What is a Call Back 4.2 The Server Side 4.3 The Client Side 4.4 Disconnecting 4.5 Raising Events 5.0 Threads and Instancing (21 min) 5.1 Threads
more...
Word 2002 Basic
...ers Button The Insert Table Button The Insert Microsoft Excel Worksheet Button The Columns Button The Drawing Button The Zoom List Box The Office Assistant Button The Toolbar Options Button The Document Map Button The Show/Hide Button Using The Mouse To Select Text The Styles And Formatting Button The Styles And Formatting Task Pane The Style List Box The Font List Box The Font
more...
...ers Button The Insert Table Button The Insert Microsoft Excel Worksheet Button The Columns Button The Drawing Button The Zoom List Box The Office Assistant Button The Toolbar Options Button The Document Map Button The Show/Hide Button Using The Mouse To Select Text The Styles And Formatting Button The Styles And Formatting Task Pane The Style List Box The Font List Box The Font
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...
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...
Office XP Professional Suite of 17
...: 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 (ID#8942) Windows XP: Basic (ID#8945) Windows XP: Networking & Internetworking (ID#8946)
more...
...: 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 (ID#8942) Windows XP: Basic (ID#8945) Windows XP: Networking & Internetworking (ID#8946)
more...
Excel 2002 Advanced
... 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...
... 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 2002 Basic
...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
more...
...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
more...
Excel 2002 Intermediate
...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
more...
...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
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: 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
...0: 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) Outlook 2000 Volumes I & II (ID#6831) To review individual course descriptions, please select the corresponding
more...
...0: 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) Outlook 2000 Volumes I & II (ID#6831) To review individual course descriptions, please select the corresponding
more...
Office XP Professional Suite of 14
...: 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 (ID#8942) Word 2002: Basic(ID#8949) Word 2002: Intermediate(ID#8950) Word 2002:
more...
...: 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 (ID#8942) Word 2002: Basic(ID#8949) Word 2002: Intermediate(ID#8950) Word 2002:
more...
SQL Server 7 0 Data Warehousing Set of 4
...e Data & Data Mining 2.2 Local Cubes 2.3 OLAP Manager & Excel 2000 2.4 Publishing to the Web 2.5 Creating Local Cubes with Excel 2000 3.0 MDX Statements (27 Mins) 3.1 What is MDX? 3.2 The MDX SELECT Statement 3.3 Axes 3.4 Sets 3.5 Functions 3.6 Additional Set Functions 3.7 Tuples 3.8 Slicer Dimensions 3.9 Calculated Members SQL 7.0 Data Warehousing Level 4 (1 Hr 32
more...
...e Data & Data Mining 2.2 Local Cubes 2.3 OLAP Manager & Excel 2000 2.4 Publishing to the Web 2.5 Creating Local Cubes with Excel 2000 3.0 MDX Statements (27 Mins) 3.1 What is MDX? 3.2 The MDX SELECT Statement 3.3 Axes 3.4 Sets 3.5 Functions 3.6 Additional Set Functions 3.7 Tuples 3.8 Slicer Dimensions 3.9 Calculated Members SQL 7.0 Data Warehousing Level 4 (1 Hr 32
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...
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...
SQL Server 2000 Data Warehousing Set of 5
... OLE DB 4.1 Analysis Application Architecture 4.2 Using Excel as an Analysis Server Client 4.3 Overview of Client Interfaces 5.0 Introduction to Data Mining 5.1 Data Mining Basics 5.2 Creating Data Mining Models Data Warehousing Level 5 1.0 MDX Concepts Overview 1.1 What is MDX? 1.2 Role of MDX in Application Architecture 1.3 Creating Calculated Members Within Cubes 1.4 Using
more...
... OLE DB 4.1 Analysis Application Architecture 4.2 Using Excel as an Analysis Server Client 4.3 Overview of Client Interfaces 5.0 Introduction to Data Mining 5.1 Data Mining Basics 5.2 Creating Data Mining Models Data Warehousing Level 5 1.0 MDX Concepts Overview 1.1 What is MDX? 1.2 Role of MDX in Application Architecture 1.3 Creating Calculated Members Within Cubes 1.4 Using
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...
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...
Excel XP Essentials Set of 3
...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 4.2 Recalculating
more...
...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 4.2 Recalculating
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...
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...
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...
Visual Basic 6 0 Component Development LV 11
...
2.7 Creating an Active X EXE
2.8 Running the DLL from Excel
2.9 Differences between an Active X DLL & EXEs
3.0 Active X Components (18
min)
3.1 Registering
3.2 Versioning
3.3 Error Handling
4.0 Call-Backs and Events (22
min)
4.1 What is a Call Back
4.2 The Server Side
4.3 The Client Side
4.4 Disconnecting
4.5 Raising Events
5.0 Threads and Instancing (21
more...
...
2.7 Creating an Active X EXE
2.8 Running the DLL from Excel
2.9 Differences between an Active X DLL & EXEs
3.0 Active X Components (18
min)
3.1 Registering
3.2 Versioning
3.3 Error Handling
4.0 Call-Backs and Events (22
min)
4.1 What is a Call Back
4.2 The Server Side
4.3 The Client Side
4.4 Disconnecting
4.5 Raising Events
5.0 Threads and Instancing (21
more...
Visual Basic 6 0 Automation Programming LV 14
...
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 Graph
2.7 Shutting down your VB Application
2.8 Hidden Instances of Excel
3.0 Automating Microsoft Word (28
min)
3.1 Building your own
more...
...
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 Graph
2.7 Shutting down your VB Application
2.8 Hidden Instances of Excel
3.0 Automating Microsoft Word (28
min)
3.1 Building your own
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
more...
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
more...
Office 2000 Professional Set of 13
...: 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) PowerPoint 2000: Beginning (ID#1758) PowerPoint 2000: Intermediate (ID#1762) PowerPoint 2000: Advanced (ID#1766) Outlook 2000:
more...
...: 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) PowerPoint 2000: Beginning (ID#1758) PowerPoint 2000: Intermediate (ID#1762) PowerPoint 2000: Advanced (ID#1766) Outlook 2000:
more...
Access 2000 Expert
...roperties For Relationships Data Integration Export To Excel Drag and Drop To Excel Use A Chart Link To Existing Data 5. Work with Reports Create A Report Create A Report In Design View Add A Calculated Control To A Report Modify A Report Set Section Properties Add A Graphic To A Report Modify Control Properties Modify Report Properties Use Subreports What Is A
more...
...roperties For Relationships Data Integration Export To Excel Drag and Drop To Excel Use A Chart Link To Existing Data 5. Work with Reports Create A Report Create A Report In Design View Add A Calculated Control To A Report Modify A Report Set Section Properties Add A Graphic To A Report Modify Control Properties Modify Report Properties Use Subreports What Is A
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...
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
...Excel XP 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...
...Excel XP 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
... - About Charts & Tables - Create A Chart - Insert An Excel Chart - Create A Table - Insert A Word Table Enhance Your Presentations - Create Slide Transitions - About Animation Schemes - Apply An Animation Scheme - Add Sound Or Video - Create A Hyperlink Final Preparations Prepare Support Materials - Prepare Speaker Notes - Prepare Handouts - Print A Presentation
more...
... - About Charts & Tables - Create A Chart - Insert An Excel Chart - Create A Table - Insert A Word Table Enhance Your Presentations - Create Slide Transitions - About Animation Schemes - Apply An Animation Scheme - Add Sound Or Video - Create A Hyperlink Final Preparations Prepare Support Materials - Prepare Speaker Notes - Prepare Handouts - Print A Presentation
more...
Access 2000 Advanced
...New Table, Switching To Datasheet View, Copying Data From Excel For Use In A Table, The Insert Object Command, The Insert Object Dialog Box, Linking An Object, Viewing Objects, Verifying A Link, Importing Into Microsoft Access, The Import Dialog Box, The Import Spreadsheet Wizard, Viewing Imported Data, Linking Tables In Microsoft Access, The Link Spreadsheet Wizard, Properties Of Linked
more...
...New Table, Switching To Datasheet View, Copying Data From Excel For Use In A Table, The Insert Object Command, The Insert Object Dialog Box, Linking An Object, Viewing Objects, Verifying A Link, Importing Into Microsoft Access, The Import Dialog Box, The Import Spreadsheet Wizard, Viewing Imported Data, Linking Tables In Microsoft Access, The Link Spreadsheet Wizard, Properties Of Linked
more...
Word 2000 Introduction
...ers Button, The Insert Table Button, The Insert Microsoft Excel Worksheet Button, The Columns Button, The Drawing Button., The Document Map Button., The Show/Hide Button, The Zoom List Box, The Office Assistant Button, The Formatting Toolbar, The Style List Box, The Font List Box, The Font Size List Box, The Bold Button, The Italics Button, The Underline Button, Using Multiple Undo, Selecting
more...
...ers Button, The Insert Table Button, The Insert Microsoft Excel Worksheet Button, The Columns Button, The Drawing Button., The Document Map Button., The Show/Hide Button, The Zoom List Box, The Office Assistant Button, The Formatting Toolbar, The Style List Box, The Font List Box, The Font Size List Box, The Bold Button, The Italics Button, The Underline Button, Using Multiple Undo, Selecting
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 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
...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 Mouse,
more...
...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 Mouse,
more...
Excel 2000 Advanced
...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, Advanced Filter
more...
...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, Advanced Filter
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...
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
...000: 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) Outlook 2000 Volumes I & II (ID#6831) To review individual course descriptions, please select the corresponding product
more...
...000: 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) Outlook 2000 Volumes I & II (ID#6831) To review individual course descriptions, please select the corresponding product
more...
Office 2000 Professional Suite
...000: 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) Access 2000: Introduction (ID#6828) Access 2000: Intermediate (ID#6829) Access 2000: Advanced (ID#6830) Outlook 2000:
more...
...000: 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) Access 2000: Introduction (ID#6828) Access 2000: Intermediate (ID#6829) Access 2000: Advanced (ID#6830) Outlook 2000:
more...
From Business Industrial Network
ViewTrainer - RSView HMI Training Software
...rainer ) includes RSLinx communications, DDE topics
and excel, creating a new RSView project, rsview graphics, interactive quiz,
laboratory manual and much more. This distant learning course
can serve as a precursor to taking on those control engineering projects.
Data logging is a valuable tool for Predictive Maintenance and activity
logs help to prepare for Preventive and Predictive
more...
...rainer ) includes RSLinx communications, DDE topics
and excel, creating a new RSView project, rsview graphics, interactive quiz,
laboratory manual and much more. This distant learning course
can serve as a precursor to taking on those control engineering projects.
Data logging is a valuable tool for Predictive Maintenance and activity
logs help to prepare for Preventive and Predictive
more...
From Easy Software Products
Learn how to use Excel 2007 for Windows
...ul tool for analyzing, sharing, and managing information, Excel 2007 delivers a new results-oriented interface that makes powerful productivity tools easily accessible. Improve your spreadsheets with new data analysis and visualization tools that help you analyze information, spot trends, and access your company information more easily. Create professional-looking charts with dramatic visual
more...
...ul tool for analyzing, sharing, and managing information, Excel 2007 delivers a new results-oriented interface that makes powerful productivity tools easily accessible. Improve your spreadsheets with new data analysis and visualization tools that help you analyze information, spot trends, and access your company information more easily. Create professional-looking charts with dramatic visual
more...
Learn how to use Excel 2004 for MAC
A powerful and flexible spreadsheet program designed specifically for Mac OS X, Excel 2004 makes it easier than ever to analyze, report, and share your data. The new tools in this version give you more control over your spreadsheets, and the enhanced charting tools give you more dynamic ways to display your information. Instruction by Robert Thell.
more...
A powerful and flexible spreadsheet program designed specifically for Mac OS X, Excel 2004 makes it easier than ever to analyze, report, and share your data. The new tools in this version give you more control over your spreadsheets, and the enhanced charting tools give you more dynamic ways to display your information. Instruction by Robert Thell.
more...
Learn how to use Excel 2008 for Mac
See your data in a whole new way with Excel 2008 for Mac. Wea ll show you how to analyze, share, and manage your data. Learn how to create larger spreadsheets and take advantage of new charting and formula tools. Learn how to build visually persuasive charts and thought-provoking graphs for powerful results. Our skilled veteran trainer Robert Thell provides the instruction on this series.
more...
See your data in a whole new way with Excel 2008 for Mac. Wea ll show you how to analyze, share, and manage your data. Learn how to create larger spreadsheets and take advantage of new charting and formula tools. Learn how to build visually persuasive charts and thought-provoking graphs for powerful results. Our skilled veteran trainer Robert Thell provides the instruction on this series.
more...
From TEDCF Publishing
SolidWorks Advanced Parts Assemblies
SolidWorks: Advanced Parts & Assemblies is a progressive, multimedia training tool that gives you a strong foundation of skills and teaches you how to use them to create bullet-proof models and assemblies.
This computer-based tutorial offers successful hands-on training in audio/ video form. You can learn at your own pace as you interact with demonstrations. After the course is complete, the
more...
Autodesk Inventor Certified Solid Modeling
Autodesk Inventor Certified: Solid Modeling is a progressive, multimedia training tool that gives you a strong foundation of skills along with knowledge of the commands.
This computer-based tutorial offers successful hands-on training in audio/ video form. Unlike other types of training, the user can learn at their own pace as they interact with demonstrations. After the course is complete,
more...
online course |
instructor-led class |
learn at home |
group study |
self-directed study |
cd-based training |
DVD video training |
printed book |
e-book digital book |
workshop seminar |
train the trainer |
computer-based learning |
discount pricing |
online tutorial |
