Everything Desktop Training

Our curriculum combines proven instructional design techniques, realistic simulation and unparalleled interactivity with challenges, tests and feedback. Master the world's leading productivity tools today

Microsoft Excel 2002 Advanced Training

Excel 2002 Training provides the learner with the skills necessary to achieve an expert level of proficiency with Microsoft Excel 2002, Microsoft's powerful spreadsheet program. It is also excellent preparation for the Microsoft Office User Specialist (MOUS) certification exam.

Microsoft Excel 2002 Advanced Training covers topics such as

Using templates
Working with named ranges
Auditing a worksheet
Importing and exporting data
Collaborating with workgroups

Demystify the world's leading spreadsheet application, Microsoft Excel 2002. Our in-depth, easy-to-follow courses lead you through common tasks using a clear, step-by-step approach. Microsoft Excel 2002 Advanced Training takes the guesswork out of using Excel 2002.

Learn exactly what you need to know with our interactive multimedia courseware. Our animations and simulations teach fundamental techniques and let you apply what you have learned in a realistic application environment. Microsoft Excel 2002 Advanced Training prepares you for the Microsoft Office User Specialist (MOUS) certification exam.

Microsoft Excel 2002 Training includes both basic and advanced Excel 2002 courses

Excel 2002 Advanced Training

Course Objectives
After completing these Learning Objects, the learner will be able to perform tasks such as:
» Summarizing and sharing data
» Editing and merging workbooks
» Working with ranges and formatting numbers
» Merging Workbooks
Media Selection
Contextual Simulations: 51 Audio: Yes
Graphics display the user interface and key concepts
Rollovers let users interact with and view supplemental information
Animations illustrate processes
Advanced simulation technology allows users to practice skills and gauge their proficiency
Course Description
Excel 2002 Advanced Training provides the learner with the advanced skills necessary to
master Excel 2002, Microsoft's powerful spreadsheet program. It is also excellent preparation
for the Microsoft Office User Specialist (MOUS) certification exam.
Audience Definition
Designed for experienced users of Microsoft Excel 2002 who want to move to an
advanced level of proficiency.
Prerequisites
A thorough knowledge of Microsoft Excel 2002.
Estimated Length
Each Learning Object is approximately 15-20 minutes in duration with a total
approximate time of 5.5 hours.
Course Outline
Importing and Exporting Data
Using Templates
Working with Ranges
Formatting Numbers
Using Multiple Workbooks and Worksheets
Customizing Menus and Toolbars
Using Macros
Auditing a Worksheet
Summarizing Data
Sharing Excel Data
Analyzing Data
Using PivotTables and PivotCharts
Cooperating with Workgroups
Using Editing Tools and Merging Workbooks
Using What-If Analysis to Forecast Values

Assessment Description
Pre-assessment Challenge
(3-4 standard questions and a performance-based simulation)
Lesson Review
(2 standard questions)
Final Test
(3-4 standard questions and a performance-based simulation)
Detailed Course Outline and Objectives
The following learning objectives cover the Microsoft Office User Specialist (MOUS) requirements.
Importing and Exporting Data
» Import data from an external source
» Import a table from a Web page
» Export data to other applications
Using Templates
» Create a workbook template
» Edit a workbook template
» Create a workbook from a user-defined template
Working with Ranges
» Name one or more pages
» Used named ranges in formulas
» Use Lookup and Reference functions
Formatting Numbers
» Create custom number formats
» Apply conditional formats to numbers
Using Multiple Workbooks and Worksheets
» Create a workspace
» Consolidate data
Customizing Menus and Toolbars
» Add and remove custom menus
» Add and remove buttons from toolbars
Using Macros
» Create macros
» Edit macros
» Run macros
Excel 2002 Advanced Training Product Description
Auditing a Worksheet
» Trace dependents and precedents in formulas
» Locate errors in formulas
» Remove tracer arrows
Summarizing Data
» Add subtotals to worksheets
» Use grouping and outlining to summarize data
» Create and apply custom filters
» Apply data validation rules to cells
Sharing Excel Data
» Publish an Excel worksheet as a Web page
» Use XML to share Excel data on the Web
» Create XML queries
Analyzing Data
» Add a trend line to a chart
» Work with scenarios
Using PivotTables and PivotCharts
» Create a PivotTable report
» Create a PivotChart report
Cooperating with Workgroups
» Add cell protection
» Apply worksheet protection
» Apply workbook protection
» Create a shared workbook
Using Editing Tools and Merging Workbooks
» Track changes
» Accept and reject changes
» Merge workbooks
Using What-If Analysis to Forecast Values
» Use Goal Seek
» Use Solver