Lesson 12: Identify “Ranges”
Office 2000-2002-2003-XP

Identify Ranges

What you will learn
  • Naming Ranges
  • The use of a Range Name in formulas
  • Creating Range Names by Headers
  • Deleting Range Names
  • Naming 3D Ranges

Lesson 13: “Spreadsheet Tools”

Spreadsheet Tools

What you will learn
  • Selecting Worksheets
  • Selecting multiple worksheets
  • Adding and deleting worksheets
  • Rename Worksheets
  • Color Worksheet tabs (for Excel XP and 2003)
  • Switch to Full Screen image
  • The Screen split
  • Freeze Windows
  • Copying and moving full sheets
  • Cut, copy, paste data to another worksheet
  • Printing multiple worksheets
  • How to hide worksheets

Lesson 14: Using “Workspace”
Office 2000-2002-2003-XP

Using Workspace (Workspace)

What you will learn
  • Creating a Workspace
  • Opening and closing a Workspace
  • Selecting Workbooks in a Workspace
  • Organizing a Workspace

Lesson 16: Sharing and reviewing “Workbooks”
Office 2000-2002-2003-XP

Sharing and reviewing workbooks

What you will learn
  • Sharing workbooks
  • Tracking changes
  • Accept Changes
  • The Reviewing toolbar (Reviewing Toolbar)
  • Add comments
  • Managing comments
  • View comments
  • Printing Notes
  • Copy Spreadsheets
  • Compare and Merge Workbooks

Lesson 17: “Formula Auditing”
Office 2000-2002-2003-XP

Formula Auditing

What you will learn
  • The "Formula Auditing" toolbar
  • The finding of source cells and target cells
  • Debugging
  • Checking and correcting errors (2003 and XP)
  • Use of Watch window.
  • Cell validation

Lesson 20: “Charts”
Office 2000-2002-2003-XP

Charts

What you will learn
  • Creating Charts
  • Move and resize Chart
  • The Chart toolbar
  • Printing of Charts
  • Delete Chart