Worksheet 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
... 7.1 Using the Help System Intermediate 1.0 Changing Worksheet Layout 1.1 Inserting Columns, Rows, & Cells 1.2 Deleting Columns, Rows, & Cells 1.3 Moving Cells 1.4 Copying Cells 2.0 Additional Formatting 2.1 Formatting Cell Attributes & Alignment 2.2 Borders 2.3 Numeric Formatting 2.4 Centering Text Across Columns 2.5 Hiding & Unhiding Columns & Rows 3.0 Printing 3.1 Using
more...
... 7.1 Using the Help System Intermediate 1.0 Changing Worksheet Layout 1.1 Inserting Columns, Rows, & Cells 1.2 Deleting Columns, Rows, & Cells 1.3 Moving Cells 1.4 Copying Cells 2.0 Additional Formatting 2.1 Formatting Cell Attributes & Alignment 2.2 Borders 2.3 Numeric Formatting 2.4 Centering Text Across Columns 2.5 Hiding & Unhiding Columns & Rows 3.0 Printing 3.1 Using
more...
Excel 2002 Intermediate
... 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 Button Deleting A Column Inserting Multiple
more...
... 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 Button Deleting A Column Inserting Multiple
more...
Excel 2000 Intermediate
... 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...
... 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 2002 Basic
...ormula Bar The Insert Function Button The Name Box The Worksheet Area Column Headings Row Headings The Select All Button The Vertical Scroll Bar The Horizontal Scroll Bar Sheet Tabs Inserting A Worksheet The Insert Dialog Box Renaming A Worksheet Changing Sheet Tab Order Deleting A Worksheet The Tab Scrolling Buttons The Status Bar Overview Of Menus The File Menu The Edit
more...
...ormula Bar The Insert Function Button The Name Box The Worksheet Area Column Headings Row Headings The Select All Button The Vertical Scroll Bar The Horizontal Scroll Bar Sheet Tabs Inserting A Worksheet The Insert Dialog Box Renaming A Worksheet Changing Sheet Tab Order Deleting A Worksheet The Tab Scrolling Buttons The Status Bar Overview Of Menus The File Menu The Edit
more...
Word 2002 Basic
...tton 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...
...tton 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 User Set of 3
...he 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 Entering
more...
...he 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 Entering
more...
Excel 2000 Beginning
...he 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 Entering
more...
...he 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 Entering
more...
Excel 2000 Intermediate
...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)
3.1 Using Print Preview and
more...
...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)
3.1 Using Print Preview and
more...
Excel 2000 Advanced
...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 (30 Minutes)
more...
...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 (30 Minutes)
more...
Excel 2002 Advanced
...nlocking Cells Hiding Proprietary Formulas Protecting A Worksheet Selecting Permissions Verifying Protection Unprotecting A Sheet Hiding Cell Contents Displaying The Contents Of Hidden Cells Password Protecting A Sheet Removing Password Protection Protecting A Workbook Controlling Access To A Workbook The Scenario Manager Creating Scenarios Viewing Scenarios Creating A Scenario
more...
...nlocking Cells Hiding Proprietary Formulas Protecting A Worksheet Selecting Permissions Verifying Protection Unprotecting A Sheet Hiding Cell Contents Displaying The Contents Of Hidden Cells Password Protecting A Sheet Removing Password Protection Protecting A Workbook Controlling Access To A Workbook The Scenario Manager Creating Scenarios Viewing Scenarios Creating A Scenario
more...
Excel XP Proficient Expert
...vide 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, working with graphics and charts, online collaboration, and working on the Web. Excel XP/ 2002 (Proficient) Excel XP Basics Introducing Excel XP - Excel XP
more...
...vide 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, working with graphics and charts, online collaboration, and working on the Web. Excel XP/ 2002 (Proficient) Excel XP Basics Introducing Excel XP - Excel XP
more...
