Microsoft Excel

Microsoft Excel
2000 Training
Info and Order

Access
Excel
Excel 2000
Word
Word 2000
PowerPoint
Office 2000
Office 97
A+ Certification
MCSE Certification
MOUS Certification
A+ Training
Exchange Server
IIS4 Training
SQL Server
TCP/IP Training
Windows NT
Windows 2000
Windows 2000 Server
Cisco CCNA
Cisco CCDA
Oracle 8i
E-Commerce
Novel
Lotus Notes
Visual Basic
Java
HTML
Visual InterDev
PowerBuilder
FOCUS
UNIX
Sybase
PhotoShop
S.A.S.
QuickBooks
MS Works
Estate Planning
Interview Skils
Investing
Resumess Writing
Home Business
Management

This course is for anyone preparing for the MOUS Excel 2000 Expert certification exam.

• Working with Cells shows how to enter and edit data in worksheet cells and how to create hyperlinks.
• Working with Files shows how to locate, open, and save files.
• Formatting Worksheets shows how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an worksheet.
• Page Setup and Printing shows how to preview and print worksheets and workbooks; add headers, footers, and titles, and adjust page settings in worksheets.
• Worksheets & Workbooks shows how to work with worksheet rows and columns, manage worksheets, and consolidate data in worksheets.
• Formulas and Functions shows how to work with formulas and functions in worksheets.
• Charts and Objects shows how to create, modify, and print charts; insert, move and delete pictures, and draw lines and shapes in worksheets.
• Importing and Exporting Data shows users how to import data from other applications into Excel, query a database application to extract data, and export data from Excel to other applications.
• Working with Templates, Links, and Report Manager shows the user how to work with templates, link workbooks, and use Report Manager.
• Formatting, Sorting, and Filtering Data shows users how to format numeric data, create custom and conditional formats, sort and group data, use data forms for data entry and retrieval, and use filters to extract data.
• Naming Ranges, Working with Macros, and Customizing Toolbars shows users how to create and use named ranges, and how to use lookup functions. It also shows how to record, run, and edit a macro, as well as hide, display, and customize toolbars.
• Validating and Auditing Data shows users how to validate data, trace and fix errors, trace precedents for a formula, and trace dependents for a specific cell.
• Analyzing Data and Using PivotTables shows users how to use data analysis tools such as Goal Seek, Solver, and scenarios. It also shows how to use PivotTables and PivotCharts.
• Sharing Work and Adding Security shows users how to work with cell comments, apply workbook protection, and share and merge workbooks.

After completing our 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

A typical course has the following features:

• Exercises that allow users to practice
• A file containing the text of the exercises
• Simulations that allow users to practice course skills, even if they don't have access to Excel 2000
• A course index
• A glossary
• A Skill Assessment

All courses are included in PC Desktop Pack and PC Business Pack.