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 2000 Advanced Training

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

Microsoft Excel 2000 Advanced Training covers topics such as

Using conditional formatting
Working with named ranges
Auditing a worksheet
Using analysis tools
Collaborating with workgroups

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

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 2000 Advanced Training prepares you for the Microsoft Office User Specialist (MOUS) certification exam.

Microsoft Excel 2000 Advanced Training includes both basic and advanced Excel 2000 courses.

Excel 2000 Advanced Training

Course Objectives
After completing these Learning Objects, the learner will be able to perform tasks such as:
» Importing and exporting data » Using templates
» Using multiple workbooks » Printing workbooks
» Working with named ranges » Working with toolbars
» Using macros » Auditing worksheets
» Displaying and formatting data » Using analysis tools
» Collaborating with workgroups
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 2000 Training will provide the learner with the skills necessary to achieve an expert
level of proficiency with Microsoft Excel 2000, Microsoft's powerful spreadsheet program. It is
also excellent preparation for the Microsoft Office User Specialist (MOUS) certification exam.
Audience Definition
Designed for learners who have successfully completed Microsoft Excel Core Training and wish
to continue to a more advanced level of training.
Prerequisites
Microsoft Excel Core Training, or a thorough familiarity with the basic features of Excel 2000.
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 Multiple Workbooks
Using Templates
Formatting Numbers
Using Conditional Formatting
Printing
Working with Named Ranges
Working with Toolbars
Using Macros
Auditing a Worksheet
Displaying Data
Formatting Data
Using Analysis Tools
Using Pivot Tables
Using Editing Tools
Collaborating with Workgroups
Using Goal Seek and Solver

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 objectives in the following Learning Objects cover the Microsoft Office User Specialist
(MOUS) Advanced requirements.
Importing and Exporting Data
» Import data from text files
» Import from other applications
» Import a table from an HTML file
» Export to other applications
Using Multiple Workbooks
» Link workbooks
» Create a workspace
Using Templates
» Create templates
» Apply templates
» Edit templates
Formatting Numbers
» Apply built-in number formats
» Create custom number formats
Using Conditional Formatting
» Use conditional formatting with numbers
» Apply conditional formats
Printing
» Print and preview multiple worksheets
» Use the Report Manager
Working with Named Ranges
» Add and delete a named range
» Use a named range in a formula
» Use Lookup functions
Working with Toolbars
» Hide and display toolbars
» Customize a toolbar
» Assign a macro to a command button
Using Macros
» Record a macro
» Run a macro
» Edit a macro
Auditing a Worksheet
» Use the Auditing toolbar
» Trace errors in a worksheet
» Trace cells that provide data to a formula
» Trace cells that depend on data from a cell
Displaying Data
» Perform single and multi-level sorts to organize data
» Use grouping and outlining to summarize data
» Add subtotals to a list of data
» Query external databases
Formatting Data
» Use data forms to assist data entry
» Apply data validation rules to a range of cells
» Use data filters to focus on specific data on a worksheet
Using Analysis Tools
» Create PivotChart reports
» Work with scenarios
Using Pivot Tables
» Use PivotTable AutoFormat
» Use data analysis and PivotTables
» Create interactive PivotTables for the Web
Using Editing Tools
» Create, edit, and remove comments
» Track changes in an Excel workbook
Collaborating with Workgroups
» Apply and remove worksheet and workbook protection
» Change workbook properties
» Apply and remove file passwords
» Create a shared workbook
» Merge workbooks
Using Goal Seek and Solver
» Use Goal Seek
» Use Solver