• Topic 1A: Explore the Excel Window
• Topic 1B: Select Data
• Topic 1C: Insert and Delete Data
• Topic 1D: Save a Workbook
• Topic 1E: Work with Multiple Workbooks
• Topic 1F: Use the Help Feature
• Topic 1G: Change the Excel Window Layout
• Topic 1H: Change the Excel Settings

• Topic 2A: Edit Data
• Topic 2B: Copy and Move Data Between Cells
• Topic 2C: Copy and Move Data Between Worksheets
• Topic 2D: Copy and Move Data Between Workbooks
• Topic 2E: Fill Series of Data
• Topic 2F: Find and Replace Data
• Topic 2G: Sort Data

• Topic 3A: Insert and Delete Columns and Rows
• Topic 3B: Freeze and Unfreeze Columns and Rows
• Topic 3C: Change Column Width and Row Height

• Topic 4A: Manipulate Worksheets
• Topic 4B: Copy and Move Worksheets Within Workbooks
• Topic 4C: Copy and Move Worksheets Across Workbooks

• Topic 5A: Create Basic Formulas
• Topic 5B: Calculate Data Using Functions
• Topic 5C: Calculate with Logical Functions
• Topic 5D: Create Relative Cell References
• Topic 5E: Create Absolute Cell References
• Topic 5F: Create Mixed Cell References

• Topic 6A: Change Font Type, Size, and Style
• Topic 6B: Apply Borders and Shading
• Topic 6C: Merge Cells
• Topic 6D: Format Numeric Data
• Topic 6E: Align Cell Contents

• Topic 7A: Create a Chart
• Topic 7B: Format Chart Items
• Topic 7C: Change the Chart Type
• Topic 7D: Copy and Move Charts

• Topic 8A: Preview a Worksheet
• Topic 8B: Change Sheet Layout
• Topic 8C: Create and Modify Headers and Footers
• Topic 8D: Set Page Margins
• Topic 8E: Set Page Layout
• Topic 8F: Print a Workbook

• Windows

For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware components:

• A 300 MHz Pentium-class processor if you use Microsoft® Office Windows XP Professional as your operating system. 500 MHz is recommended.
• A 233 MHz Pentium-class processor if you use Microsoft® Office Windows 2000 Professional as your operating system.
• 256 MB of RAM.
• A 6 GB hard disk or larger.
• A floppy disk drive.
• A mouse or other pointing device.
• An 800 x 600 resolution monitor.
• Network cards and cabling for local network access.
• Internet access (see your local network administrator).
• A printer (optional).
• A projection system to display the instructor's computer screen.

• Either Windows XP Professional with Service Pack 1, or Windows 2000 Professional with Service Pack 4.
• Microsoft® Office Professional Edition 2003.