Excel 97

Introduction to Excel 97:

• 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.
• File Management

• Setting Column Widths.
• The Formatting Commands.
• Text Formatting
• Formatting Numeric Figures.
• Changing Fonts and Attributes.
• Inserting & Deleting Rows & Columns.
• Adding & Centring a Title.
• Adding Borders & Shading.
• Working with Multiple Sheets.
• 3D Ranges and Cell Formulae.

• Selecting Columns And Rows
• Entering Data.
• Formulae.
• Editing Data.
• Entering Formulas.
• Copying Cells.
• Adding to a Worksheet.
• The Sum Function.
• Copying and Pasting.

• Creating Charts.
• The Chart Wizard.
• Editing Charts.
• Printing your Spreadsheet.
• Getting Help.

Intermediate Excel 97:

• 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.

Advanced Excel 97:

• The Concepts of a Database
• A Database Management System
• Excel’s Database List Structure
• Creating a Database
• Edit Fields and Records
• Add Records
• Delete Records
• Finding Records
• Sort Records

• Custom Lists
• Customising AutoFill
• Exercise; Building Custom Number Formats
• Array Formulas
• User defined Functions
• Globally Available User-Defined Functions
• The Excel Macro Recorder
• Exercise 1: Recording a Macro
• Exercise 2: Running a Macro

• Data Extraction
• The Advanced Filter
• Using the Top 10 Feature
• Copying Filtered Data to Another Location
• Statistical Functions
• Combining Extraction with Statistics

• Pivot Tables
• Pivot Table Example
• Pivot Table Toolbar

• The Lookup Function
• Vlookup
• The One Input Table
• The Two Input Table

Excel 97 Macros

• Introduction
• Demonstration
• Recording a macro
• Recording a macro with absolute references
• The personal macro workbook
• Assigning shortcut keys
• Deleting macros
• Recording a macro with relative references
• Exercises

• Introduction to objects
• The object browser
• Using the object browser and searching it
• Built-in dialog boxes
• User defined dialog boxes (message boxes and input boxes)
• Exercises

2: Creating and Editing Macros With VBA Macro Functions

• Macro storage concepts
• The VBA program (the VB editor)
• The program components
• Storing and handling macros (modules)
• Introduction to editing code
• Copying and pasting procedures
• Linking procedures together
• Create and use a user-defined function
• Auto-executable macros
• Exercises

• Assigning macros to toolbar buttons (icons)
• Customising the excel screen
• Worksheet controls
• User forms
• Exercises
• Custom menus