Online Use Functions eLearning Training

Excel 2002 This course introduces students to basic spreadsheet features and acquaints them with the tools used in Microsoft Excel 2002. As the course becomes more advanced, students will learn how to customize workbooks by changing worksheet attributes, use lists to store and organize data, use functions in financial and logical formulas, and format worksheets using AutoFormat and predefined styles. more...

Visual Basic 6 Introduction Part II This course provides an introduction to the functionality and programming capabilities of Visual Basic 6.0. It builds on the concepts presented in the first course in this series, Visual Basic 6.0 Introduction Part I. In the first unit, you will learn how to create and use variables, procedures, and functions in program code. Data types, constants, and arrays are also covered, as well as how to more...

Programming in PERL 5 This is the first course in the CGI/PERL curriculum. It introduces the users to fundamentals of PERL programming. The course describes the datatypes, operators, arrays, hashes, loops and functions in PERL. The users will be able to rectify errors and implement the OOP features in PERL. Web programmers, who want to implement HTML forms with WEB databases, and process HTML form values. more...

Linux Commands and Shell Scripting The Linux Commands and Shell Scripting WBT is a course developed for Application Developers who are already or somewhat familiar with the Unix and DOS environment. This course describes the execution and function of various Linux commands and describes the concept of shell in the Linux environment. The course provides an overview of the various Linux commands and their use in manipulating and more...

Optimizing Excel 2002 To provide an overview of the calculation, chart-creation, and web-enabled features in Excel 2002 Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel more...

Excel 2003 Formulas and Functions To provide an overview of the calculation features in Excel 2003 Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at core level in the use of Microsoft Excel 2003; end-users seeking basic IT certification such as ECDL, ICDL, IC3, or an equivalent more...

Data Management and Analysis with Excel 2002 The Data Management and Analysis with Excel 2002 WBT is the second course in the Office XP: Excel 2002 curriculum. This course teaches the user how to effectively manage data in Excel and analyse data based on certain functions. The functions dealt with in this course include mathematical, logical, date and time, text, lookup and reference, financial, and statistical functions. Additionally, the more...

Using Advanced Data Management Techniques The Using Advanced Data Management Techniques WBT is the third course in the Office XP: Excel 2002 curriculum. This course teaches the users how to create lists in Excel and manage them by filtering, sorting, subtotaling data, and specifying validation criteria. Additionally, it explains the procedures involved in importing data in Excel from external sources, such as Access databases, text files, more...

ECDL ICDL 4 Module 4 Spreadsheets - Formulas and Functions in Excel 2003 To demonstrate how to use formulas and functions in Excel 2003. Note: the exercise items included with this ECDL-approved training are not ECDL certification tests. See www.ecdl.com for further details. End users wanting to attain competency in using a spreadsheet application; end users wanting to attain competency in using Microsoft Excel 2003; end users wanting to attain an ECDL or ICDL more...