The If Function Training on CD-ROM - Training Resources

Excel 2000 - Proficient User DiscoverWare's Discover Excel 2000 is an interactive productivity tool for users of Microsoft Excel 2000. Excel 2000 builds on the spreadsheet capabilities of previous versions of the program to provide powerful tools for creating and sharing professional worksheets online and on the Web. Topics include basic spreadsheet concepts, workbook and file management, using formulas and functions, editing  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 Advanced ...ators (* / -) 4.4 Using Logical Operators (AND & OR) with the IF Function 4.5 Nested IF Functions 4.6 Using the VLOOKUP Function to overcome Limitations of the IF Functions 5.0 Date & Time Functions (21 Minutes) 5.1 Using Dates as Values 5.2 Entering a Series of Dates 5.3 Date/Time entry Techniques 6.0 Multi-Sheet Workbooks (22 Minutes) 6.1 Re-Naming & Re-Ordering Sheets 6.2 Inserting and  more...

Excel 2000 User Set of 3 ...ators (* / -) 4.4 Using Logical Operators (AND & OR) with the IF Function 4.5 Nested IF Functions 4.6 Using the VLOOKUP Function to overcome Limitations of the IF Functions 5.0 Date & Time Functions (21 Minutes) 5.1 Using Dates as Values 5.2 Entering a Series of Dates 5.3 Date/Time entry Techniques 6.0 Multi-Sheet Workbooks (22 Minutes) 6.1 Re-Naming & Re-Ordering Sheets 6.2 Inserting and  more...

Excel 2000 Introduction ...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 3: Inserting Objects And Formatting Cells, Introduction, Opening Excel, Open Options, Changing The Zoom Percentage, The ClipArt Gallery, Selecting A ClipArt Category, Searching For  more...

Excel 2000 Intermediate LESSON_STR Excel 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 ...g Inserting A Comment Hiding A Comment Deleting A Comment The If Function The Logical Test Using Absolute Cell References Reviewing Results Saving A Workbook The Save As Dialog Box Lesson 3: Objects & Formatting Introduction Lesson Objectives The New Workbook Task Pane The Recently Used File List Changing The Zoom Percentage Selecting Non Adjacent Cells Changing Font Color Accessing The Clip  more...

Excel 2002 Intermediate Lesson 1: The Document Window Introduction Lesson Objectives 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  more...

Excel 2002 Advanced Lesson 1: Sorting & Filtering Data Introduction Lesson Objectives Opening Excel Importing Data From A Web Page The New Web Query Dialog Box Selecting A Table Navigating Pages Web Query Options Saving A Web Query Placing Data The External Data Toolbar Editing A Query Data Range Properties Refreshing Data Running A Saved Query Full Screen View Sorting Data Then By Sorting Using AutoFilter Using  more...

Excel XP Essentials Set of 3 ...ng Precedent Cells 3.0 The IF & VLOOKUP Functions 3.1 The IF Functions & Relational Operators 3.2 Using Words in IF Functions 3.3 Using Logical Operators 3.4 Nested IF Functions 3.5 Getting Data from the Table with a VLOOKUP Function 4.0 Date & Time Functions 4.1 Using Dates as Values 4.2 Entering a Series of Dates 4.3 Date/Time Entry Techniques 5.0 Multi-Sheet Workbooks 5.1  more...

Advanced C Programming Set of 6 Level 1 1.0 C++ Exceptions 1.1 C++ Exception Handling Model 1.2 C++ Handling Syntax 1.3 Standard C++ Exception Classes 1.4 C++ Exception: Summary & Exercises 2.0 Templates 2.1 Templates & the Standard 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:  more...

Exchange Server 2000 System Admin Set of 5 Administration Level 1 1.0 Overview of Exchange Server 1.1 Shared-file vs. Client-Server 1.2 Exchange 2000 Server Family 1.3 Exchange 2000 Server Features 2.0 Integration with Active Directory 2.1 AD Concepts Review 2.2 Schema 2.3 Domains 3.0 Exchange 2000 Server Architecture 3.1 Overview of Components 3.2 Communication Between Components 3.3 Message Flow in Exchange 2000 Server  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 Author Doug Sahlin teaches you the ins and outs of Macromedia Flash MX ActionScripting. Designed to create websites or multimedia presentations for CD-ROM, Flash MX ActionScripting allows users to create exciting animated graphics while keeping a smaller file size than with conventional graphic editing methods. Learn key concepts that will make your Flash designs efficient and entertaining. If you  more...

Flash 5 ActionScripting Virtual Training Company's Flash ActionScripting tutorial gives you an in-depth look into the scripting abilities of Macromedia's Flash 5. Author Don Rissler teaches with the assumption that you are already familiar with Flash, and he dives right into teaching you the actionscripting capabilities. Some of what you will learn includes Motion blur, the Ring of Saturn, the break down of scripting  more...

