Course Outline
Excel - Basics
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 basic worksheet functions and formulas and how to work with data in spreadsheets.

• Introduction to Excel
  • Electronic Spreadsheet
  • Database
  • Charting Package
• Explanation of the Excel Screen
• Minimize, Maximize, Restore and Close
• Menu Bar Commands
• Pull-Down Menu Conventions
• Toolbars
• Formula Bar
• Excel Workspace
• Changing the Font and Point Size
• Status Bar
• Excel Mouse Shapes
• Auto Fill Feature
• Moving the Cell Pointer
• Correcting Errors in a Spreadsheet
• Text as Labels
• Numbers as Labels
• Numbers as Values
• Selecting Cells
• Undo Feature
• Ways to Enter Data
• Creating Formulas
  • Addition/Subtraction
  • Multiplication/Division
  • Average
  • Minimum/Maximum
  • Count
     

• The Function Wizard
• Displaying Formulas
• Rules for Entering Formulas
• Help Feature
• Opening a Spreadsheet
• Save As Feature
• Save Vs. Save As
• Switching Between Spreadsheets
• Closing a File
• Changing Column Widths
• Realigning Text Entries
• Changing Text Orientation
• Format Painter Feature
• Centering Text Over Several Columns
• Copying Formulas
• Formatting Numeric Entries
• Inserting/Deleting Columns and Rows
• Printing a Worksheet
• Move Feature
• Copy Feature
• Piggyback Clipboard
• Clearing the Contents of a Cell
• Entering the Current Date
• Exiting Excel