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
|
|
|
