Lesson 1: Introduction to Excel
Office 2000-2002-2003-XP

Introduction to Excel

What you will learn
  • The Excel program
  • The Title bar
  • The Menu Bar
  • The Standard toolbar
  • The Formatting toolbar
  • Formula bar
  • The Drawing toolbar
  • The Worksheet window
  • The Status
  • The Tasks window (2003/XP)

Lesson 2: The Basics
Office 2000-2002-2003-XP

The Basics

What you will learn
  • Creating a new workbook
  • Workbooks
  • Closing files
  • Opening files
  • Selecting Cells
  • Insert text in cells
  • Insert numbers in cells
  • AutoFill
  • Make your own list
  • Zoom In / Out of the worksheet
  • Editing multiple workbooks
  • Rename Workbooks

Lesson 3: Range
Office 2000-2002-2003-XP

Range

What you will learn
  • The use of Ranges
  • Selecting Ranges
  • Selecting noncontiguous ranges
  • Insert data in a selected range
  • The use of Auto Fill

Lesson 4: Formulas
Office 2000-2002-2003-XP

Formulas

What you will learn
  • The use of the formulas
  • Simple Syntax formulas
  • Range Syntax formulas
  • Formula functions
  • The use of AutoSum
  • Entering Features (XP and 2003)
  • Editing a Range (XP and 2003)
  • AutoCorrect Formula
  • AutoCalculate (AutoCalculate)

Lesson 5: Copy and Pasting Formulas
Office 2000-2002-2003-XP

Copy and paste formulas

What you will learn
  • Absolute and Relative cell references
  • Cut, copy and paste data
  • Auto filling of cells
  • Cut, copy and paste by clicking and dragging
  • The Undo Button
  • The Redo button

Lesson 6: Columns and Rows
Office 2000-2002-2003-XP

Columns and Rows

What you will learn
  • Selecting ...
  • Changing column width and row height
  • Auto Fitting of column width and row height
  • Hide and display rows and columns
  • Insert and delete columns and rows