Cell References Training on CD-ROM - Training Resources
Cell References 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
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 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 User Set of 3
... Printing Controls 3.3 Using Page Break Preview 4.0 Using Cell References (29 Minutes) 4.1 Absolute References 4.2 Mixed References 5.0 Tools Options Command (18 Minutes) 5.1 Show/Hide Gridlines 5.2 Show/Hide Formulas 5.3 Recently used Files List 5.4 Sheets in New Workbook 5.5 Default Settings Advanced (2 Hours 2 Minutes) 1.0 Adjusting Worksheet Views (13 Minutes) 1.1 Freeze/Unfreeze Panes 1.2
more...
... Printing Controls 3.3 Using Page Break Preview 4.0 Using Cell References (29 Minutes) 4.1 Absolute References 4.2 Mixed References 5.0 Tools Options Command (18 Minutes) 5.1 Show/Hide Gridlines 5.2 Show/Hide Formulas 5.3 Recently used Files List 5.4 Sheets in New Workbook 5.5 Default Settings Advanced (2 Hours 2 Minutes) 1.0 Adjusting Worksheet Views (13 Minutes) 1.1 Freeze/Unfreeze Panes 1.2
more...
Excel 2000 Introduction
...electing Multiple Cells With The Name Box, Using Absolute Cell References, The If Function, Reviewing Results, Saving Changes, Review Lesson 3: Inserting Objects And Formatting Cells, Introduction, Opening Excel, Open Options, Changing The Zoom Percentage, The ClipArt Gallery, Selecting A ClipArt Category, Searching For ClipArt, Moving ClipArt Objects, Sizing A ClipArt Object, Ungrouping
more...
...electing Multiple Cells With The Name Box, Using Absolute Cell References, The If Function, Reviewing Results, Saving Changes, Review Lesson 3: Inserting Objects And Formatting Cells, Introduction, Opening Excel, Open Options, Changing The Zoom Percentage, The ClipArt Gallery, Selecting A ClipArt Category, Searching For ClipArt, Moving ClipArt Objects, Sizing A ClipArt Object, Ungrouping
more...
Excel 2000 Intermediate
...Absolute Values, Copying Cell Formulas, Removing Absolute Cell References, Creating An IF Statement, Copying An IF Statement, More On AutoSum, Using Goal Seek, Naming A Group Of Cells, Using VLOOKUP, Copying A Formula Into A Block Of Cells, Applying The TREND Function, Review Lesson 5: More Customizing Options, Introduction, Opening Multiple Documents Simultaneously, Viewing Two Documents At
more...
...Absolute Values, Copying Cell Formulas, Removing Absolute Cell References, Creating An IF Statement, Copying An IF Statement, More On AutoSum, Using Goal Seek, Naming A Group Of Cells, Using VLOOKUP, Copying A Formula Into A Block Of Cells, Applying The TREND Function, Review Lesson 5: More Customizing Options, Introduction, Opening Multiple Documents Simultaneously, Viewing Two Documents At
more...
Excel 2000 Advanced
..., Finding Formulas That Refer To A Specific Cell, Finding Cell References, Working With Conditional Formatting, Using Data Validation, Checking And Reviewing Data, Advanced Filter, AutoFilter, Custom AutoFilter, Removing Filters, Using Multi Level Sorts, Creating A PivotTable Report, Modifying A Pivot Table Report, Making A PivotTable Report Available On The Web, Creating A Data MapRunning A
more...
..., Finding Formulas That Refer To A Specific Cell, Finding Cell References, Working With Conditional Formatting, Using Data Validation, Checking And Reviewing Data, Advanced Filter, AutoFilter, Custom AutoFilter, Removing Filters, Using Multi Level Sorts, Creating A PivotTable Report, Modifying A Pivot Table Report, Making A PivotTable Report Available On The Web, Creating A Data MapRunning A
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...
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
...ying Function Arguments Redefining A Named Range Absolute Cell References The Median Function Using A Named Range As An Argument Manually Entering A Function Argument Tooltips Viewing Formula & Results The Formula Auditing Toolbar Additional Help On Functions Formatting A Range Of Cells Creating A Pie Chart Specifying A Data Range Entering Titles Positioning The Legend Selecting Data Labels
more...
...ying Function Arguments Redefining A Named Range Absolute Cell References The Median Function Using A Named Range As An Argument Manually Entering A Function Argument Tooltips Viewing Formula & Results The Formula Auditing Toolbar Additional Help On Functions Formatting A Range Of Cells Creating A Pie Chart Specifying A Data Range Entering Titles Positioning The Legend Selecting Data Labels
more...
Excel 2002 Advanced
...ions & Data Analysis Introduction Lesson Objectives About Cell References Tracing Precedents Tracing Dependents Finding Errors Getting Help With Errors Viewing Calculation Steps Error Checking Options Correcting An Error Removing Trace Arrows Conditional Formatting Adding A Second Condition Using Data Validation Specifying Settings Creating An Input Message Error Alerts Verifying Validation
more...
...ions & Data Analysis Introduction Lesson Objectives About Cell References Tracing Precedents Tracing Dependents Finding Errors Getting Help With Errors Viewing Calculation Steps Error Checking Options Correcting An Error Removing Trace Arrows Conditional Formatting Adding A Second Condition Using Data Validation Specifying Settings Creating An Input Message Error Alerts Verifying Validation
more...
Excel XP Essentials Set of 3
...ting Controls 3.3 Using Page Break & Preview 4.0 Using Cell References 4.1 Absolute References 4.2 Mixed References 5.0 The Tools Options Command 5.1 Show/Hide Gridlines & Formulas 5.2 Recently Used File List 5.3 Sheets in New Workbook 5.4 Default Settings Advanced 1.0 Adjusting Worksheet Views 1.1 Freeze/Unfreeze Panes 1.2 Horizontal & Vertical Split Screens 2.0 Auditing
more...
...ting Controls 3.3 Using Page Break & Preview 4.0 Using Cell References 4.1 Absolute References 4.2 Mixed References 5.0 The Tools Options Command 5.1 Show/Hide Gridlines & Formulas 5.2 Recently Used File List 5.3 Sheets in New Workbook 5.4 Default Settings Advanced 1.0 Adjusting Worksheet Views 1.1 Freeze/Unfreeze Panes 1.2 Horizontal & Vertical Split Screens 2.0 Auditing
more...
Excel 2002 Intermediate
...ng Function Arguments Redefining A Named Range Absolute Cell References The Median Function Using A Named Range As An Argument Manually Entering A Function Argument Tooltips Viewing Formula & Results The Formula Auditing Toolbar Additional Help On Functions Formatting A Range Of Cells Creating A Pie Chart Specifying A Data Range Entering Titles Positioning The Legend Selecting
more...
...ng Function Arguments Redefining A Named Range Absolute Cell References The Median Function Using A Named Range As An Argument Manually Entering A Function Argument Tooltips Viewing Formula & Results The Formula Auditing Toolbar Additional Help On Functions Formatting A Range Of Cells Creating A Pie Chart Specifying A Data Range Entering Titles Positioning The Legend Selecting
more...
Excel 2000 Intermediate
...Absolute Values, Copying Cell Formulas, Removing Absolute Cell References, Creating An IF Statement, Copying An IF Statement, More On AutoSum, Using Goal Seek, Naming A Group Of Cells, Using VLOOKUP, Copying A Formula Into A Block Of Cells, Applying The TREND Function, Review
Lesson 5 : More Customizing Options, Introduction, Opening Multiple Documents Simultaneously, Viewing Two
more...
...Absolute Values, Copying Cell Formulas, Removing Absolute Cell References, Creating An IF Statement, Copying An IF Statement, More On AutoSum, Using Goal Seek, Naming A Group Of Cells, Using VLOOKUP, Copying A Formula Into A Block Of Cells, Applying The TREND Function, Review
Lesson 5 : More Customizing Options, Introduction, Opening Multiple Documents Simultaneously, Viewing Two
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...
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...
Excel 2000 User Set of 3
...inting Controls
3.3 Using Page Break Preview
4.0 Using Cell References (29 Minutes)
4.1 Absolute References
4.2 Mixed References
5.0 Tools Options Command (18 Minutes)
5.1 Show/Hide Gridlines
5.2 Show/Hide Formulas
5.3 Recently used Files List
5.4 Sheets in New Workbook
5.5 Default Settings
Advanced (2 Hours 2 Minutes)
1.0 Adjusting Worksheet Views (13 Minutes)
1.1
more...
...inting Controls
3.3 Using Page Break Preview
4.0 Using Cell References (29 Minutes)
4.1 Absolute References
4.2 Mixed References
5.0 Tools Options Command (18 Minutes)
5.1 Show/Hide Gridlines
5.2 Show/Hide Formulas
5.3 Recently used Files List
5.4 Sheets in New Workbook
5.5 Default Settings
Advanced (2 Hours 2 Minutes)
1.0 Adjusting Worksheet Views (13 Minutes)
1.1
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...
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 2002 Advanced
...s & Data Analysis Introduction Lesson Objectives About Cell References Tracing Precedents Tracing Dependents Finding Errors Getting Help With Errors Viewing Calculation Steps Error Checking Options Correcting An Error Removing Trace Arrows Conditional Formatting Adding A Second Condition Using Data Validation Specifying Settings Creating An Input Message Error Alerts Verifying
more...
...s & Data Analysis Introduction Lesson Objectives About Cell References Tracing Precedents Tracing Dependents Finding Errors Getting Help With Errors Viewing Calculation Steps Error Checking Options Correcting An Error Removing Trace Arrows Conditional Formatting Adding A Second Condition Using Data Validation Specifying Settings Creating An Input Message Error Alerts Verifying
more...
Excel XP Proficient Expert
...ormula Syntax? - Create A Formula - Edit A Formula Cell References - Types Of Cell References - Use Relative References - Use Absolute References - Mixed References Functions - What Is A Function? - Get Help With Functions - Enter A Function - Use A Date Function - Financial Functions - Use A Financial Function - Logical Functions - Use A Logical Function
more...
...ormula Syntax? - Create A Formula - Edit A Formula Cell References - Types Of Cell References - Use Relative References - Use Absolute References - Mixed References Functions - What Is A Function? - Get Help With Functions - Enter A Function - Use A Date Function - Financial Functions - Use A Financial Function - Logical Functions - Use A Logical Function
more...
