Microsoft Excel 2000

Introduction

Getting Started
The Interface
Menus
Toolbars
Formula Bar
Columns & Rows
Scroll Bars
Sheet Tabs
Status Bar
Interface Review
Workbooks & Worksheets
Open and Close Workbooks
Save Workbooks
Getting Help

The Basics

Select and Navigate Cells
Enter Data
Edit and Delete Data
Cut / Copy and Paste
Undo and Redo
Drag and Drop
Auto Fill
AutoCorrect

Working With Worksheets

Zoom Control
Views
Resize Rows and Columns
Insert Cells
Delete Cells
Insert and Delete Rows and Columns
Rename Worksheets
Insert and Delete Worksheets
Move and Copy Worksheets
Hide and Unhide

Formatting Cells

Text Formats
Align and Text Wrap
Alignment Effects
Format Painter
Borders and Shading
Numbers Formats
Date and Time Formats
Custom Formats
Autoformat
Conditional Formating
Styles

Basic Formulas

Formula Structure
Operators
Creating Formulas
Autofill Formulas
Autosum
Relative Reference
Absolute Reference
Function Wizard

Ready for Printing?

Headers and Footers
Print Preview
Scaling the Print Area
Set Print Area
Margins
Printing

Charts and Maps

Creating a Chart
Chart Wizard
Chart Options
The Legend
The Series
Chart Toolbar
3D Charts
Creating Maps
Customizing Maps
Labeling Maps

Advanced Formulas

If Functions
And / Or
Nested If Functions

Using Excel as a Databse

Create a Database
Sort Data
Filter Data
Advance Filter
Data Forms
Database Functions

Linking and Protecting

Formula Links
Range Names
Paste Special
Protect Cells
Protect Worksheets and Workbooks
Passwords

Analysis

Goal Seek and Solver
Scenarios
Pivot Tables
Validation
Auditing
Outlining

Toolbars and Macros

Customizing Toolbars
Create a Macro
Edit a Macro
Create a Macro Button

Graphics and The Drawing Toolbar

Insert a Picture
Move / Resize and Crop
Creating Shapes and Lines
Arranging and Grouping
Fills and Line Color
Arrows
AutoShapes
Flip and Rotate
Text boxes
WordArt
Shadow and 3D Effects