Excel 97 Level 3
Excel
Training
Provided by 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.
|
|
||||||||||||||||
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 - 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...
