Microsoft Excel 2000 Advanced Training

Course List
Specials
Site Map
Free Training Tutorials
MOUS Certification




Computer Training Courses Catalog
(PDF Format)

You will receive Unlimited Access to all of the Excel 2000 MOS Expert tutorials listed below. Your online training courses will be available from anywhere you have internet access.

Summary:

This series is designed to help users prepare for the MOS Excel 2000 Expert examination. It covers expert-level Excel topics such as importing and exporting data, working with templates, linking workbooks, and using the Report Manager. It also covers advanced worksheet formatting, including page setup and printing, and sorting and filtering data. More advanced topics covered include ranges, macros and customization, validating and auditing data, and creating and using charts, graphs, and pivot tables. Data analysis, file sharing, and security issues are also discussed.

This e-learning computer training series includes all of the online training tutorials listed below and is provided in an interactive e-learning format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 1 year unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit .

StaffKit is an e-learning leader in providing computer training tutorials and online education. We have satisifed online learning customers in over 40 countries.

Certification: MOUS / MOS Microsoft Office Certification

Includes:

Microsoft Excel 2000 Advanced Importing / Exporting Data

• 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
• Apply a template to a workbook
• Edit a template
• Use a workspace
• Link workbooks
• Preview worksheets
• 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 a macro
• Run a macro
• Edit a macro
• Assign a macro to a toolbar button
• Hide and display toolbars
• Customize a toolbar

• 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 the Web browser

• Create, edit, and remove a cell comment
• Change workbook properties
• Apply and remove worksheet and workbook protection
• Apply and remove file passwords
• Track changes
• Create a shared workbook
• Merge workbooks

Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 1 year unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit CEU credit.


Questions about Excel 2000 MOS Expert? We now offer 24x7 online support with access to real live experts! Get answers from real experts within minutes via our online chat service. For just $30.00 additional you add our Instant Mentoring service and get your Excel 2000 MOS Expert questions quickly answered anytime from anywhere.

Excel 2000 MOS Expert... ... $29.95
Excel 2000 MOS Expert + 1 Year Instant Mentoring... ... $59.95

You might also be interested in our Desktop Computing Package which includes all of the Excel 2000 MOS Advanced training courses listed above plus over 890 hours of additional courses.

About Us News Contact Us Features Certification

Reviews:

"this is a must have resource"
TheTechMag.com

"this is the Ultimate Career Development Package."
MidWest Technology Journal

Great Service and Excellent Training Product - Great People
Kenosha, WI

Excellent program, this is a real winner. Thanks. A+
Arlington, TX

Read more customer reviews about our e-learning training tutorials.