Microsoft Office XP Excel 2002 Training
Computer Based Training (CBT) and Videos

Our instructor-based, interactive learning system will guide you through this powerful program and show you how to utilize all of the tools contained within the world's most popular spreadsheet program. We guarantee it!

Microsoft Office XP Excel 2002 Expert

Microsoft certification training is provided as Computer Based Training which is a cost effective method that meets the critical demands of computer users. We give you the experience of expert-led computer training courses for your convenience. You get the feel of a computer training school delivered through flexible and familiar technology.

Microsoft Excel XP training comes to life with our full motion video, challenging labs, critical assessment and real-world insight from experts with vast experience in the subject matter. Our instructor-based, interactive learning system will guide you through this powerful program and show you how to utilize all of the tools contained within the world's most popular database program. We guarantee it! Our proven methodology provides an unequalled training experience with exceptional results.

Microsoft Office Specialist (MOS) MOUS Certification Training Exam Objectives
and skill sets for the Microsoft Excel 2002 Expert Exam are provided below to assist in your exam preparation.

Microsoft Excel XP Exam Objectives

Exam objectives and skill sets for the Microsoft Excel 2002 Expert Exam are provided below to assist in your exam preparation. Training centers and courseware providers authorized by the Microsoft Office Specialist (Office Specialist) program tailor their instruction to these criteria.

Importing and Exporting Data

• Import data to Excel
• Export data from Excel
• Publish worksheets and workbooks to the Web

  Managing Workbooks

• Create, edit, and apply templates
• Create workspaces
• Use data consolidation

  Formatting Numbers

• Create and apply custom number formats
• Use conditional formats

  Working with Ranges

• Use named ranges in formulas
• Use Lookup and Reference functions

  Customizing Excel

• Customize toolbars and menus
• Create, edit, and run macros

  Auditing Worksheets

• Audit formulas
• Locate and resolve errors
• Identify dependencies in formulas

  Summarizing Data

• Use subtotals with lists and ranges
• Define and apply filters
• Add group and outline criteria to ranges
• Use data validation
• Retrieve external data and create queries
• Create Extensible Markup Language (XML) Web queries

  Analyzing Data

• Create a Microsoft PivotTable, Microsoft PivotChart, and PivotTable/PivotChart
• Reports
• Forecast values with what-if analysis
• Create and display scenarios

  Workgroup Collaboration

• Modify passwords, protections, and properties
• Create a shared workbook
• Track, accept and reject changes to workbooks
• Merge workbooks
  
  
  

  Microsoft EXCEL® - Microsoft Excel 2002 Training Course
  Includes: 3 Interactive CD-ROMs or 3 Video Training Tapes!
  Excel® CD-ROMs - Order Online $129.00	#82400CD CD-ROM Training -
  Excel® Videotapes - Order Online $129.00	#82400 Videotapes Training -

  
  

  See the entire Office XP 2002 (MOS-XP) course !

Order with complete confidence, all Order pages... 

Aaron's Computer Training is your online source for MCSE and A+ Certification computer training courses. We also offer a complete suite of computer training certification beyond A+ and MCSE Certification. Some of our most popular classes are: Microsoft Office, MOUS, Linux, and Oracle.

Other popular computer certification training: MCSE Security+ Linux+ Oracle8iR2 A+ Certification Network+ i-Net+ MCSA Core CDIA Microsoft Office MOUS

Call for Orders or Questions:  1-800-617-5586 Toll Free !
Customer Service Hours: 9:00am-5:00pm, eastern time, Monday - Friday
aarons@aarons-computer-training.com