Microsoft Office Specialist Exam Skill Standards: Excel 2003 Expert
Organizing and Analyzing Data
- Use subtotals
- Define and apply advanced filters
- Group and outline data
- Use data validation
- Create and modify list ranges
- Add, show, close, edit, merge, and summarize scenarios
- Perform data analysis using automated tools
- Create PivotTable and PivotChart reports
- Use Lookup and Reference functions
- Use Database functions
- Trace formula precedents, dependents, and errors
- Locate invalid data and formulas
- Watch and evaluate formulas
- Define, modify, and use named ranges
- Structure workbooks using XML
Formatting Data and Content
- Create and modify custom data formats
- Use conditional formatting
- Format and resize graphics
- Format charts and diagrams
Collaborating
- Protect cells, worksheets, and workbooks
- Apply workbook security settings
- Share workbooks
- Merge workbooks
- Track, accept, and reject changes to workbooks
Managing Data and Workbooks
- Import data to Excel
- Export data from Excel
- Publish and edit Web worksheets and workbooks
- Create and edit templates
- Consolidate data
- Define and modify workbook properties
Customizing Excel
- Customize toolbars and menus
- Create, edit, and run macros
- Modify Excel default settings
Back to Microsoft Office Specialist Exams
|
|
