Excel 2000 Introduction

Excel basics

• The paper spreadsheet
• The Excel program
• The workbook environment

Entering data and navigating in a worksheet

• Entering and correcting data
• Saving a file
• Using formulas
• Opening a second file
• Navigation and movement techniques

Modifying a workbook

• Working with ranges
• Working with functions
• Editing cell contents

Moving and copying data

• Inserting rows and ranges
• Moving data
• Copying data
• Absolute references
• Using the Fill Series feature

Formatting a worksheet

• Formatting a worksheet
• Number formats and text alignment
• Copying and pasting formats
• Special and custom formatting

Printing a worksheet

• Checking spelling
• Using the Print Preview command
• Printing a large worksheet
• Additional print options

Introduction to the workbook environment

• Using a multiple-sheet workbook
• Creating a chart
• Outlining
• Spreadsheet Solutions

Creating Excel web pages