Creating Data and Content

• Worksheet Basics
• Enter and edit cell content
• Navigate to specific cell content
• Locate, select, and insert supporting information
• Insert, position, and size graphics

Analyzing Data

• Filter lists using AutoFilter
• Sort lists
• Insert and modify formulas
• Use statistical, date and time, financial, and logical functions
• Create, modify, and position diagrams and charts based on worksheet data

Formatting Data and Content

• Apply and modify cell formats
• Apply and modify cell styles
• Modify row and column formats
• Format worksheets

Managing Workbooks

• Create new workbooks from templates
• Insert, delete, and move cells
• Create and modify hyperlinks
• Organize worksheets
• Preview data in other views
• Customize Window layout
• Setup pages for printing
• Print data
• Organize workbooks using file folders
• Save data in appropriate formats for different uses

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

• Insert, view, and edit comments
• Protect cells, worksheets, and workbooks
• Apply File 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

Apply for Certification