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 97
Intermediate Level Training Course

Courseware Training Manual

1. Worksheets, a further look

• Renaming worksheets
• Deleting and inserting worksheets
• Finding files
• Displaying other toolbars
• Customizing the look of the toolbars
• Freeze panes
• Grouping and ungrouping worksheets
• The series command

2. Further formatting techniques

• Conditional formatting
• Creating new styles based on existing cell formatting
• Using colors in Excel 97
• Using colors based on values
• Gridlines
• Hiding data and re-displaying data

3. Further functions

• What are functions?
• Using paste function
• The if( ) function
• Data validation functions
• The hlookup / vlookup functions
• A sample hlookup
• The choose function
• Entering a choose function
• The date functions
• Mathematical date functions
• Time functions
• Text manipulation functions

4. Database and list management

• What is a database?
• Excel 97 databases
• Database terminology
• Creating, editing and navigating a database
• Sorting an internal Excel 97 database
• What is autofilter?
• Filtering data
• Top 10 autofilter
• Advanced filtering
• Totaling and manipulating filtered data
• Creating subtotals
• Using data forms
• The Excel 97 data form

5. Customizing charts

• The chart wizard
• Adding and removing data
• Changing data by dragging and dropping columns
• Formatting the chart area
• Chart formatting - legends
• Chart formatting - axis
• Chart formatting - the plot area
• Chart formatting - gridlines
• Chart formatting - the data series

6. Drawing and pictures

• Drawing lines, boxes, ovals and arcs
• Using autoshapes
• Creating text boxes
• Pictures
• Bring to front/send to back
• Grouping and un-grouping objects

7. Excel 97 and other applications

• Using the conversion feature
• Cut, copy and paste - using the clipboard
• Using paste special
• OLE - embedding vs. Linking
• Linking data from other worksheets
• Linking data from Word
• Linking data to Word