Course Outline: Microsoft Excel 2003

MODULE 1

• The Excel Environment
• Formatting Your Worksheets
  
• Managing Workbooks
• Formatting Cells
• Working with Rows and Columns
  
• importing an external data file
  
• Using the fill command
  
• Hiding Columns, Rows and Cells
  

MODULE 2

• Writing Formulas and Functions with the point Method
  
• Modifying Header and Footer Information
  
• Protecting Your Worksheet
  
• Organizing Worksheets

MODULE 3

• Database Basics
  
• Establishing Criteria
  
• Filtering Your Database
  
• Analyzing Your Database With Functions

MODULE 4

• About Charting
• Guide lines for Charting
• Creating a basic Chart
• Formatting Your Chart
• Working with Chart elements
• Creating Exploding Pie Charts
• 
  MODULE 5
  
• Printing Basics
• Using Printing Options
• Customizing Page Layout