Excel v7

Introduction to Excel v7:

• What is an Electronic Spreadsheet?
• What is Excel?
• Spreadsheet Terminology.
• Start Excel.
• The Excel Window & Screen.
• The Working Window.
• Moving Around the Sheet.
• Create A Simple Spreadsheet.
• Save & Close Your Spreadsheet.
• Retrieve Your File.
• Exit Excel.
• Summary of Useful Keys

• Setting Column Widths.
• The Formatting Commands.
• Aligning Cell Contents.
• Formatting Numeric Figures.
• Changing Fonts and Attributes.
• Inserting & Deleting Rows & Columns.
• Adding & Centring a Title.
• Adding Borders & Shading.
• Using the Format Painter.
• Using the Autoformat Command.

• The Excel Menus.
• Entering Data.
• Formulas.
• Editing Data.
• Entering Formulas.
• Copying Cells.
• Adding to a Worksheet.
• The Sum Function.
• Create a New Spreadsheet.

• Preview a Worksheet.
• Centring & Scaling a Worksheet.
• Print Row Headings & Gridlines.
• Headers & Footers.
• Print a Worksheet.
• Print a Selection.
• Print Column & Row Titles.

Intermediate Excel v7:

• What is an Electronic Spreadsheet?
• Relative and Absolute Addresses
• Absolute Addresses.
• The Different Protection Modes.
• Full Protection Using a Password
• Sheet Protection - Read Only
• Protection of Cells or Ranges

• The Chart Facility.
• Chart Types.
• The Chart Wizard.
• Create a Chart.
• Modify a Chart.
• Print a Chart.

• Worksheet Functions.
• The Function Wizard.
• Function Syntax.
• Mathematical Functions.
• Date Functions.
• Statistical Functions.
• Logical Functions.
• Range Names

• The Workbook Concept.
• File Linking.
• Create a Workbook.
• Copying Data across the Workbook.
• Entering Formulas in a Workbook.
• Linking Sheets in a Workbook.
• Link Files.

Excel v7 - New Features:

• Answer Wizard
• AutoCalculate
• AutoComplete
• AutoCorrect
• AutoFilter with Top Ten
• Drag and Drop Editing

2: New Features (ii) 

Macro Functions

• Cell Tips
• Scroll Tips
• Data Map
• Document retrieval and management
• Number formatting
• Shared Lists