Excel 2000
Excel
Training
Provided by Online Training Directory
This course begins by introducing students to the basic features of Microsoft Excel 2000, including entering text and formulas, moving data, formatting worksheet appearance, and manipulating charts. As students become more advanced, they will be able to work with records and ranges, sort records, outline and filter lists, and import and export data.
This course familiarizes students with the basic features of Microsoft Excel 2000, including entering text and formulas, moving data, formatting worksheet appearance, and manipulating charts. Beginning with opening a workbook, students will progress using the Office Clipboard to cut, copy, and paste items. As the students get more advanced, they will work with lists, databases, and functions; format and link worksheets; and use 3-D references and Microsoft Map. Selected areas of instruction include using AutoCorrect and AutoFormat; understanding, using, and customizing templates; and working with data maps.
Students will also 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. They will also be shown how to merge and link workbooks. In teaching how to share workbooks, the importance of proper management and password protection is stressed.
|
|
||||||||||||||||
Excel 2000
Outcomes
Upon completion of this course, students will be able to: --Manage workbooks --Protect and share workbooks --Work with records and ranges --Format worksheets --Use Excel and the Web
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
Upon completion of this course, students will be able to: --Manage workbooks --Protect and share workbooks --Work with records and ranges --Format worksheets --Use Excel and the Web
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 - 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...
