Formulas 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
...g 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 Effects & Hierarchy of Operations 4.3 Other Functions 5.0 Formatting 5.1 The Formatting Toolbar 5.2 Adjusting Widths & Row Heights
more...
...g 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 Effects & Hierarchy of Operations 4.3 Other Functions 5.0 Formatting 5.1 The Formatting Toolbar 5.2 Adjusting Widths & Row Heights
more...
Excel 2002 Intermediate
...eleting A Range Saving Your Work Lesson 2: Functions, Formulas, & Charts Introduction Lesson Objectives Opening A Workbook The Function Wizard Searching For A Function Categories Of Functions Getting Help On A Function Copying An Example To A Worksheet The AVERAGE Function Specifying Function Arguments Redefining A Named Range Absolute Cell References The Median Function Using
more...
...eleting A Range Saving Your Work Lesson 2: Functions, Formulas, & Charts Introduction Lesson Objectives Opening A Workbook The Function Wizard Searching For A Function Categories Of Functions Getting Help On A Function Copying An Example To A Worksheet The AVERAGE Function Specifying Function Arguments Redefining A Named Range Absolute Cell References The Median Function Using
more...
Excel 2000 Intermediate
..., Linking Cells To The Internet, Review
Lesson 4 : Formulas And More, Introduction, Creating 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...
..., Linking Cells To The Internet, Review
Lesson 4 : Formulas And More, Introduction, Creating 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...
Excel 2002 Basic
... The Insert Options Button Inserting A Column Entering Formulas In A Worksheet The AutoFill Handle The AutoFill Options Button Entering A Function Correcting Errors Formatting Decimal Places The Number Tab Adding More Rows Shortcut Menus Revising A Formula Sorting Inserting A Comment Hiding A Comment Deleting A Comment The If Function The Logical Test Using Absolute Cell
more...
... The Insert Options Button Inserting A Column Entering Formulas In A Worksheet The AutoFill Handle The AutoFill Options Button Entering A Function Correcting Errors Formatting Decimal Places The Number Tab Adding More Rows Shortcut Menus Revising A Formula Sorting Inserting A Comment Hiding A Comment Deleting A Comment The If Function The Logical Test Using Absolute Cell
more...
Lotus Notes Domino R5 Set of 6
...Application Development Level 2 (1 Hour 49 Minutes) 1.0 Formulas (24 Minutes) 1.1 Constants 1.2 Arguments 1.3 @ Functions 1.4 Applying Formulas in Editable Fields 1.5 Applying Formulas in Computed Fields 2.0 Actions (14 Minutes) 2.1 Single Use Actions & Actions in Forms 2.2 Actions in Views 2.3 Shared Actions 3.0 Pages (10 Minutes) 3.1 Creating Pages 3.2 Using Shared
more...
...Application Development Level 2 (1 Hour 49 Minutes) 1.0 Formulas (24 Minutes) 1.1 Constants 1.2 Arguments 1.3 @ Functions 1.4 Applying Formulas in Editable Fields 1.5 Applying Formulas in Computed Fields 2.0 Actions (14 Minutes) 2.1 Single Use Actions & Actions in Forms 2.2 Actions in Views 2.3 Shared Actions 3.0 Pages (10 Minutes) 3.1 Creating Pages 3.2 Using Shared
more...
Excel 2000 User Set of 3
...iques
2.3 Erasing Data
2.4 Auto Complete
3.0 Entering Formulas (26 Minutes)
3.1 Three Methods of Entering Formulas
3.2 Repeating a Formula
3.3 Formulas Beyond Addition and Subtraction
4.0 Basic Functions (21 Minutes)
4.1 Summation
4.2 Recalculating Effects (Change one cell and five others change)
4.3 Averages
5.0 Formatting (13 Minutes)
5.1 The Formatting Toolbar
5.2
more...
...iques
2.3 Erasing Data
2.4 Auto Complete
3.0 Entering Formulas (26 Minutes)
3.1 Three Methods of Entering Formulas
3.2 Repeating a Formula
3.3 Formulas Beyond Addition and Subtraction
4.0 Basic Functions (21 Minutes)
4.1 Summation
4.2 Recalculating Effects (Change one cell and five others change)
4.3 Averages
5.0 Formatting (13 Minutes)
5.1 The Formatting Toolbar
5.2
more...
Excel 2000 - Proficient User
...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. DiscoverWare products combine audio, animation, and software simulation with a unique user interface to make the "discovery" of computer programs both effective and entertaining. The program is also
more...
...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. DiscoverWare products combine audio, animation, and software simulation with a unique user interface to make the "discovery" of computer programs both effective and entertaining. The program is also
more...
Lotus Domino 5 Application Development LV 2
Application Development Level 2 (1 Hour 49 Minutes) 1.0 Formulas (24 Minutes) 1.1 Constants 1.2 Arguments 1.3 @ Functions 1.4 Applying Formulas in Editable Fields 1.5 Applying Formulas in Computed Fields 2.0 Actions (14 Minutes) 2.1 Single Use Actions & Actions in Forms 2.2 Actions in Views 2.3 Shared Actions 3.0 Pages (10 Minutes) 3.1 Creating Pages 3.2 Using Shared Resources
more...
Application Development Level 2 (1 Hour 49 Minutes) 1.0 Formulas (24 Minutes) 1.1 Constants 1.2 Arguments 1.3 @ Functions 1.4 Applying Formulas in Editable Fields 1.5 Applying Formulas in Computed Fields 2.0 Actions (14 Minutes) 2.1 Single Use Actions & Actions in Forms 2.2 Actions in Views 2.3 Shared Actions 3.0 Pages (10 Minutes) 3.1 Creating Pages 3.2 Using Shared Resources
more...
Excel 2000 Beginning
...iques
2.3 Erasing Data
2.4 Auto Complete
3.0 Entering Formulas (26 Minutes)
3.1 Three Methods of Entering Formulas
3.2 Repeating a Formula
3.3 Formulas Beyond Addition and Subtraction
4.0 Basic Functions (21 Minutes)
4.1 Summation
4.2 Recalculating Effects (Change one cell and five others change)
4.3 Averages
5.0 Formatting (13 Minutes)
5.1 The Formatting Toolbar
5.2
more...
...iques
2.3 Erasing Data
2.4 Auto Complete
3.0 Entering Formulas (26 Minutes)
3.1 Three Methods of Entering Formulas
3.2 Repeating a Formula
3.3 Formulas Beyond Addition and Subtraction
4.0 Basic Functions (21 Minutes)
4.1 Summation
4.2 Recalculating Effects (Change one cell and five others change)
4.3 Averages
5.0 Formatting (13 Minutes)
5.1 The Formatting Toolbar
5.2
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 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
...A Workbook Locking & Unlocking 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
more...
...A Workbook Locking & Unlocking 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
more...
WordPerfect 9 Intermediate
...Using SpeedFormat, Sorting The Contents Of A Table, Using Formulas In A Table, Copying A Formula From One Cell To Another, Copying A Formula To Multiple Cells At Once Lesson 7: Adding A Footnote, Adding A Bookmark, Formatting Footnote Text, Changing The Font Face Of Footnote Text, Changing The Font Size Of Footnote Text, Changing The Color Of Footnote Text, Changing Line Separator
more...
...Using SpeedFormat, Sorting The Contents Of A Table, Using Formulas In A Table, Copying A Formula From One Cell To Another, Copying A Formula To Multiple Cells At Once Lesson 7: Adding A Footnote, Adding A Bookmark, Formatting Footnote Text, Changing The Font Face Of Footnote Text, Changing The Font Size Of Footnote Text, Changing The Color Of Footnote Text, Changing Line Separator
more...
Quattro Pro 9 Intermediate
...diting Multiple Sheets Using Group, Creating Multi-Sheets Formulas, Creating Multi-Notebook Formulas, Inserting Another Notebook, Managing Links, Deleting Notebook Links Lesson 4: Opening An Existing Document, Copying From Another Application, Paste Special, Inserting Date, Formatting The Date, Formatting The Time, Creating Absolute Cell Reference, Hiding Spreadsheet Data, Using
more...
...diting Multiple Sheets Using Group, Creating Multi-Sheets Formulas, Creating Multi-Notebook Formulas, Inserting Another Notebook, Managing Links, Deleting Notebook Links Lesson 4: Opening An Existing Document, Copying From Another Application, Paste Special, Inserting Date, Formatting The Date, Formatting The Time, Creating Absolute Cell Reference, Hiding Spreadsheet Data, Using
more...
Lotus Domino R5 Application Development Level 2
Application Development Level 2 (1 Hour 49 Minutes) 1.0 Formulas (24 Minutes) 1.1 Constants 1.2 Arguments 1.3 , Functions 1.4 Applying Formulas in Editable Fields 1.5 Applying Formulas in Computed Fields 2.0 Actions (14 Minutes) 2.1 Single Use Actions & Actions in Forms 2.2 Actions in Views 2.3 Shared Actions 3.0 Pages (10 Minutes) 3.1 Creating Pages 3.2 Using Shared Resources
more...
Application Development Level 2 (1 Hour 49 Minutes) 1.0 Formulas (24 Minutes) 1.1 Constants 1.2 Arguments 1.3 , Functions 1.4 Applying Formulas in Editable Fields 1.5 Applying Formulas in Computed Fields 2.0 Actions (14 Minutes) 2.1 Single Use Actions & Actions in Forms 2.2 Actions in Views 2.3 Shared Actions 3.0 Pages (10 Minutes) 3.1 Creating Pages 3.2 Using Shared Resources
more...
Crystal Reports 8--Level 2
... Modifying & Deleting a Conditional Format 4.0 Creating Formulas with Crystal Syntax (47 Mins) 4.1 The Formula Editor & Inserting Formulas 4.2 Changing Numbers to Words 4.3 String Manipulation 4.4 Date Calculations 4.5 Creating Summary Calculations & Totaling By Group 4.6 Working with Running Totals 4.7 Running Sums 4.8 If-Then-Else Formulas 5.0 Creating Formulas with Basic Syntax
more...
... Modifying & Deleting a Conditional Format 4.0 Creating Formulas with Crystal Syntax (47 Mins) 4.1 The Formula Editor & Inserting Formulas 4.2 Changing Numbers to Words 4.3 String Manipulation 4.4 Date Calculations 4.5 Creating Summary Calculations & Totaling By Group 4.6 Working with Running Totals 4.7 Running Sums 4.8 If-Then-Else Formulas 5.0 Creating Formulas with Basic Syntax
more...
Crystal Reports 8--Level 6
Crystal Reports 8 Level 6 (1 Hr 58 Mins) 1.0 Advanced Formula Techniques (51 Mins) 1.1 Creating a Complex Formula 1.2 Using a Variable 1.3 Assigning a Value to a Variable 1.4 Using Arrays in Formulas 1.5 Using Ranges in Formulas 1.6 Debugging Formulas 2.0 Charting Your Report Data (1 Hr 7 Mins) 2.1 Creating a Group Chart 2.2 Creating a Detail Formula Chart 2.3 Creating a Cross-tab
more...
Crystal Reports 8 Level 6 (1 Hr 58 Mins) 1.0 Advanced Formula Techniques (51 Mins) 1.1 Creating a Complex Formula 1.2 Using a Variable 1.3 Assigning a Value to a Variable 1.4 Using Arrays in Formulas 1.5 Using Ranges in Formulas 1.6 Debugging Formulas 2.0 Charting Your Report Data (1 Hr 7 Mins) 2.1 Creating a Group Chart 2.2 Creating a Detail Formula Chart 2.3 Creating a Cross-tab
more...
Excel XP Proficient Expert
...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 Capabilities Screen Layout - The Task Pane - Title Bar, Menus & Toolbars Create & Open A Workbook - What Is A
more...
...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 Capabilities Screen Layout - The Task Pane - Title Bar, Menus & Toolbars Create & Open A Workbook - What Is A
more...
