Excel 2003

Excel Basics

• 1

  Identifying Basic Parts of the Excel Window

  

  • Introduction

  • The Excel window

  • Workbooks and worksheets

  • The cell

  • Moving around the worksheet

  • Challenge!

• 2

  Create, Open, and Save Workbooks

  

  • Introduction

  • Understanding file terms

  • Creating a workbook

  • Saving a workbook

  • Opening a workbook

  • Closing a workbook

  • Challenge!

• 3

  Enter, Edit, and Delete Data

  

  • 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

  

  • 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

  

  • 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

  

  • 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

  

  • 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

  

  • Introduction

  • Naming worksheets

  • Inserting worksheets

  • Deleting worksheets

  • Grouping and ungrouping worksheets

  • Moving worksheets

  • Copying worksheets

  • Challenge!

• 9

  Inserting and Deleting Rows and Columns

  

  • Introduction

  • Inserting a row

  • Inserting a column

  • Deleting columns and rows

  • Challenge!

• 10

  Changing Column Width and Row Height

  

  • Introduction

  • Adjusting column widths

  • Adjusting row height

  • Challenge!

• 11

  Inserting and Deleting Cells

  

  • Introduction

  • Inserting a cell

  • Deleting a cell

  • Merging cells

  • Challenge!

• 12

  Text and Cell Alignments

  

  • 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

  

  • 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

  

  • 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

  

  • 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

  

  • Introduction

  • Moving a chart

  • Resizing a chart

  • Deleting a chart

  • Challenge!

• 17

  Editing Charts

  

  • 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

  

  • Introduction

  • Formatting the chart title

  • Formatting the chart legend

  • Formatting the axis labels

  • Changing the data series color

  • Challenge!

• 19

  Defining Page Setup Options

  

  • Introduction

  • Setting page margins

  • Changing the page orientation and paper size

  • Creating headers and footers

  • Creating sheet settings

  • Challenge!

• 20

  Print Management

  

  • 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

  

  • Introduction

  • Using AutoFilter

  • Challenge!

• 22

  Sorting Lists

  

  • Introduction

  • Sorting lists

  • Challenge!

• 23

  Inserting, Viewing, and Editing Comments

  

  • Introduction

  • Inserting, viewing, and editing comments

  • Challenge!

• 24

  Inserting Hyperlinks

  

  • Introduction

  • Inserting hyperlinks

  • Challenge!

• 25

  Grouping Worksheets

  

  • Introduction

  • Formatting worksheets

  • Challenge!

• 26

  Applying and Modifying Cell Formats

  

  • Introduction

  • Applying and modifying cell formats

  • Challenge!

• 27

  Creating New Workbooks from Templates

  

  • Introduction

  • Creating new workbooks using templates

  • Challenge!

Extras

• Quiz

Learn More

• Excel Formulas

• Office 2003 Basics

• Excel 2013

• Google Sheets