Microsoft Excel Core 2003 Course Outline

Creating Data and Content

• 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 and sort list
• 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 and styles
• Modify row and column formats
• Format worksheets

Collaborating

• Insert, view, and edit comments

Managing Workbooks

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