Microsoft Excel 2002 Level 3
Excel
Training
Provided by Online Training Directory
This course teaches students a set of expert-level spreadsheet features. Some skills students will acquire are summarizing list data with outlining and subtotals; customizing the Excel working screen with custom toolbars, menus, and macros; and creating and removing custom filters.
|
|
||||||||||||||||
Microsoft Excel 2002 Level 3
Microsoft Excel 2002 Level 3
Full Description
Outcomes:
Assessment:
| PIN code provided for this course allows unlimited on-line access for 90 days. This course teaches students a set of expert-level spreadsheet features. Students will 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, including protecting 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. The material is presented through explanatory text, real-world scenarios, interactive steps, and questions to test and reinforce the material covered. |
| Upon completion of this course, students will be able to: --Work with named ranges --Import and export data --Use PivotTables and PivotCharts --Audit and analyze worksheets --Summarize data |
| 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...
