| Details: |
Includes Multimedia CD-ROM. Microsoft Excel XP MOUS/MOS lets you take advantage of
comprehensive tools to create spreadsheets and share them on the Web for universal
viewing and collaboration. You'll be able to easily analyse data with charts,
Microsoft PivotTable views and graphs. And, use automatic formatting to create
data-rich spreadsheets
Employ Excel to, not only enter data in a worksheet, but also to import and
export data into custom templates. Don’t only format cells, but also customise
toolbars, format ranges, filter data, and extract cells from databases. Don’t
just hope you entered cells correctly, audit worksheets and apply analysis tools
to uncover what all those linked workbooks mean. Don’t just print and copy worksheets,
but also record and run macros, collaborate with workgroups, merge and share
whole workbooks
Excel Levels I, II and III - Exam objectives and skill sets for the
Microsoft Excel 2002 Expert Exam are provided below to assist in your exam preparation.
Training centres and courseware providers authorised 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
- Customising Excel, Customise toolbars and menus Create, edit, and run macros
- Auditing Worksheets, Audit formulas Locate and resolve errors Identify dependencies
in formulas
- Summarising 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
- Analysing 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
|
