|
Provided by: Online Training Directory Excel 97 Level 2Excel |
![]() |
This intermediate course introduces students to the more powerful aspects of Excel 97. Some topics that will be covered include working with multiple worksheets; inserting, deleting, and moving worksheets; freezing frames; 3-D references; macros; named ranges; and changing worksheet names.
|
|
||||||||||||||
Training
Provided by Online Training Directory
- N asked: I would like to know how the "online training works", would it be equivalent to a "hands-on" course?
Excel 97 Level 2
Excel 97 Level 2
Full Description
Outcomes:
Assessment:
| PIN code provided for this course allows unlimited on-line access for 90 days. This intermediate course introduces students to the more powerful aspects of Excel 97. Some topics that will be covered include working with multiple worksheets; inserting, deleting, and moving worksheets; changing worksheet names; using Excel’s database features to build, sort, and filter lists of information; freezing frames for increased readability of large worksheets; creating and using 3-D cell references for formulas which access multiple worksheets; creating and using macros; using named ranges as timesavers; creating simple PivotTables; manipulating worksheet data by compiling subtotals; and using the Function Wizard for easy creation of difficult formulas. |
| Upon completion of this course, students will be able to: --Build lists --Use 3-D references --Manipulate data --Create macros --Use timesavers |
| Student performance is assessed by cumulative training time, number of lessons completed and, where tests are available, the percent correct. Many courses also have a pre- and post-test where the pre-test will automatically assign only the lessons needed to achieve course mastery. |
Contact Hours: 24
About The Training Provider: Online Training Directory
Online Training Directory - JER Online (JER Group, Inc.) lists over 1000 , cost affordable, non-credit Courses and Certificates in its own proprietary online catalog. We are always adding "more courses...all the time " to a growing inventory.
The courses and certificates that comprise JER Online s course catalog are developed by (1) JER Online, (2) a growing number of accredited .edu partners and by (3) corporate...

