Online Worksheet eLearning Training

Interval sampling Procedures to select a random interval sample from one of four data sources: 1) text file, 2) database, 3) Excel worksheet, 4) Excel worksheet range. Course is available at http://ezrstats.com/CP/FA6.php.  more...

Common Threads in Office Applications This is the first in a two-part series that examines common threads running through Windows-based commercial office applications. The four aspects analyzed here are: common methods of data entry, application window and toolbar similarities, document window similarities and effective uses of the right mouse button.  more...

Oracle Introduction to Oracle SQL and PL SQL ...hing you many Oracle tools such as the SQL Plus, SQL Plus Worksheet, and Oracle Enterprise Manager. This tutorial will explain how to maintain the Logical Database, and the difference between the Logical Database and the Physical database. You will be guided, in great detail, in the following areas: retrieving, changing, adding, and deleting data from the Database. From there, you will learn  more...

Getting Started with Excel 2000 ... Use Microsoft Excel Help Enter and manage data in a worksheet Copy data to and from other applications Insert columns and rows in a worksheet Insert and create graphic objects Manipulate graphic objects Set various options to work with Excel workbooks Format pages for printing Manage Excel worksheets Navigate in Excel workbooks Link worksheets and  more...

Data Management in Excel 2000 ... course, the student will be able to: Format cells in a worksheet Format data in a worksheet Format data with styles Perform simple calculations on data Write custom formulas Use financial functions to perform calculations Use date and time functions to perform calculations Perform advanced calculations using logical functions Use Lookup functions to perform calculations Sort and  more...

Getting Started With Excel 2003 ...various types of formatting and enhancements to data in a worksheet. After completing this course, the students will be able to: identify the features of Excel 2003 that help in extending workbook capabilities, analyzing data, and sharing information effectively identify Excel 2003 features related to enhanced user experience identify the components of the Excel 2003 interface identify  more...

Managing Worksheets and Customizing Excel 2003 ...Worksheets and Customizing Excel 2003 WBT is the second course in the Excel 2003 curriculum. It teaches the students how to effectively manage worksheets and customize them according to needs in Excel 2003. The tasks involved in managing worksheets and customizing them include navigating within worksheets and workbooks, organizing related information in worksheets, using various search  more...

Getting Started with Excel 2002 ...entify the components of Excel window and enter data in a worksheet. This course also describes various formatting options available in Excel 2002. Finally, users learn how to manage and print Excel files, and customize the appearance of a workbook. After completing this course, students will be able to: Identify the features of Office XP and Excel 2002 Identify the components of the Excel  more...

Data Management and Analysis with Excel 2002 ...he student will be able to: Insert formulas in an Excel worksheet Define and manage cell and range names Use array formulas and array constants Audit formulas Identify and troubleshoot formula errors Use selected mathematical functions Use date and time functions, and specialized date functions Use logical, lookup, and reference functions Use basic text functions in Excel, and  more...

Enhancing and Securing Data ... the advanced features of Excel 2002, that can make their worksheet data more presentable and comprehensible. These features include the use of drawing objects and pictures, and different types of charts. Additionally, this course takes the user through the tasks involved in sharing Excel data with other Office applications, as well as maintaining the security of shared data. After completing  more...

Lotus 1-2-3 R97 Intermediate This intensive course is designed to give existing Lotus 1-2-3 R97 users additional skills and knowledge in the use of the many features and functions of the software, to improve efficiency and effectiveness when working with spreadsheets. This entirely 'hands on' course will give readers a good understanding of spreadsheet production, multiple worksheet working, creation & use of databases and  more...

Microsoft Excel 97 Spreadsheet Basics This course demonstrates how to create, edit, format and print spreadsheets using the MS Excel 97 application. Readers will get hands-on exeprience of creating formulae and functions, using the formatting tools to improve the presentation of data, changing the structure of a worksheet and printing copies.  more...

Microsoft Excel 2003 Introduction This course is designed to help you to obtain the basic skills required to create and use a spreadsheet using Microsoft Excel. You will learn to enter and edit data, create formulas, format elements of a worksheet, and insert charts.  more...

Microsoft Excel XP 2002 Level 1; Introduction Microsoft Excel XP combines a powerful spreadsheet application with the user-friendly atmosphere of Windows. Readers will learn about Excel essentials and how to modify a workbook, manage the worksheet, format a worksheet and print a worksheet/book.  more...

Microsoft Excel 2002 (XP) Intermediate MS Excel 2002 (XP) is the latest version of the popular spreadsheet from Microsoft. This course aims to show the reader how to create more sophisticated worksheets, incorporating advanced formatting options and formulae, charts and graphics. You will also learn to use productivity and time-saving features to speed up the creation of workbooks. The course also demonstrates use of internet features,  more...

Microsoft Excel XP 2002 Level 1; Introduction Microsoft Excel XP combines a powerful spreadsheet application with the user-friendly atmosphere of Windows. Readers will learn about Excel essentials and how to modify a workbook, manage the worksheet, format a worksheet and print a worksheet/book.  more...

Microsoft Excel 2002 (XP) Intermediate MS Excel 2002 (XP) is the latest version of the popular spreadsheet from Microsoft. This course aims to show the reader how to create more sophisticated worksheets, incorporating advanced formatting options and formulae, charts and graphics. You will also learn to use productivity and time-saving features to speed up the creation of workbooks. The course also demonstrates use of internet features,  more...

ECDL Spreadsheets with MS Excel 2002 This course is designed to prepare readers for the ECDL/ICDL module 4 examination. The course will allow readers to create, edit, format, calculate on and print spreadsheets with Microsoft Excel 2002. Readers will get an introduction to worksheet features, using basic functions to create formulae, using format options to present data clearly, creating charts and graphics, and printing. The course  more...