Excel 2002 Notes
CISM 2201
Valdosta State University
Class Lectures, Excel Tips, and Practice and Test Preparation

This page contains Microsoft Word documents and Adobe PDF Files.
If you do not have Microsoft Word on your computer, please download the Word Viewer.
If you do not have an Adobe Acrobat Reader, please download the Adobe Reader.

Class Lectures

  1. Introduction to Excel - Word 2002 (3.3mb) or PDF File (375kb) and Excel Intro Workbook
  2. Absolute Cells and If Statements - Word 2002 (235kb) or PDF File (138kb) and Absolute and If Workbook
  3. Calculating Depreciation - Word 2002 (497kb) or PDF File (38kb) and Depreciation Workbook
  4. Horizontal and Vertical Analysis - Word 2002 (782kb) or PDF File (65kb) and Analysis Workbook
  5. Payroll - Word 2002 (226KB) or PDF File (120kb) and Payroll Workbook
  6. Linked Cells and Dates - Word 2002 (1.10mb) or PDF File (127kb) and Linking Workbook

Excel Tips

  1. Excel 2002 Handout (Word 2002 Document)
  2. Excel 2002 Introduction (Word 2002 Document) and Tutorial 1 Intro Worksheet (Excel Workbook)
  3. Cell Formulas
  4. Absolute Cell Referencing
  5. If Statements - Text
  6. If Statements - Cells
  7. If Statements - Calculate a Formula

Practice and Test Preparation

  1. Excel 2002 Review Sheet (Word 2002 Document, 1.02MB)
  2. Practice Worksheet #1 - Totals
  3. Practice Worksheet #2 - Stock Portfolio
  4. Practice Worksheet #3 - Horizontal Analysis
  5. Practice Worksheet #4 - Payroll Deductions
  6. Practice Worksheet #5 - Commissions
  7. Excel Review Worksheet

| Valdosta State University | College of Business Administration | Management |
| Jennifer's Home Page | Contact Me |


Updated January 28, 2004

September 11, 2001      Valid CSS!