Excel 2002
Excel
Training
Provided by Online Training Directory
This course introduces students to basic spreadsheet features and acquaints them with the tools used in Microsoft Excel 2002. As the course becomes more advanced, students will learn how to customize workbooks by changing worksheet attributes, use lists to store and organize data, use functions in financial and logical formulas, and format worksheets using AutoFormat and predefined styles. Finally, students will learn how to customize the Excel working screen with custom toolbars, menus, and macros.
This course introduces students to basic spreadsheet features and acquaints them with the tools used in Microsoft Excel 2002 through real-life scenarios and projects. The students will learn to manage workbooks, work with cells and cell data, format and print worksheets, and create charts from worksheet data. As the course becomes more advanced, students will learn how to customize workbooks by changing worksheet attributes, use lists to store and organize data, use functions in financial and logical formulas, and format worksheets using AutoFormat and predefined styles.
Students will also learn about summarizing list data with outlining and subtotals, and they will learn how to create and remove custom filters, techniques for working with shared workbooks from changes, track and review changes, and merge and consolidate data from worksheets. Finally, students will learn how to customize the Excel working screen with custom toolbars, menus, and macros.
|
|
||||||||||||||||
Excel 2002
Outcomes
Upon completion of this course, students will be able to: --Customize the Start menu --Enter and edit data --Schedule tasks --Create Word documents --Synchronize a Pocket PC with a computer
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: --Customize the Start menu --Enter and edit data --Schedule tasks --Create Word documents --Synchronize a Pocket PC with a computer
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...
