Microsoft Excel 2000 Introduction

Introduction

The Spreadsheet Concept
Introduction to Excel
Excel Screen Layout
Getting Help

Menus and Dialogue Boxes

Menus
Dialogue Boxes
Shortcut Menus
Cell Ranges

Introduction

Moving the Active Cell with the Keyboard
Moving the Active Cell with the Mouse
Selecting a Range with the Keyboard
Selecting a Range with the Mouse
Multiple Ranges
Cell Range Names

Entering Data

Introduction
Constants
Data Validation
Formulae
Cell References
Data Entry in a Range
Extended Formats and Formulae
Editing Data
Functions
Formula Palette and Paste Function
Conditional Function

File Operations

Summary of File Shortcut Keys
Saving Workbooks
Closing Workbooks
Opening Workbook Files
Places Bar
Finding Files
Starting a New Workbook
File Management

Editing

The Office and Windows Clipboards
Filling
Moving
Clearing Ranges
AutoFill Feature
The Fill Handle and the Right Mouse Button
The Selection Border and the Right Mouse Button

Inserting and Deleting

Inserting
Deleting

Formatting

AutoFormat
Cells Formatting
Column Widths
Row Heights

Printing

Print What
Print Preview
Page Setup

Charts

Introduction
Creating a Chart
Chart Sheets
Embedded Charts
Printing an Embedded Chart

Workbook Sheets

Introduction
Working with Sheets
Sheet Groups
3-D Printing

Linking

Introduction
File Links
Creating File Links
Linking Excel to Word
OLE2

Workbook Databases

Introduction
Database Terms
Creating a Database
Sorting Data
Data Filtering

Document Protection

Introduction

Toolbars

Personalised Menus and Toolbars
Showing
Placing
Customising
Creating a Toolbar

Windows, Panes and Views

Windows
Panes
Views

Appendix

Enter Data Using Shortcut Keys
Work in Cells or the Formula Bar Using Shortcut Keys
Format Data Using Shortcut Keys