|
Find out if you are eligible for FREE training
|
Excel 2003/2007
Microsoft
Office Excel 2003/2007
Updated: July 9, 2007
|
Skill Sets
|
Exam Skill Standards
|
|
Creating Data and Content
|
|
•
|
Enter and edit cell content
|
|
•
|
Locate specific cell content
|
|
•
|
Locate, select, and insert supporting
information
|
|
•
|
Insert, position, and size graphics
|
|
|
Analyzing Data
|
|
•
|
Filter lists using the AutoFilter
feature
|
|
•
|
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
|
|
|
Collaborating
|
|
•
|
Insert, view, and edit comments
|
|
|
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
|
|
|
|
