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