Paradox 9 ObjectPAL Lesson 1: Introduction To ObjectPAL Opening Paradox 9 Opening A Form Introduction To ObjectPAL The Object Explorer Window The Object Tree Pane Introduction To Object Trees The Tabbed Pane The Appearance Tab The Properties Tab The Methods Tab ObjectPAL Code The If Structure The VCR Control The Back Event The FastBack Event The FastForward Event The FirstRecord Event The Forward  more...

Excel 2002 Intermediate Lesson 1: The Document Window Introduction Lesson Objectives 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  more...

Excel 2000 Intermediate LESSON_STR Excel 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  more...

Excel 2002 Basic ...nserting A Comment Hiding A Comment Deleting A Comment The If Function The Logical Test Using Absolute Cell References Reviewing Results Saving A Workbook The Save As Dialog Box Lesson 3: Objects & Formatting Introduction Lesson Objectives The New Workbook Task Pane The Recently Used File List Changing The Zoom Percentage Selecting Non Adjacent Cells Changing Font Color  more...

Flash MX ActionScript Author Doug Sahlin teaches you the ins and outs of Macromedia Flash MX ActionScripting. Designed to create websites or multimedia presentations for CD-ROM, Flash MX ActionScripting allows users to create exciting animated graphics while keeping a smaller file size than with conventional graphic editing methods. Learn key concepts that will make your Flash designs efficient and entertaining. If you  more...

Flash 5 ActionScripting Virtual Training Company's Flash ActionScripting tutorial gives you an in-depth look into the scripting abilities of Macromedia's Flash 5. Author Don Rissler teaches with the assumption that you are already familiar with Flash, and he dives right into teaching you the actionscripting capabilities. Some of what you will learn includes Motion blur, the Ring of Saturn, the break down of scripting  more...

Visual C 6 0 Set of 6 Level 1 Video (1 hr 46 min) 1.0 Introduction to C++ 6 (54 min) 1.1 Overview 1.2 Building a Simple Project 1.3 Creating a Win32 Console Application 1.4 Creating Header Files 2.0 Major Components (16 min) 2.1 Build Process 2.2 Resources 2.3 Visual C++ Compiler 2.4 Linker 2.5 Source Code Editor 2.6 Visual C++ Debugger 3.0 Object Oriented Interfaces (34 min) 3.1 Message  more...

Visual Basic 6 0 Power Developer Set of 9 LV 9-17 Level 9 (2 Hours 13 Minutes) 1.0 Package & Deployment Wizard (29 min) 1.1 What is a Setup 1.2 Steps to Distribution 1.3 VB Runtime Files 1.4 Setup Runtime Files 1.5 Types of Setups 1.6 Creating a Package 1.7 Deploying the Package 1.8 Testing the Setup 2.0 Advanced Common Controls (1 Hour 1 min) 2.1 Flex Grid Control 2.2 Hierarchical Flex Grid Control 2.3 Tree View & List View  more...

Excel 2000 User Set of 3 ...s (* / + -) 4.4 Using Logical Operators (AND & OR) with the IF Function 4.5 Nested IF Functions 4.6 Using the VLOOKUP Function to overcome Limitations of the IF Functions 5.0 Date & Time Functions (21 Minutes) 5.1 Using Dates as Values 5.2 Entering a Series of Dates 5.3 Date/Time entry Techniques 6.0 Multi-Sheet Workbooks (22 Minutes) 6.1 Re-Naming & Re-Ordering Sheets  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 Level 11 Component Development (2 Hours) 1.0 Introduction to ActiveX Technology (6 min) 1.1 COM 1.2 DCOM 1.3 Compound Documents 1.4 In-Place Activation 1.5 Active X Container 1.6 Active X Server Components 1.7 Active Automation 2.0 Creating ActiveX Components (39 min) 2.1 Types of Components 2.2 Building an Active X DLL 2.3 Compiling the DLL 2.4 Debugging the DLL 2.5  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 DiscoverWare's Discover Excel 2000 is an interactive productivity tool for users of Microsoft Excel 2000. Excel 2000 builds on the spreadsheet capabilities of previous versions of the program to provide powerful tools for creating and sharing professional worksheets online and on the Web. Topics include basic spreadsheet concepts, workbook and file management, using formulas and functions,  more...

Access 2000 Application Developer Set of 16 Access 2000 Application Development Level 1 (2 Hours 5 Minutes) 1.0 Access as a Development Tool (37 Minutes) 1.1 Types of Applications You Can Develop 1.2 What Exactly is a Database 1.3 Getting to Know the Database Objects 1.4 Object Naming Conventions 1.5 Hardware Requirements 1.6 Getting Started Developing an Application 2.0 Tables (39 Minutes) 2.1  more...

