Excel 97 Level 2
Excel
Training
Provided by Online Training Directory
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.
|
|
||||||||||||||||
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 - Workforce and Continuing Ed online courses are offered at basic, intermediate and advanced levels. Going beyond basic training provides a deeper and more educationally rewarding learning experience, especially for students who wish to advance careers or initiate new ones. For the general lifelong learner we continue to offer "fun to learn" single, stand-alone courses.
We look forward to...
