Go to the FGCU Homepage navigation bar
    
Technology Skills Orientation
Excel 2000 Tutorial
A-Z FGCU Index FGCU Calendar of Events Campus Tour Library Search FGCU Web FGCU Webmail Contact FGCU
 
Excel 2000 Tutorial
 

Begin the Excel tutorial »


Spreadsheet Basics

  • Screen elements
  • Adding and renaming worksheets
  • The standard toolbar - opening, closing, saving, and more.

Customizing Excel

  • Menus
  • Customize toolbars
  • Recording a macro
  • Running a macro

Modifying A Worksheet

  • Moving through cells
  • Adding worksheets, rows, and columns
  • Resizing rows and columns
  • Selecting cells
  • Moving and copying cells
  • Freeze panes

Formatting Cells

  • Formatting toolbar
  • Format Cells dialog box
  • Dates and times
  • Styles
  • Style dialog box
  • Create a new style
  • Format Painter
  • AutoFormat

Formulas and Functions

  • Formulas
  • Linking worksheets
  • Relative, absolute, and mixed referencing
  • Basic functions
  • Function Wizard
  • Autosum
       

Sorting and Filling

  • Basic ascending and descending sorts
  • Complex sorts
  • Autofill
  • Alternating text and numbers with Autofill
  • Autofilling functions

Graphics

  • Adding clip art
  • Add an image from a file
  • Editing a graphic
  • AutoShapes

Charts

  • Chart Wizard
  • Resizing a chart
  • Moving a chart
  • Chart formatting toolbar
  • Copy a chart to Microsoft Word

Page Properties and Printing

  • Page breaks
  • Page orientation
  • Margins
  • Headers, footers, and page numbers
  • Print Preview
  • Print

Keyboard Shortcuts


Office 2000 Tutorials · Word · Excel · Power Point · Access · FrontPage

FGCU does not provide personal support for Office 2000 programs to outside parties.

 
 

© FGCU 2009. This is an official FGCU web page.
Florida Gulf Coast University is an equal opportunity/affirmative action institution.

Contact the Webmaster | FGCU Directory