This Microsoft Excel 2003 training course is offered to you for free online

Lesson 1: Getting to know Excell
  • The excel software
  • The titlebar
  • The menubar
  • The standard toolbar
  • The formatting toolbar
  • The formula toolbar
  • The drawing toolbar
  • The spreadsheet window
  • The statusbar
  • Task pane
Lesson 2: Documents
  • Making a new workbook
  • Saving a workbook
  • Closing files
  • Opening files
  • Selecting cells
  • Insert text into cells
  • Insert numbers into cells
  • Autocomplete
  • Make your own list
  • Zoom in and out on the worksheet
  • Editing multiple workbooks
  • Give workbooks another name
Lesson 3: Ranges
  • Using ranges
  • Selecting ranges
  • Selecting non adjacent ranges
  • Inserting data into selected range
  • Using autocomplete
Lesson 4: Texttools
  • Using formulas
  • Simple syntax formulas
  • Range syntax formulas
  • Using Autosum
  • Inserting functions in 2003 and XP
  • Editing a Range in 2003 and XP
  • Autocorrect formula
  • Autocalculate
Lesson 5: Copy and Paste formulas
  • Absolute and relative cell reference
  • Cut, Copy and Paste information
  • Automaticly fill cells
  • Cut, Copy and Paste through clicking and dragging
  • The Undo button
  • The Redo button
Lesson 6: Columns and Rows
  • Selecting of...
  • Changing column width and row height
  • Autofitting column width and row height
  • Hiding and Unhiding columns and rows
  • Inserting and removing columns and rows
Lesson 7: Formatting worksheets
  • Formatting tools
  • Format cells window
  • The number tab
  • The alignment tab
  • The fonttype tab
  • The border tab
  • The patterns tab
  • Remove all formatting in cells
  • Copy all formatting in a cell to other cell(s)
Lesson 8: Conditional formatting and Autoformat
  • Conditional format
  • Autoformatting
Configure Worksheet Layout
  • Working with page break
  • Header and footer text
  • Page formatting
Lesson 10: Printing worksheets
  • Print Preview
  • Printing worksheets
Lesson 11: 3D formulas
  • Making 3D formulas
  • Writing 3D formulas (syntax)
  • 3D Range
Lesson 12: Identifying ranges
  • Naming ranges
  • Using a Range name in formulas
  • Creating range names through headers
  • Removing range names
  • Give 3D ranges a name
Lesson 13: Worksheet tools
  • Selecting worksheets
  • Selecting multiple worksheets
  • Adding and removing worksheets
  • Changing worksheet names
  • Give worksheet tabs color (only for Excel 2003 and XP)
  • Switch to fullscreen
  • Splitting the screen
  • Freezing windows
  • Copy and Paste entire worksheets
  • Cut, Copy and Paste data to another worksheet
  • Printing multiple worksheets
  • Hiding worksheets
Lesson 14: Using a Workspace
  • Creating a Workspace
  • Opening and closing a Workspace
  • Selecting workbooks in a Workspace
  • Organizing a Workspace
Lesson 15: Paste Special
  • Making tables
  • Selecting table objects
  • Add/Remove column and rows
  • Joining and splitting cells
  • Adjust column width and height
  • Convert table to text
Lesson 16: Sharing and Reviewing workbooks
  • Sharing Workbooks
  • Track changes
  • Accept changes
  • Reviewing toolbar
  • Adding comments
  • Manage comments
  • Show comments
  • Print comments
  • Send Spreadsheets
  • Comparing and Merging workbooks
Lesson 17: Auditing
  • Formula Auditing Toolbar
  • Finding precendants and dependants
  • Trace errors
  • Tracing and Recovering errors (XP and 2003 only)
  • Use Watch Window
  • Validate cell
Lesson 18: Summary reports
  • Using Summary Reports
  • Making and Removing Summary Reports
Lesson 19: Consolidate
  • Consolidate information
  • Type of connection