Microsoft Excel Training on CD-ROM - Training Resources

Word 2002 Basic ...les And Borders 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 Size  more...

Excel 2000 - Proficient User ...cel 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 tools,  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...

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...

Word 2000 Introduction ...s And Borders 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,  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...

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...

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 Basic ...s And Borders 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  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...

Visual Basic 6 0 Automation Programming LV 14 ... 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 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 Mail  more...

Excel 2000 - Proficient User ...cel 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 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...

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...

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...