Excel 2003
In this free Excel 2003 tutorial, learn how to create formulas and charts, use functions, format cells, and do more with your spreadsheets.
search
menu
Excel Basics
-
1
Identifying Basic Parts of the Excel Window ✓
Learn the basic parts of the Excel 2003 window.
-
2
Create, Open, and Save Workbooks ✓
Learn how to create, save, open, and close an Excel workbook.
-
3
Enter, Edit, and Delete Data ✓
Learn how to enter, edit, and delete Excel data.
-
4
Moving, Copying, and Deleting Cell Contents ✓
Learn how to move, copy, and delete data in Excel cells.
-
5
Creating Simple Formulas ✓
Learn how to create a simple formula in Excel.
-
6
Creating Complex Formulas ✓
Learn how to create a complex formula in Excel.
-
7
Using Functions ✓
Learn how to use functions to find values for a range of cells.
Worksheet Layout and Management
-
8
Working with Multiple Worksheets ✓
Learn how to name, insert and delete, group and ungroup, and copy and move worksheets.
-
9
Inserting and Deleting Rows and Columns ✓
Learn how to insert and delete Excel rows and columns.
-
10
Changing Column Width and Row Height ✓
Learn how to adjust column width and row height in Excel.
-
11
Inserting and Deleting Cells ✓
Learn all about inserting and deleting Excel cells.
-
12
Text and Cell Alignments ✓
Learn how to change horizontal and vertical cell alignment, as well as text control and orientation.
-
13
Formatting Numbers ✓
Learn all about the various number formats Excel has available.
-
14
Applying Font, Color, and Borders to Cells ✓
Learn how to adjust fonts, fonts colors, and borders in Excel.
Charting, Printing and Page Setup
-
15
Creating a Chart ✓
Use charts in Excel to illustrate your workbook data graphically.
-
16
Moving, Resizing, and Deleting Charts ✓
Learn how to move, resize, and delete charts in Excel.
-
17
Editing Charts ✓
Learn how to edit charts in Excel.
-
18
Formatting a Chart ✓
Learn how to format a chart title, legend, and axis in Excel.
-
19
Defining Page Setup Options ✓
Learn how to set page margins, change page orientation and paper size, and create headers and footers.
-
20
Print Management ✓
Learn how to specify a print area, preview it, and send it to the printer.
Advanced Excel Topics
-
21
Using AutoFilter ✓
Discover how to use the AutoFilter function in Excel to filter your data.
-
22
-
23
Inserting, Viewing, and Editing Comments ✓
Learn how to use Excel's comments feature to insert, view, edit, and delete them.
-
24
Inserting Hyperlinks ✓
Learn how to add hyperlinks in Excel.
-
25
Grouping Worksheets ✓
Learn how to group worksheets in Excel.
-
26
Applying and Modifying Cell Formats ✓
Learn how to format cell styles, numbers, alignment, fonts, borders, and patterns in a spreadsheet.
-
27
Creating New Workbooks from Templates ✓
Learn how to create new workbooks from templates in Excel.