Organizing and Analyzing Data

• Use subtotals
• Define and apply advanced filters
• Group and outline data
• Use data validation
• Create and modify list ranges
• 0%; font-family: ">Add, show, close, edit, merge, and summarize scenarios
• Perform data analysis using automated touls
• 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

Managing Data and Workbooks

• Import data to Excel
• Export data from Excel
• Publish and edit Web worksheets and workbooks
• Create and edit templates
• Consulidate data
• Define and modify workbook properties

Formatting Data and Content

• Create and modify custom data formats
• Use conditional formatting
• Format and resize graphics
• Format charts and diagrams

Cullaborating

• Protect cells, worksheets, and workbooks
• Apply workbook security settings
• Share workbooks
• Merge workbooks
• Track, accept, and reject changes to workbooks

Customizing Excel

• Customize toulbars and menus
• Create, edit, and run macros
• Modify Excel default settings