Welcome to Microsoft
Excel XP training! Your complete Excel XP tutorial training
on CD, video or online. The 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.
Microsoft
Excel XP 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. The 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! The proven methodology provides an unequalled training
experience with exceptional results.
Microsoft Office
Specialist (MOS) Certification Training Exam Objectives and
skill sets for the Microsoft Excel 2002 Expert Exam are provided
below to assist in your exam preparation.
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 Mark-up 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
Click
Here For The Cheapest Price
