Training
Provided by Online Training Directory
Students will learn how to apply the advanced features of Microsoft Excel 2000 to work with records and ranges, sort records, outline and filter lists, and import and export data. The importance of proper management and password protection is also stressed.
Training Avaliability and Delivery
| This is primarily online training |  | This is an online eLearning or CBT training program |  | This course may be available for home-study |  | Courseware may be available for purchase |  | Self Directed |  | Contact Online Training Directory for more information |
|
| Schedule: | flexible | | Training Presented in: | English |
|
Related Keywords:
access
excel
word
powerpoint
office
computing
Training Program Details
| PIN code provided for this course allows unlimited on-line access for 90 days. Students will learn how to apply the advanced features of Microsoft Excel 2000 to work with records and ranges, sort records, outline and filter lists, and import and export data. In addition, students will be taught how to use PivotTables, PivotCharts, and data analysis tools and how to merge and link workbooks. In teaching how to share workbooks, the importance of proper management and password protection is stressed.
|
|
Upon completion of this course, students will be able to: --Use data forms and named ranges --Apply data filters and use macros --Import and export data to and from databases and HTML --Use data analysis tools like solver, scenarios, and goal seek --Protect, share, and manage workbooks |
|
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 Online Training Directory - Training Provider
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...
More Excel Training from Online Training Directory
Click here for more information or to take this course
|