Excel 2000

Excel Basics

• 1

  The Excel Window

  

  • Introduction

  • The Excel Window

  • The Excel Workbook

  • The Cell

  • Moving the Cell Pointer

  • Challenge!

• 2

  Entering and Editing Data

  

  • Introduction

  • Entering Data

  • Editing Data

  • Selecting Multiple Cells

  • Challenge!

• 3

  Working with Multiple Worksheets

  

  • Introduction

  • Naming Worksheets

  • Inserting and Deleting Worksheets

  • Grouping Worksheets

  • Grouping and Ungrouping Worksheets

  • Copying and Moving Worksheets

  • Challenge!

• 4

  Creating Formulas

  

  • Introduction

  • Creating Formulas

  • Creating a Simple Formula

  • Challenge!

• 5

  Complex Formulas

  

  • Introduction

  • Complex Formulas

  • Creating Complex Formulas

  • Filling Formulas

  • Copying and Pasting Formulas

  • Revising Formulas

  • Absolute References

  • Did You Know?

• 6

  Formatting Numbers

  

  • Introduction

  • Formatting Numbers

  • To Format using the Format Cells Dialog Box:

  • Challenge!

• 7

  Using Functions

  

  • Introduction

  • Using Functions

  • Excel's Different Functions

  • Accessing Functions

  • Challenge!

Changing Worksheet Layout

• 8

  Inserting and Deleting Rows and Columns

  

  • Introduction

  • Inserting Columns

  • Inserting Rows

  • Deleting Columns and Rows

  • Challenge!

• 9

  Adjusting Column Width and Row Height

  

  • Introduction

  • Adjusting Column Widths

  • Adjust Column Width Two Ways

  • Adjusting Row Height

  • Did You Know?

• 10

  Inserting and Deleting Cells

  

  • Introduction

  • Inserting Cells

  • Deleting Cells

  • Challenge!

• 11

  Moving and Copying Cell Contents

  

  • Introduction

  • Moving and Copying Cell Contents

  • Differences in Excel's Cut, Copy, and Paste Functions

  • Using Drag and Drop

  • Did You Know?

• 12

  Aligning Text

  

  • Introduction

  • Aligning Text

  • Another Alignment Option: Merge and Center

  • The Format Cells Dialog Box

  • The Format Cells Dialog Box - Understanding the Alignment Tab

  • The Format Cells Dialog Box - Understanding the Alignment Tab

  • The Format Cells Dialog Box - Understanding the Alignment Tab

  • Challenge!

• 13

  Fonts, Color, and Borders

  

  • Introduction

  • Fonts, Color, and Borders

  • Formatting With Fonts

  • Selecting a Font Style

  • Adding Borders and Color

  • Challenge!

Charting and Printing

• 14

  Creating a Chart

  

  • Introduction

  • Chart Basics

  • Types of Charts

  • The Chart Toolbar

  • Creating an Embedded Chart

  • Creating a Chart Sheet

  • The Chart Wizard

  • Challenge!

• 15

  Moving, Resizing, and Deleting Charts

  

  • Introduction

  • Deleting a Chart

  • Moving a Chart

  • Resizing a Chart

  • Challenge!

• 16

  Editing Charts

  

  • Introduction

  • Changing the Data in a Chart

  • Editing the Chart Title

  • Formatting the Chart Title

  • Formatting the Chart Legend

  • Formatting the Value and Category Axis

  • Changing the Color of a Data Series

  • Challenge!

• 17

  Using the Page Setup Dialog Box

  

  • Introduction

  • The Page Setup Dialog Box

  • Page Orientation and Paper Size

  • Setting Up Margins

  • Headers and Footers

  • Placeholders in the Header/Footer Dialog Box

  • Sheet Settings

  • Did You Know?

• 18

  Print Preview

  

  • Introduction

  • Print Preview

  • The Print Preview Toolbar

  • Define Page Breaks Using Print Preview

  • Page Break Preview

  • Challenge!

• 19

  Print

  

  • Introduction

  • Printing in Excel

  • The Print Dialog Box in Excel

  • Challenge!

Extras

• Quiz

Learn More

• Excel Formulas

• Office 2000 Basics

• Excel 2013

• Google Sheets