Course Outline
Excel - Intermediate Part II
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 protect worksheets, dress them up, manipulate dates, and create and use macros.

• Introduction to the Course
• Opening Multiple Files
• Displaying Formulas on Your Screen
• Password Protection for Files
• Protecting Your Worksheet
  • Adding the Lock Cell Button
  • Unlocking Cells
  • Protecting the Sheet
  • Unprotecting the Sheet
• Range Names
  • Moving Around Excel
  • Changing a Range Definition
  • Creating a Table
• Page Setup Options
• Printing
  • Automatic Compression
  • Changing Paper Size
  • Headers and/or Footers
  • Gridlines or Row/Column Headings
  • Changing Page Order
  • Print Titles
  • Saving Settings in Default Template
• Splitting Windows
• Setting Views
• Calculating Percentages
• Formatting Zero Values
• Dates
  • Entering the Current Date
  • Entering the System Date and Time

• Dates - Continued
  • Choosing Additional Date Formats
  • Entering Dates
• Fill Series Feature
• Using Ctrl-Fill
• Using Fill Justify
• Manual Recalculation
• Auto Save Feature
• Sharing Excel Data Within Windows
• Linking Data from the Clipboard
• Inserting Graphics
• Find and Replace Feature
• Hiding Columns
• Unhiding Columns
• Enhancing File Appearance
• Adding Color to Your Text
• Adding Background Color
• Adding Shading
• Adding Borders
• Font Enhancements
• Wrapping Text with a Cell
• Using the Format Painter
• Removing Formatting from a Cell
• Using the Drawing Tools
• Using the Text Box Feature
• Drawing Features
• Cell Notes (Comments)
• Range Value
• Macros
  • Recording
  • Viewing the Visual Basic Code
  • Running
• Exiting From Excel