Function Training on CD-ROM - Training Resources
Function Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
Excel 2000 - Proficient User
...oncepts, 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 designed to help
more...
Excel 2000 - Proficient User
PowerPoint 2000 - Proficient User
DiscoverWare's Discover PowerPoint 2000 is an interactive productivity tool for users of Microsoft PowerPoint 2000. PowerPoint 2000 builds on the presentation features of previous versions of the program to provide powerful tools for creating and sharing professional documents online and on the Web. Topics include PowerPoint basics, creating presentations, working with slides, working with text,
more...
Excel 2000 Advanced
...ing 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) 4.1 IF Functions and Relational Operators (> = ) 4.2 Using Words in IF Functions 4.3 Using IF Functions with Arithmetic Operators (* / -) 4.4 Using Logical Operators (AND & OR) with the IF
more...
Excel 2000 User Set of 3
...la 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 Adjusting Column-width and Row-height 5.3 Numeric Formatting 6.0 Saving, Opening & Closing Files (16 Minutes) 6.1 File Save or File Save as 6.2 Opening a File 6.3
more...
Excel 2000 Introduction
...las Into A Spreadsheet, The AutoFill Command, The Average Function, Formatting Decimal Places, The Number Tab, Office Assistant Tip, Inserting A Row, Revising A Formula, Sorting, Inserting Comments, Hiding A Comment, Deleting A Comment, The If Function, Selecting Multiple Cells With The Name Box, Using Absolute Cell References, The If Function, Reviewing Results, Saving Changes, Review Lesson
more...
Excel 2000 Intermediate
... Inserting Cells, Cell Descriptions, Review Lesson 2: The Function Wizard, Introduction, The Function Wizard, Calculating An Average, Calculating A Median, Calculating A Standard Deviation, Creating A Chart, Formatting Chart Components, Changing The Fill Color, The Gradient Tab, Selecting A Gradient, The Texture Tab, The Pattern Tab, The Picture Tab, The Data Labels Tab, The Options Tab,
more...
Excel 2002 Basic
...ask 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 Status Bar Overview Of Menus The File
more...
Excel 2002 Intermediate
...to Fill Options About Cell & Range References The Average Function The Range Finder Formatting Numbers The Go To Dialog Box Naming A Range Of Cells Inserting A Range of Cells Defining A Name Selecting A Named Range Deleting 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
more...
Excel 2002 Advanced
...Using AutoFit Opening Access Databases In Excel Lesson 3: Functions & 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
more...
Excel XP Essentials Set of 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 5.3 Numeric Formatting 6.0 Saving, Opening & Closing Files 6.1 File Save & File Save As 6.2 Opening a File 6.3 Creating a New Workbook 7.0 The Help
more...
Advanced C Programming Set of 6
... Template Library 2.2 Template Classes 2.3 C++ Template Functions 2.4 Member Function Templates 2.5 Default Template Parameters 2.6 Template Performance Issues 2.7 C++ Template: Summary & Exercises Level 2 1.0 Standard Template Library 1.1 STL Major Components 1.2 Section Objectives - What You Need to Know 1.3 STL & How It Fits 1.4 Generic Programming 1.5 Using the STL 1.6
more...
Exchange Server 2000 System Admin Set of 5
...Configuring an Exchange 2000 Server 1.1 Configuring for Function 1.2 Configuring for Management 1.3 Configuring for Availability 1.4 Configuring for Security 2.0 Configuring Public Folders 2.1 Overview of Public Folders 2.2 Public Folders Security 2.3 Public Folder Replication 3.0 Address List Management 3.1 Address Lists Administration Level 5 1.0 Instant Messaging 1.1
more...
HTML DHTML Introduction
Lesson 1: Basic Concepts Introduction Internet Concepts History Of The Internet Network Types Local Area Networks Metropolitan Area Networks Wide Area Networks The Internet Networking Essentials Clients and Servers Protocols IP Addresses Uniform Resource Locators The World Wide Web How The WWW Works Markup Languages Standard Generalized Markup Language Hyper Text Markup Language Dynamic
more...
HTML DHTML Introduction
Lesson 1: Basic Concepts Introduction Internet Concepts History Of The Internet Network Types Local Area Networks Metropolitan Area Networks Wide Area Networks The Internet Networking Essentials Clients and Servers Protocols IP Addresses Uniform Resource Locators The World Wide Web How The WWW Works Markup Languages Standard Generalized Markup Language Hyper Text Markup Language Dynamic
more...
Flash MX ActionScript
...ating Data pt. 2 Manipulating Data pt. 3 Working With Functions What is a Function? Creating a Function Calling a Function Working With Flash Components Using Flash Components Getting New Components Skinning Flash Components Creating a Component pt. 1 Creating a Component pt. 2 Creating a Component pt. 3 Debugging ActionScript Testing and Debugging Your Movies Using the
more...
Flash 5 ActionScripting
...ion blur, the Ring of Saturn, the break down of scripting functions, and making button scripts. Course Duration: 14 Hours Motion Blur Creating Text Using Duplicate Clips SetProperty & Test 3D Logo with Ring of Saturn Text Intro Creating the Logo Adding Text/Creating Sphere Creating the Logo Shadow Creating the Sphere Shadow Testing & Tweeking Standard Debugging Basic
more...
Paradox 9 ObjectPAL
...A Variable Checking For A Required Key The OpenAsDialog Function Style Constants Adding Another Constant Using The Plus Sign Storing A Form Return Value Error Handling Checking Syntax Using The Menu Bar Errors In Design Mode Running A Form Using The Menu Bar Opening A Table Declaring A TCursor Variable Opening A Table Using A TCursor Variable Locating A Record Using A TCursor
more...
Excel 2002 Intermediate
... Fill Options About Cell & Range References The Average Function The Range Finder Formatting Numbers The Go To Dialog Box Naming A Range Of Cells Inserting A Range of Cells Defining A Name Selecting A Named Range Deleting A Range Saving Your Work Lesson 2: Functions, Formulas, & Charts Introduction Lesson Objectives Opening A Workbook The Function Wizard Searching For A
more...
Excel 2000 Intermediate
...ng Cells, Cell Descriptions, Review
Lesson 2 : The Function Wizard, Introduction, The Function Wizard, Calculating An Average, Calculating A Median, Calculating A Standard Deviation, Creating A Chart, Formatting Chart Components, Changing The Fill Color, The Gradient Tab, Selecting A Gradient, The Texture Tab, The Pattern Tab, The Picture Tab, The Data Labels Tab, The Options Tab,
more...
Excel 2002 Basic
... 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 Status Bar Overview Of
more...
Flash MX ActionScript
...ting Data pt. 2 Manipulating Data pt. 3 Working With Functions What is a Function? Creating a Function Calling a Function Working With Flash Components Using Flash Components Getting New Components Skinning Flash Components Creating a Component pt. 1 Creating a Component pt. 2 Creating a Component pt. 3 Debugging ActionScript Testing and Debugging Your Movies Using the
more...
Flash 5 ActionScripting
...ion blur, the Ring of Saturn, the break down of scripting functions, and making button scripts. Course Duration: 14 Hours Motion Blur Creating Text Using Duplicate Clips SetProperty & Test 3D Logo with Ring of Saturn Text Intro Creating the Logo Adding Text/Creating Sphere Creating the Logo Shadow Creating the Sphere Shadow Testing & Tweeking Standard Debugging Basic
more...
Visual C 6 0 Set of 6
...eaning up the View
1.4 Multiple Views
1.5 Init Instance Function
1.6 Changing Views
1.7 Modifying View Specifications
1.8 Creating a Splitter Window
1.9 Altering the Split Arrangement
1.10 Understanding the Editor
1.11 Applications Based on the RichEditView
Level 6 Video
(1 hr 54 min)
1.0 Using MFC (1 hr)
1.1 Multiple Document Interfaces
1.2 Adapting SDI's to MDI's
1.3
more...
Visual Basic 6 0 Power Developer Set of 9 LV 9-17
... X DLL 2.3 Compiling the DLL 2.4 Debugging the DLL 2.5 Function: Create Object 2.6 Binding 2.7 Creating an Active X EXE 2.8 Running the DLL from Excel 2.9 Differences between an Active X DLL & EXEs 3.0 Active X Components (18 min) 3.1 Registering 3.2 Versioning 3.3 Error Handling 4.0 Call-Backs and Events (22 min) 4.1 What is a Call Back 4.2 The Server Side 4.3 The Client
more...
Excel 2000 User Set of 3
...
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 Adjusting Column-width and Row-height
5.3 Numeric Formatting
6.0 Saving, Opening & Closing Files (16 Minutes)
6.1 File Save or File Save as
6.2
more...
Visual C 6 0 LV 5
Level 5 Video
(1 hr 55 min)
1.0 More SDI (1 hr 54
min)
1.1 Lists Boxes
1.2 Serialization
1.3 Cleaning up the View
1.4 Multiple Views
1.5 Init Instance Function
1.6 Changing Views
1.7 Modifying View Specifications
1.8 Creating a Splitter Window
1.9 Altering the Split Arrangement
1.10 Understanding the Editor
1.11 Applications Based on the RichEditView
more...
Visual Basic 6 0 Component Development LV 11
... X DLL
2.3 Compiling the DLL
2.4 Debugging the DLL
2.5 Function: Create Object
2.6 Binding
2.7 Creating an Active X EXE
2.8 Running the DLL from Excel
2.9 Differences between an Active X DLL & EXEs
3.0 Active X Components (18
min)
3.1 Registering
3.2 Versioning
3.3 Error Handling
4.0 Call-Backs and Events (22
min)
4.1 What is a Call Back
4.2 The Server Side
4.3 The Client
more...
PowerPoint 2000 - Proficient User
DiscoverWare's Discover PowerPoint 2000 is an interactive productivity tool for users of Microsoft PowerPoint 2000. PowerPoint 2000 builds on the presentation features of previous versions of the program to provide powerful tools for creating and sharing professional documents online and on the Web. Topics include PowerPoint basics, creating presentations, working with slides, working with text,
more...
Excel 2000 - Proficient User
...oncepts, 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 designed to help
more...
Access 2000 Application Developer Set of 16
...ers Positionally
6.2 Returning Values
7.0 Built-in Functions (16 Minutes)
7.1 Format
7.2 Instr
7.3 Left & Right
7.4 Mid
7.5 Ucase
7.6 DatePart, DateDiff & DateAdd
7.7 The Object Browser
8.0 Working with Constants (9 Minutes)
8.1 Symbolic Constants
8.2 Intrinsic Constants
9.0 The Visual Basic Editor (10 Minutes)
9.1 IntelliSense
more...
Access 2000 Application Developer Set of 16
...ers Positionally
6.2 Returning Values
7.0 Built-in Functions (16 Minutes)
7.1 Format
7.2 Instr
7.3 Left & Right
7.4 Mid
7.5 Ucase
7.6 DatePart, DateDiff & DateAdd
7.7 The Object Browser
8.0 Working with Constants (9 Minutes)
8.1 Symbolic Constants
8.2 Intrinsic Constants
9.0 The Visual Basic Editor (10 Minutes)
9.1 IntelliSense
more...
Access 2000 Application Developer Set of 16
...ers Positionally
6.2 Returning Values
7.0 Built-in Functions (16 Minutes)
7.1 Format
7.2 Instr
7.3 Left & Right
7.4 Mid
7.5 Ucase
7.6 DatePart, DateDiff & DateAdd
7.7 The Object Browser
8.0 Working with Constants (9 Minutes)
8.1 Symbolic Constants
8.2 Intrinsic Constants
9.0 The Visual Basic Editor (10 Minutes)
9.1 IntelliSense
more...
Access 2000 Application Developer Set of 16
...ameters Positionally
6.2 Returning Values
7.0 Built-in Functions (16 Minutes)
7.1 Format
7.2 Instr
7.3 Left & Right
7.4 Mid
7.5 Ucase
7.6 DatePart, DateDiff & DateAdd
7.7 The Object Browser
8.0 Working with Constants (9 Minutes)
8.1 Symbolic Constants
8.2 Intrinsic Constants
9.0 The Visual Basic Editor (10 Minutes)
9.1 IntelliSense
9.2 The VBE Environment
9.3 Customizing
more...
Lotus Domino 5 Application Development LV 4
Application Development Level 4 (1 Hour 51 Minutes) 1.0 Accessing Data (1 Hour 17 Minutes) 1.1 Using @dbColumn & @dbLookup 1.2 ODBC 1.3 @Promp Function with @ Functions 1.4 Implementing Incremental P.O. Numbers 1.5 Profile Documents 1.6 Using @Picklist 1.7 @Dialog Box Function 2.0 Security (33 Minutes) 2.1 ACL (Access Control List) 2.2 Author / Reader Fields 2.3 Encryption
more...
Access 2000 Application Developer LV 11
...ing with Constants
1.3 Working with Arrays
1.4 Advanced Function Techniques
1.5 Working with Empty and Null
1.6 Creating and Working with Custom Collections
1.7 Compilation Options
1.8 Importing and Exporting Code Modules
1.9 Project Properties
2.0 Using ActiveX Controls (52 Minutes)
2.1 ActiveX Controls Explained
2.2 Incorporating ActiveX Controls
2.3 Setting ActiveX Control
more...
Access 2000 Application Developer LV 12
Application Development Level 12 (1 Hour 53 Minutes)
1.0 Automation: Communicating with Other Applications (1 Hour 2 Minutes)
1.1 Automation Terms
1.2 Declaring an Object Variable
1.3 Creating an Automation Object
1.4 Manipulating an Automation Object
1.5 Controlling Excel from Access & Closing an Excel Automation Object
1.6 Creating a Graph from Access
1.7 Controlling Word from Access
more...
Excel 2000 Advanced
...ependant 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)
4.1 IF Functions and Relational Operators (> =
)
4.2 Using Words in IF Functions
4.3 Using IF Functions with Arithmetic Operators (* / + -)
4.4 Using Logical Operators (AND
more...
Excel 2002 Advanced
...g AutoFit Opening Access Databases In Excel Lesson 3: Functions & 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
more...
Quattro Pro 9 Introduction
...attro Pro 9, Opening An Existing File, Using The @PureAvg Function, Using The @Max Function, Using The @Min Function, 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,
more...
Quattro Pro 9 Advanced
...
Lesson 2: Introduction, Opening An Existing File, @IF Function, Nested @IF Functions, Logical Operators, @FORECAST Function, Calculating Trends, Using Solve For, Creating A Scenario, Displaying A Scenario, Creating A Scenario Report, Entering An Optimizer Constraint, Creating An Optimizer Report., Auditing A Spreadsheet, Trace Precedents, Trace Dependents
Lesson 3: Introduction,
more...
Paradox 9 Volumes I II
...rtcut Key Moving To The First Column Of The Table The Function Of A Primary Key Restructuring The Table Changing The Size Of A Field Deleting A Field Completely Setting New Size Values Creating A Picture Setting Default Field Values Setting The Required Option Setting Passwords The Confirmation Boxes Inserting A Record Checking For New Table Settings Primary Key Data
more...
Lotus Domino R5 Application Development Level 4
Application Development Level 4 (1 Hour 51 Minutes) 1.0 Accessing Data (1 Hour 17 Minutes) 1.1 Using , dbColumn & , dbLookup 1.2 ODBC 1.3 , Promp Function with , Functions 1.4 Implementing Incremental P.O. Numbers 1.5 Profile Documents 1.6 Using , Picklist 1.7 , Dialog Box Function 2.0 Security (33 Minutes) 2.1 ACL (Access Control List) 2.2 Author / Reader Fields 2.3 Encryption
more...
Visual Basic Net Set of 7
... Creating & calling Sub Procedures Creating & calling Function Procedures Using Arguments -Passing Standard Arguments -Passing ByRef -Passing Arrays -Optional Arguments -Overloading Using Built-in Functions Using the Sub Main Operators & Expressions VB.NET Operators Building Expressions Using Strings Control of Flow Logic Using the If a Then
more...
Access 2000 - Proficient
DiscoverWare's Discover Access 2000 is an interactive productivity tool for users of Microsoft Access 2000.Access 2000 builds on the database capabilities of previous versions of the program to provide powerful tools for building and maintaining professional databases.Topics include basic database concepts,planning a database, creating and modifying tables and forms,finding and sorting
more...
Outlook 2000 - Proficient
Discover Outlook 2000 Outline Microsoft Outlook 2000 is a desktop information management program that combines e-mail, scheduling features, task management, and contact management. Outlook 2000 also contains collaboration tools, so information can be shared more effectively. DiscoverWare's Discover Outlook 2000 combines audio, animation, and software simulation with a unique user
more...
Visual Basic Net Set of 7
... Creating & calling Sub Procedures Creating & calling Function Procedures Using Arguments -Passing Standard Arguments -Passing ByRef -Passing Arrays -Optional Arguments -Overloading Using Built-in Functions Using the Sub Main Operators & Expressions VB.NET Operators Building Expressions Using Strings Control of Flow Logic Using the If a Then
more...
Excel XP Proficient Expert
...oncepts, 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 Workbook? -
more...
From Meditec.com
Medical Billing eBook CD-ROM Based Training Course
...is the entire basis for the medical industry. The primary function of any medical practice back-office, is to bill for and collect the revenue generated by the providers.
The Medical Billing eBook Course, which includes the Health Insurance Specialist module, is an extremely cost effective solution for those who will be working in the medical services industry. Our Medical Billing eBook
more...
