|
Provided by: Online Training Directory Excel 97 Level 3Excel |
 |
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.
|
|
||||||||||||||
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
Outcomes:
Assessment:
| 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. |
| Upon completion of this course, students will be able to: --Import data --Work with PivotTables --Work with Solver --Work with scenarios --Use Microsoft Map |
| 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...
