Workbooks Training on CD-ROM
 online course |
 instructor led class |
 learn at home |
 group study |
 self directed training |
 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
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...
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
...e & Style Settings Clearing An Outline Opening Multiple Workbooks Simultaneously Tiling Workbooks Adding A Comment Hiding A Comment Using AutoSum Inserting Multiple Sheets Rearranging Sheet Tabs Copying Data To Multiple Worksheets Entering Data On Multiple Sheets Hyperlinking To Files Specifying An Exact Location Verifying A Link Hyperlinking To A Web Address Adding A ScreenTip
more...
...e & Style Settings Clearing An Outline Opening Multiple Workbooks Simultaneously Tiling Workbooks Adding A Comment Hiding A Comment Using AutoSum Inserting Multiple Sheets Rearranging Sheet Tabs Copying Data To Multiple Worksheets Entering Data On Multiple Sheets Hyperlinking To Files Specifying An Exact Location Verifying A Link Hyperlinking To A Web Address Adding A ScreenTip
more...
Excel 2002 Basic
...ce 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 Button The
more...
...ce 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 Button The
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...
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 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...
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
...ring A Workbook Personal View & Print Settings Of Shared Workbooks Removing Protection From A Shared Workbook Removing Password Protection Lesson 5: Variable Data & Problem Solving Introduction Lesson Objectives Data Tables One Variable Data Tables Specifying Input Cells Identifying A Reference Cell Two Variable Data Tables Adding Formulas To A Two Variable Data Table Identifying
more...
...ring A Workbook Personal View & Print Settings Of Shared Workbooks Removing Protection From A Shared Workbook Removing Password Protection Lesson 5: Variable Data & Problem Solving Introduction Lesson Objectives Data Tables One Variable Data Tables Specifying Input Cells Identifying A Reference Cell Two Variable Data Tables Adding Formulas To A Two Variable Data Table Identifying
more...
Excel XP Proficient Expert
...g - Split A Worksheet - Freeze Rows & Columns Print Workbooks - Print Worksheets & Workbooks - Modify Page Setup - Set Print Area Help In Excel XP - Ask A Question - Microsoft Excel Help Work With Cells Cell Basics - What Is a Cell Reference? - Select Cells Enter Data - Entering Data - What Is A Value? - What Is A Label? Edit Data - Edit Worksheet Data -
more...
...g - Split A Worksheet - Freeze Rows & Columns Print Workbooks - Print Worksheets & Workbooks - Modify Page Setup - Set Print Area Help In Excel XP - Ask A Question - Microsoft Excel Help Work With Cells Cell Basics - What Is a Cell Reference? - Select Cells Enter Data - Entering Data - What Is A Value? - What Is A Label? Edit Data - Edit Worksheet Data -
more...
