COURSE SEARCH
 
   HOME > COURSES > MICROSOFT EXCEL 97 SPREADSHEET BASICS 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 Spreadsheet Basics




Course Aims
This course demonstrates how to create, edit, format and print spreadsheets using the MS Excel 97 application. Readers will get hands-on exeprience of creating formulae and functions, using the formatting tools to improve the presentation of data, changing the structure of a worksheet and printing copies.
Assumed Knowledge
A basic understanding of PCs, familiarity with the layout of a standard keyboard plus knowledge of MS Windows is required, gained either by previous experience or by attendance on a "Using the Computer and Managing Files" course.
Course Audience
Intending, new or recent users of MS Excel 97 who want to get to grips with the basics of this package in a short space of time.

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

Table of Contents
Spreadsheet Basics
  		• Spreadsheet Basics
     
    Getting Started
  		• What is a Spreadsheet?
  		• Year 2000
  		• 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
  		• Dialogue Box Elements
  		• Exiting Excel
  		• Getting Started with Excel 97
     
    Getting Assistance
  		• Using the Office Assistant
  		• Other Ways of Getting Assistance
  		• Manipulating the Help Window
  		• Finding Out What is on the Screen
  		• Getting Help
     
    Creating Workbooks
  		• 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
  		• Moving Data with Drag-and-Drop
  		• Clearing Data from the Sheet
  		• Saving a Workbook
  		• Closing a Workbook
  		• Opening a Workbook
  		• Deleting a Workbook
  		• Entering Data
     
    Entering Basic Calculations
  		• AutoSum
  		• Entering a Calculation
  		• Statistical Functions
  		• Using Relative and Absolute Cell Addresses
  		• Circular References
  		• Adding Formulae
    Formatting the Worksheet
  		• The Formatting Toolbar
  		• Enhancements
  		• Alignment
  		• Formatting Numbers
  		• Resizing Columns and Rows
  		• Formatting the Worksheet
     
    Structuring the Worksheet
  		• Cut, Copy and Paste
  		• Moving Entries (Cut and Paste)
  		• Copying Cell Contents (Copy and Paste)
  		• Inserting and Deleting Rows and Columns
  		• Inserting and Deleting Worksheets
  		• Sorting Data
  		• Structuring the Worksheet
  		• Adding Worksheets
  		• Sorting Data
     
    Printing
  		• Print Preview
  		• Changing the Page Setup
  		• Printing
  		• Page Layout and Printing
  		• Printing
     
    Working with Multiple Sheets
  		• Worksheet Linking
  		• Preventing Rounding Errors
  		• Opening a Second Workbook
  		• Working with Large Sheets
  		• Using Paste Special
  		• Object Linking and Embedding
  		• Using Functions
  		• Working with Large Worksheets
  		• Working with Multiple Worksheets
     
    Charts and Graphics
  		• Creating Charts
  		• Printing Charts
  		• Using the Drawing Tools
  		• Inserting WordArt
  		• Inserting Clip Art
  		• Charting
  		• Adding Graphics
     
    Year 2000 Best Practices
  		• Year 2000 Best Practices
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Monday 21st May 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft