Microsoft excel 2000 tutorial online training

Online Excel 2000 Tutorial
Info and Order

excell 2000
microsoft exchange
windows 2000
access 2000
word 2000
power point 2000
a+ certification
quickbooks
office
lotus notes
exchange
sql server
java
cisco
focus
exchange server
oracle
novell cne
power builder
html
mcse
visual basic
computer
online computer
MOUS

After completing Excel 2000 MOUS courses the user should be able to:

• Import data from a text file
• Import data from an application
• Import a table from an HTML file
• Query a database
• Export data to an application
• Create a template and apply it to a workbook
• Edit a template
• Use a workspace
• Link workbooks
• Preview and print worksheets
• Use the Report Manager
• Apply accounting currency and number formats to data
• Create a custom number format
• Use and apply conditional formatting
• Sort data
• Generate subtotals
• Group and outline data
• Use a data form for data entry and retrieval
• Create a data filter
• Extract data
• Add and delete a named range
• Use a named range in a formula
• Use lookup functions (HLOOKUP and VLOOKUP)
• Record and run a macro
• Edit a macro
• Assign a macro to a toolbar button
• Hide display and customize toolbars
• Validate data
• Use the Auditing toolbar
• Trace cells referenced in a formula (precedents)
• Trace formulas that depend on contents of a cell (dependents)
• Use Goal Seek to backsolve from a solution to its values
• Use Solver
• Work with scenarios
• Use PivotTables for data analysis
• Use the PivotTable AutoFormat feature
• Create PivotChart reports
• Create an interactive PivotTable for the Web
• Add fields to a PivotTable using a Web browser
• Create edit and remove a comment
• Change workbook properties
• Apply and remove worksheet and workbook protection
• Apply and remove file passwords
• Track and accept or reject changes to a workbook
• Create a shared workbook
• Merge workbooks

This course has the following features:

• Exercises that allow users to explore how a course topic applies to real life
• A file containing the text of the exercises
• Activities that allow users to apply concepts in an interactive questioning environment
• A course index
• A glossary
• A Skill Assessment

All courses are design so that new knowledge and skill assessment will be remembered and retrieved for future use. You can be assured that this high-quality, instructionally-sound online training will enhanced your professional and personal growth, and stimulate job satisfaction.