Microsoft Excel 2002 Training Course

Training Course Outline

• Getting Started
  • Identify What You Can Do with Excel
  • Enter Data in a Worksheet
  • Edit Data
  • Change the Appearance of Data
  • Save a Workbook
  • Obtain Help
• Editing Your Worksheet
  • Moving Data to Other Cells
  • Copy Data to Other Cells
  • Fill Cells with a Series of Data
  • Insert and Delete Rows and Columns
  • Undo and Redo an Entry
  • Find and Replace Numbers
  • Enter Data in a Range
  • Verify Data in a Range
• Performing Calculations
  • Sum a Range of Data
  • Use a Built-in Function
  • Copy a Formula
  • Create an Absolute Reference
• Formatting
  • Specify Number Formats
  • Create a Custom Number Format
  • Change Font Size and Type
  • Apply Styles
  • Add Borders and Color to Cells
  • Find and Replace Formats
  • Change Column Width and Row Height
  • Align Cell Contents
  • Merge and Center Cells
  • Apply an AutoFormat
• Working with Multiple Worksheets
  • Format Worksheet Tabs
  • Reposition Worksheets in a Workbook
  • Copy Worksheets
  • Change the Number of Worksheets
• Creating and Modifying Charts
  • Create a Chart
  • Modify Chart Items
  • Format a Chart
  • Change the Chart Type
• Setting Page Display and Printing Options
  • Freeze Rows and Columns
  • Set Print Title
  • Set Page Margins
  • Create a Header and Footer
  • Change Page Orientation
  • Insert and Remove Page Breaks
  • Print a Range

To see more details as to our East Anglian Training Venues click one of the links below:

Cambridge | Milton Keynes | Norwich | Peterborough | Luton | Ipswich