Course Outline
Excel - Intermediate Part I
Versions 97/2000/2002(XP)/2003/2007

Phone:717-560-3552
Fax:717-569-1135
E-Mail: Registrar@pceasy.com

Program Objectives: Students will learn the skills and concepts necessary to create and use three dimensional spreadsheets, use logical formulas, use Excel's database functions, and create charts.

• Excel
  • Electronic Spreadsheet
  • Database
  • Charting Package
• Selecting Cells
• Changing View Modes
• Centering Across Columns
• Numbering Items in a Spreadsheet
• Auto Fill Feature
• Customizing the Auto Fill Feature
• Range Names
  • Moving Around Excel With Their Help
  • Printing With Range Names
  • Building Formulas Using Range Names
• Absolute Reference
• Logical Formulas - =IF
• Conditional Formatting
• Auto Format Feature
• Removing Auto Formatting
• Working With Large Spreadsheets
• Page Breaks
  • Inserting
  • Removing
• Print Title

• Adding Additional Toolbars
• Database Function
  • Setting Up
  • Entering Dates
  • Data Sort
  • Data Find
  • Data Filter
  • Data Filter Customized Formulas
  • Displaying All Records
  • Removing the Auto Filter
• Three-Dimensional Spreadsheets
  • Renaming Sheet Tabs
  • Building Formulas
  • Copying a Sheet
  • Moving a Sheet
  • Inserting a Sheet
  • Deleting a Sheet
  • Linking Sheets Together
  • Unlinking Sheets
• Charting
  • Chart Wizard
  • Enhancing the Chart
  • Enhancement Options
  • Printing the Chart
  • Removing the Chart
• Exiting From Excel