Introduction to EXCEL 2000/97   4 classes • 12 hours + practice • $130 The electronic spreadsheet has become universal in the business environment.
Spreadsheet program have replaced other more traditional means for carrying out everything from budgeting to inventory management.
Microsoft Excel has become one of the standards used by businesses everywhere.
In this course, you will be introduced to the Excel documents containing formulas, functions, charts and graphics.
The material will be presented using a mixture of lecture and hands-on practice.  
Using Excel worksheets Formatting and Printing
     
  • Opening, saving, printing, and closing a worksheet
  • Creating, saving and printing a chart
  • Entering labels, values, and formulas

     
  • Changing fonts, font style, and font size
  • Aligning cell contents
  • Centering text across columns
  • Using the numbering, currency, and percentage formats
  • Borders, colors and patterns for emphasis
  • The Drawing toolbar
  • Adding comments to a worksheet
  • Previewing printouts
  • Printing in portrait and landscape orientations
  • Centering printouts on a page
  • Removing cell gridlines from printouts
  • Displaying formulas
Developing effective worksheets
     
  • Changing column width, inserting rows
  • Creating a series with AutoFill and using AutoComplete
  • Relative absolute references
  • The SUM function and AutoSum
  • Formatting cells with AutoFormat
  • Adding a cell note to a worksheet
  • Checking the spelling of a worksheet
  • Locking and unlocking cells
Functions, Formulas, and Absolute references
     
  • The MIN and MAX, AVERAGE and TODAY functions
Charts and Graphics ( as time permits )
     
  • Planning & constructing charts
  • Identifying the elements of the Excel chart
  • Different types of Excel charts
  • Selecting nonadjacent ranges
     
  • Moving a chart and changing its size
  • Add, editing and formatting chart text
  • Adding pictures to a column chart
  • Working with multiple sheets and chart sheets
 


Last update: March 2005

(next update to be determined)
FRASER-HICKSON LIBRARY COMPUTER CENTRE • 4855 Avenue Kensington, Montreal QC H3X 3S6 • TEL: (514) 489-5301 ext. 203
 • e-mail • webmaster • Web Design Fight Spam!