GCFLearnFree.org

As a website designer, I can say you have one of the best learning websites.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2003

Excel 2003

thumbnail view list view video view
Excel 2003 is the spreadsheet software in the Microsoft 2003 Office Suite. It allows you to store, organize, and analyze numerical information.

If you'd like more practice creating formulas, you may also want to check out our Excel Formulas tutorial!

Excel Basics

  • 1

    Identifying Basic Parts of the Excel Window

    lesson contents
    • Introduction

    • The Excel window

    • Workbooks and worksheets

    • The cell

    • Moving around the worksheet

    • Challenge!

  • 2

    Create, Open, and Save Workbooks

    lesson contents
    • Introduction

    • Understanding file terms

    • Creating a workbook

    • Saving a workbook

    • Opening a workbook

    • Closing a workbook

    • Challenge!

  • 3

    Enter, Edit, and Delete Data

    lesson contents
    • Introduction

    • Entering text in a cell

    • Editing information in a cell

    • Deleting information in a cell

    • Performing Undo and Redo actions

    • Selecting multiple cells

    • Challenge!

  • 4

    Moving, Copying, and Deleting Cell Contents

    lesson contents
    • Introduction

    • Cut, Copy, and Paste defined

    • Copy and Paste cell contents

    • Cut and Paste cell contents

    • Moving information using drag and drop

    • Challenge!

  • 5

    Creating Simple Formulas

    lesson contents
    • Introduction

    • About formulas

    • Creating a simple addition formula

    • Creating a simple addition formula

    • Creating a subtraction formula using the point-and-click method

    • Creating simple multiplication formulas

    • Creating simple division formulas

    • Challenge!

  • 6

    Creating Complex Formulas

    lesson contents
    • Introduction

    • Complex formulas defined

    • Complex formulas defined

    • Creating complex formulas

    • Filling formulas to other cells

    • Copy and paste formulas

    • Revising formulas

    • Creating an absolute reference

    • Challenge!

  • 7

    Using Functions

    lesson contents
    • Introduction

    • Using functions

    • Excel's different functions

    • Finding the sum of a range of data

    • Finding the average of a range of numbers

    • Accessing Excel 2003 functions

    • Challenge!

Worksheet Layout and Management

  • 8

    Working with Multiple Worksheets

    lesson contents
    • Introduction

    • Naming worksheets

    • Inserting worksheets

    • Deleting worksheets

    • Grouping and ungrouping worksheets

    • Moving worksheets

    • Copying worksheets

    • Challenge!

  • 9

    Inserting and Deleting Rows and Columns

    lesson contents
    • Introduction

    • Inserting a row

    • Inserting a column

    • Deleting columns and rows

    • Challenge!

  • 10

    Changing Column Width and Row Height

    lesson contents
    • Introduction

    • Adjusting column widths

    • Adjusting row height

    • Challenge!

  • 11

    Inserting and Deleting Cells

    lesson contents
    • Introduction

    • Inserting a cell

    • Deleting a cell

    • Merging cells

    • Challenge!

  • 12

    Text and Cell Alignments

    lesson contents
    • Introduction

    • Using the Standard toolbar to align text and numbers in cells

    • Changing horizontal cell alignment

    • Changing vertical cell alignment

    • Changing text control

    • Changing text orientation

    • Challenge!

  • 13

    Formatting Numbers

    lesson contents
    • Introduction

    • Formatting numbers in the Format Cells dialog box

    • Formatting date in the Format Cells dialog box

    • Formatting time in the Format Cells dialog box

    • Formatting percentages in the Format Cells dialog box

    • Challenge!

  • 14

    Applying Font, Color, and Borders to Cells

    lesson contents
    • Introduction

    • Changing font type, size, and color

    • Changing font type, size, and color

    • Changing font type, size, and color

    • Underline, italics, and bold

    • Design and apply styles

    • Adding a border to cells

    • Adding color to cells

    • Challenge!

Charting, Printing and Page Setup

  • 15

    Creating a Chart

    lesson contents
    • Introduction

    • Understanding the different chart types

    • Identifying the parts of a chart

    • Creating a chart using the Chart Toolbar

    • Creating an embedded chart

    • Creating a chart sheet

    • Challenge!

  • 16

    Moving, Resizing, and Deleting Charts

    lesson contents
    • Introduction

    • Moving a chart

    • Resizing a chart

    • Deleting a chart

    • Challenge!

  • 17

    Editing Charts

    lesson contents
    • Introduction

    • Changing chart data

    • Changing chart data

    • Changing the chart title

    • Changing the data series names or legend text

    • Changing the chart type

    • Challenge!

  • 18

    Formatting a Chart

    lesson contents
    • Introduction

    • Formatting the chart title

    • Formatting the chart legend

    • Formatting the axis labels

    • Changing the data series color

    • Challenge!

  • 19

    Defining Page Setup Options

    lesson contents
    • Introduction

    • Setting page margins

    • Changing the page orientation and paper size

    • Creating headers and footers

    • Creating sheet settings

    • Challenge!

  • 20

    Print Management

    lesson contents
    • Introduction

    • Specify a print area

    • Preview a page before printing

    • Inserting and removing a page break

    • Printing a worksheet or workbook

    • Challenge!

Advanced Excel Topics

  • 21

    Using AutoFilter

    lesson contents
    • Introduction

    • Using AutoFilter

    • Challenge!

  • 22

    Sorting Lists

    lesson contents
    • Introduction

    • Sorting lists

    • Challenge!

  • 23

    Inserting, Viewing, and Editing Comments

    lesson contents
    • Introduction

    • Inserting, viewing, and editing comments

    • Challenge!

  • 24

    Inserting Hyperlinks

    lesson contents
    • Introduction

    • Inserting hyperlinks

    • Challenge!

  • 25

    Grouping Worksheets

    lesson contents
    • Introduction

    • Formatting worksheets

    • Challenge!

  • 26

    Applying and Modifying Cell Formats

    lesson contents
    • Introduction

    • Applying and modifying cell formats

    • Challenge!

  • 27

    Creating New Workbooks from Templates

    lesson contents
    • Introduction

    • Creating new workbooks using templates

    • Challenge!

Extras

  • Quiz

ampersand

Learn More

  • Excel Formulas

  • Office 2003 Basics

  • Excel 2013

  • Google Sheets

Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.