Excel 97 Level 3

Excel

Online Training Directory
This advanced level course introduces the accomplished Excel user to the most powerful aspects of Excel. Some topics that will be covered include adjusting default settings; creating views and custom toolbars; protecting worksheets and applying passwords; and importing data from other applications.
This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
study at homeThis course may be available for home-study
coursewareCourseware may be available for purchase
Self DirectedSelf Directed
Duration:flexible
Training Presented in:English
Training Provided by Online Training Directory
  • Y asked: how do I write into a password protected excel file using coldfusion and eastablishing connection from coldfusion administrator.
Excel 97 Level 3
Excel 97 Level 3


Full Description
PIN code provided for this course allows unlimited on-line access for 90 days. This advanced course introduces the accomplished Excel user to the most powerful aspects of Excel. Some topics that will be covered include adjusting default settings; creating views and custom toolbars; protecting worksheets and applying passwords; understanding add-ins and MS Query; importing and analyzing data from other applications; using the Solver and the Scenario Manager; creating data maps; interpreting PivotTables and establishing custom groups; hiding PivotTable details and changing layouts; understanding and concatenating text strings; using the Text and Case functions; looking up variables; auditing worksheets; troubleshooting worksheets by viewing precedents and tracking cell references; and tracing errors and removing trace arrows.


Outcomes:
Upon completion of this course, students will be able to: --Import data --Work with PivotTables --Work with Solver --Work with scenarios --Use Microsoft Map


Assessment:
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...
Custom Search
tcw11-v473M-10/04/11-20:59:03-()[A]-[B]-[B] -02:13:15