COURSE SEARCH
 
   HOME > COURSES > MICROSOFT EXCEL 97 INTRODUCTION MEMBERS LOGIN 
UNLIMITED ACCESS TO OVER 575 ONLINE TRAINING COURSES FOR ONE ANNUAL PAYMENT OF ONLY $149 USD
BUY NOW
  HOME     COURSE LIBRARY     QUESTIONS & ANSWERS     CONTACT US
There are many excellent online courses. This has been hugely beneficial in my day to day work.
- Louise Nolan


Microsoft Excel 97 Introduction




Course Aims
This course is designed to give you an understanding of some of the major features and functions within Excel and the advantages of using a powerfully integrated spreadsheet running under Windows. The course is entirely 'hands on' and those reading will gain a good basic understanding of how to create and manage spreadsheets, graphics and databases.
Assumed Knowledge
A working knowledge of PCs, a keyboard and mouse plus Windows 95/98/NT is assumed, gained from the workplace or by prior attendance on an "MS Windows 95/98/NT User Introduction" course.
Course Audience
Intending, new or recent users of MS Excel 97 who want to gain a good understanding of the software in a short space of time. This is not a conversion course from Excel 5.0 or 7.0 for Windows.

This course can be found in the following categories:
Courses > Microsoft > Office 97
Courses > Microsoft > Excel

Table of Contents
Introduction to Excel 97
  		• What is a Spreadsheet?
  		• Year 2000
     
    Getting Started
  		• Starting Excel 97
  		• The Excel 97 Opening Screen
  		• The Title Bar
  		• The Menu Bar
  		• Toolbars
  		• Formula Bar and Name Box
  		• Scroll Bars
  		• Active Cell, Column and Row Headers
  		• Sheet Tabs
  		• The Status Bar
  		• Menus and Submenus
  		• SpeedKeys
  		• Dialogue Boxes
  		• Exiting Excel
     
    Getting Assistance
  		• Using the Office Assistant
  		• Other Ways of Getting Assistance
  		• Manipulating the Help Window
  		• Finding Out What is on the Screen
     
    Spreadsheet Basics
  		• Creating a New Workbook
  		• Moving Around the Sheet
  		• Scrolling
  		• The Mouse Pointer
  		• Selecting Cells with the Mouse
  		• Selecting Cells with the Keyboard
  		• Using Go To
  		• Spreadsheet Data Types
  		• Entering and Editing Data
  		• Editing Long Entries
  		• Undoing Incorrect Edits
  		• AutoFill
  		• Custom Lists
  		• Moving Data with Drag-and-Drop
  		• Clearing Data from the Sheet
  		• Saving, Closing, Opening and Deleting a Workbook
     
    Entering Basic Calculations
  		• AutoSum
  		• Entering a Calculation
  		• Statistical Functions
  		• Using Relative and Absolute Cell Addresses
  		• Circular References
    Formatting the Worksheet
  		• The Formatting Toolbar
  		• Enhancements
  		• Alignment
  		• Formatting Numbers
  		• Resizing Columns and Rows
     
    Structuring the Worksheet
  		• Cut, Copy and Paste
  		• Inserting and Deleting Rows and Columns
  		• Inserting and Deleting Worksheets
     
    Printing
  		• Print Preview
  		• Changing the Page Set-up
  		• Printing
     
    Additional Formatting
  		• Adding Borders and Shading
  		• AutoFormats
  		• Copying Formats
  		• Text Formatting
  		• Indented Lists
     
    Advanced Formula Concepts
  		• Preventing Rounding Errors
  		• Conditional Formulae
  		• Worksheet Linking
     
    Working with Multiple Sheets
  		• Opening a Second Workbook
  		• Working with Large Sheets
     
    Additional Features
  		• Protecting the Worksheet
  		• Using Zoom
  		• AutoCorrect
  		• The Spelling Checker
     
    Working with Data Lists
  		• Setting Up Lists
  		• Sorting Lists
  		• Filtering Lists
  		• Using Forms
     
    Charts
  		• Creating Charts
  		• Changing Chart Elements
  		• Changing Chart Data
  		• Printing Charts
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Saturday 19th May 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft