Training Materials for:
  Windows Vista 
  Windows 2000 / XP 
  Microsoft Word
  Microsoft Excel
  PowerPoint XP
  Microsoft Access
  Internet Explorer
  Outlook
  Expression Web
  Microsoft Project
  Microsoft Publisher
  Microsoft FrontPage
  Microsoft Visio
  Computer Concepts

  ECDL / ICDL Downloads
     
      PLUS MANY MORE ...

Microsoft Excel 95
Foundation Level Training Course

Training Course Outline

1. A first look at Excel 95

• The advantages of using Excel 95
• What are workbooks and worksheets?
• Creating and opening workbooks
• Entering data
• Further data entry techniques
• Autocorrect
• Navigating in the worksheet
• Naming cells and ranges
• Selecting items within Excel 95
• Inserting and deleting cells, rows and columns
• Saving workbooks
• Moving between worksheets
• Using the spelling checker
• Closing an Excel 95 workbook
• Exiting Excel 95

2. The Excel 95 screen

• The standard toolbar
• The formatting toolbar
• Selecting worksheet views
• The view manager
• Undo and repeat
• Using help

3. Formatting and customizing data

• Formatting options within Excel 95
• Alignment
• To center items in a cell/cells
• Using fonts
• Formatting numbers
• Decimal places
• Formatting columns and rows
• Deleting cells, formats, objects and worksheets
• Adding, editing and removing borders
• Using Autoformat
• Copying data
• Copying data using drag and drop
• Copying columns and rows

4. Formulas and functions

• Formulas
• Operator evaluation order within Excel 95
• Functions
• Using the sum function
• Other commonly used functions
• Using function wizard

5. Introducing charts

• How to create a chart
• Manipulating charts
• Formatting charts
• Chart types
• Creating 3-d charts

6. Printing

• Page setup
• Margins
• Centering a report on a page
• Headers and footers
• Sheet printing options
• Choosing a printer and changing settings
• Printing a worksheet
• Printing multiple files