Access 2000 Application Developer Set of 16 Access 2000 Application Development Level 1 (2 Hours 5 Minutes) 1.0 Access as a Development Tool (37 Minutes) 1.1 Types of Applications You Can Develop 1.2 What Exactly is a Database 1.3 Getting to Know the Database Objects 1.4 Object Naming Conventions 1.5 Hardware Requirements 1.6 Getting Started Developing an Application 2.0 Tables (39 Minutes) 2.1  more...

Access 2000 Application Developer Set of 16 Access 2000 Application Development Level 1 (2 Hours 5 Minutes) 1.0 Access as a Development Tool (37 Minutes) 1.1 Types of Applications You Can Develop 1.2 What Exactly is a Database 1.3 Getting to Know the Database Objects 1.4 Object Naming Conventions 1.5 Hardware Requirements 1.6 Getting Started Developing an Application 2.0 Tables (39 Minutes) 2.1  more...

Access 2000 Application Developer Set of 16 Access 2000 Application Development Level 1 (2 Hours 5 Minutes) 1.0 Access as a Development Tool (37 Minutes) 1.1 Types of Applications You Can Develop 1.2 What Exactly is a Database 1.3 Getting to Know the Database Objects 1.4 Object Naming Conventions 1.5 Hardware Requirements 1.6 Getting Started Developing an Application 2.0 Tables (39 Minutes) 2.1 Building a New Table 2.2  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 Application Development Level 11 (1 Hour 54 Minutes) 1.0 Advanced VBA Techniques (1 Hour) 1.1 User-Defined Types 1.2 Working 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  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 ...s (* / + -) 4.4 Using Logical Operators (AND & OR) with the IF Function 4.5 Nested IF Functions 4.6 Using the VLOOKUP Function to overcome Limitations of the IF Functions 5.0 Date & Time Functions (21 Minutes) 5.1 Using Dates as Values 5.2 Entering a Series of Dates 5.3 Date/Time entry Techniques 6.0 Multi-Sheet Workbooks (22 Minutes) 6.1 Re-Naming & Re-Ordering Sheets  more...

Excel 2002 Advanced Lesson 1: Sorting & Filtering Data Introduction Lesson Objectives Opening Excel Importing Data From A Web Page The New Web Query Dialog Box Selecting A Table Navigating Pages Web Query Options Saving A Web Query Placing Data The External Data Toolbar Editing A Query Data Range Properties Refreshing Data Running A Saved Query Full Screen View Sorting Data Then By Sorting Using  more...

Quattro Pro 9 Introduction Quattro Pro 9 Introduction Quattro Pro 9 Basic Lesson 1: Introduction, Opening Quattro Pro 9, The Document Window, The Title Bar, The Menu Bar, The Toolbar, The Property Bar, The Input Line, Row And Column Headings, The Scroll Bars, The Spreadsheet Tabs, The Application Bar, Opening A File, Exploring Cells, Using Scroll Bars, The File Menu, The Edit Menu, The View Menu, The Insert  more...

Quattro Pro 9 Advanced Quattro Pro 9 a Advanced Quattro Pro 9 a Advanced  Lesson1: Introduction, Opening Quattro Pro 9, Inserting Images, Removing The Border From An Inserted Image, Inserting An Arrow Shape, Changing The Properties Of A Shape, Inserting TextArt, Inserting A Rounded Rectangle Shape, Changing The Order Of Objects, Adding A Chart Using The Chart Expert, Naming The X And Y Axis Of A  more...

Paradox 9 Volumes I II Corel Paradox 9 Volume 1 Lesson 1: Exploring Paradox 9 And Database Concepts Introduction To Database Systems Paradox 9 And Normalization Opening Paradox 9 The Welcome Screen Opening An Existing Database Displaying Forms Displaying Reports Displaying Tables Opening The Table Examining Table Structure Navigating Through Records Appending A New Record Switching To  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 Visual Basic.NET is a significant upgrade to Visual Basic and incorporates many new features and framework goals of the .Net architecture. Learning to manage these changes will allow VB developers to create enterprise applications for the .NET platform and to create more traditional VB applications that can take advantage of the enhancements to the language. Level 1 DOT NET Concepts  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 Visual Basic.NET is a significant upgrade to Visual Basic and incorporates many new features and framework goals of the .Net architecture. Learning to manage these changes will allow VB developers to create enterprise applications for the .NET platform and to create more traditional VB applications that can take advantage of the enhancements to the language. Level 1 DOT NET Concepts  more...

Excel XP Proficient Expert DiscoverWare's a Discover Excel XP a is an interactive productivity tool for users of Microsoft Excel XP. Excel XP builds on the spreadsheet capabilities of previous versions of the program to provide 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,  more...