Certification

Microsoft Office Specialist Exam Skill Standards: Excel 2002 Expert

Importing and Exporting Data

• Import data to Microsoft 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 and 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

Back to Microsoft Office Specialist Exams