Formula 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
...k Panes Hiding The Task Pane Showing The Task Pane The Formula 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
more...
...k Panes Hiding The Task Pane Showing The Task Pane The Formula 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
more...
Excel 2000 User Set of 3
...d 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 Formulas (26 Minutes)
3.1 Three Methods of Entering
more...
...d 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 Formulas (26 Minutes)
3.1 Three Methods of Entering
more...
Excel 2000 Beginning
...d 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 Formulas (26 Minutes)
3.1 Three Methods of Entering
more...
...d 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 Formulas (26 Minutes)
3.1 Three Methods of Entering
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 Introduction
... Using @Sum Function, Using The @Mult Function, Using The Formula Composer Button, Creating A Chart Using The QuickChart Tool, Creating A Chart Using The Chart Expert, Exploring Chart Types, Changing The Chart Type For An Existing Chart, Editing Charts, Rotating A Bar Chart, Using QuickCell
Lesson 4: Introduction, Starting Quattro Pro, Working With Fonts, Changing Font Face, Changing
more...
... Using @Sum Function, Using The @Mult Function, Using The Formula Composer Button, Creating A Chart Using The QuickChart Tool, Creating A Chart Using The Chart Expert, Exploring Chart Types, Changing The Chart Type For An Existing Chart, Editing Charts, Rotating A Bar Chart, Using QuickCell
Lesson 4: Introduction, Starting Quattro Pro, Working With Fonts, Changing Font Face, Changing
more...
Quattro Pro 9 Advanced
..., Using The What-If Expert, The Invoking Expert, Expert - Formula Cell, Expert - Input Cell, Table Cells, Two Variable What-If Tables, Row Input Cell
Lesson 4: Introduction, Opening An Existing Document, Writing A Macro Script, Using The {IF} Command In Macros, Attaching A Macro To A QuickButton, Attaching A Macro To A RadioButton, Opening The Visual Basic Editor, Inserting A Userform,
more...
..., Using The What-If Expert, The Invoking Expert, Expert - Formula Cell, Expert - Input Cell, Table Cells, Two Variable What-If Tables, Row Input Cell
Lesson 4: Introduction, Opening An Existing Document, Writing A Macro Script, Using The {IF} Command In Macros, Attaching A Macro To A QuickButton, Attaching A Macro To A RadioButton, Opening The Visual Basic Editor, Inserting A Userform,
more...
Lotus Domino R5 Application Development Update Level 2
...1.5 Navigators 1.6 Image Resources, Shared Actions 2.0 Formula Language Changes (29 min) 2.1 New @Functions 2.2 New @Commands 3.0 Quiz (24 min) 3.1 What are the ways to launch the Designer? 3.2 What are the names of the tabs in the design pane? What do the tabs in the Designer provide? 3.3 Tell me ways of previewing a doc in a browser? 3.4 Can you create a non-scrolling header &
more...
...1.5 Navigators 1.6 Image Resources, Shared Actions 2.0 Formula Language Changes (29 min) 2.1 New @Functions 2.2 New @Commands 3.0 Quiz (24 min) 3.1 What are the ways to launch the Designer? 3.2 What are the names of the tabs in the design pane? What do the tabs in the Designer provide? 3.3 Tell me ways of previewing a doc in a browser? 3.4 Can you create a non-scrolling header &
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 4
Crystal Reports 8.0 Level 4 (2 Hrs 3 Mins) 1.0 Summary Reports (19 Mins) 1.1 Building a Summary Report 1.2 Allowing or Disallowing Drill-downs 2.0 Running Totals Reports (22 Mins) 2.1 Creating Running Totals Overall 2.2 Creating Running Totals for a Group 2.3 Creating Conditional Running Totals 2.4 Creating Running Totals with a One-to-Many Relationship 3.0 Top N (10 Mins) 3.1
more...
Crystal Reports 8.0 Level 4 (2 Hrs 3 Mins) 1.0 Summary Reports (19 Mins) 1.1 Building a Summary Report 1.2 Allowing or Disallowing Drill-downs 2.0 Running Totals Reports (22 Mins) 2.1 Creating Running Totals Overall 2.2 Creating Running Totals for a Group 2.3 Creating Conditional Running Totals 2.4 Creating Running Totals with a One-to-Many Relationship 3.0 Top N (10 Mins) 3.1
more...
Crystal Reports 8--Level 6
...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 Chart 2.4 Modifying Chart Options 2.5 Drilling Down
more...
...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 Chart 2.4 Modifying Chart Options 2.5 Drilling Down
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...
