|
Provided by: Online Training Directory Microsoft Excel 2002 Level 3Excel |
 |
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.
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.
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.
|
|
||||||||||||||
Training
Provided by Online Training Directory
- V asked: i wanna learn macros and pivot table in detail with examples in excel
- I asked: What is the cost? Do you get a certificate?
- R asked: advance learn excel
- R asked: Is this class online or will i have to recieve a cd?
Microsoft Excel 2002 Level 3
Outcomes 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 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 - JER Online (JER Group, Inc.) lists over 1000 , cost affordable, non-credit Courses and Certificates in its own proprietary online catalog. We are always adding "more courses...all the time " to a growing inventory.
The courses and certificates that comprise JER Online s course catalog are developed by (1) JER Online, (2) a growing number of accredited .edu partners and by (3) corporate...
