Excel 2003

Excel Basics

• 1

  Identifying Basic Parts of the Excel Window arrow_forward_ios ✓ Learn the basic parts of the Excel 2003 window.
• 2

  Create, Open, and Save Workbooks arrow_forward_ios ✓ Learn how to create, save, open, and close an Excel workbook.
• 3

  Enter, Edit, and Delete Data arrow_forward_ios ✓ Learn how to enter, edit, and delete Excel data.
• 4

  Moving, Copying, and Deleting Cell Contents arrow_forward_ios ✓ Learn how to move, copy, and delete data in Excel cells.
• 5

  Creating Simple Formulas arrow_forward_ios ✓ Learn how to create a simple formula in Excel.
• 6

  Creating Complex Formulas arrow_forward_ios ✓ Learn how to create a complex formula in Excel.
• 7

  Using Functions arrow_forward_ios ✓ Learn how to use functions to find values for a range of cells.

Worksheet Layout and Management

• 8

  Working with Multiple Worksheets arrow_forward_ios ✓ Learn how to name, insert and delete, group and ungroup, and copy and move worksheets.
• 9

  Inserting and Deleting Rows and Columns arrow_forward_ios ✓ Learn how to insert and delete Excel rows and columns.
• 10

  Changing Column Width and Row Height arrow_forward_ios ✓ Learn how to adjust column width and row height in Excel.
• 11

  Inserting and Deleting Cells arrow_forward_ios ✓ Learn all about inserting and deleting Excel cells.
• 12

  Text and Cell Alignments arrow_forward_ios ✓ Learn how to change horizontal and vertical cell alignment, as well as text control and orientation.
• 13

  Formatting Numbers arrow_forward_ios ✓ Learn all about the various number formats Excel has available.
• 14

  Applying Font, Color, and Borders to Cells arrow_forward_ios ✓ Learn how to adjust fonts, fonts colors, and borders in Excel.

Charting, Printing and Page Setup

• 15

  Creating a Chart arrow_forward_ios ✓ Use charts in Excel to illustrate your workbook data graphically.
• 16

  Moving, Resizing, and Deleting Charts arrow_forward_ios ✓ Learn how to move, resize, and delete charts in Excel.
• 17

  Editing Charts arrow_forward_ios ✓ Learn how to edit charts in Excel.
• 18

  Formatting a Chart arrow_forward_ios ✓ Learn how to format a chart title, legend, and axis in Excel.
• 19

  Defining Page Setup Options arrow_forward_ios ✓ Learn how to set page margins, change page orientation and paper size, and create headers and footers.
• 20

  Print Management arrow_forward_ios ✓ Learn how to specify a print area, preview it, and send it to the printer.

Advanced Excel Topics

• 21

  Using AutoFilter arrow_forward_ios ✓ Discover how to use the AutoFilter function in Excel to filter your data.
• 22

  Sorting Lists arrow_forward_ios ✓ Learn how to use Excel's sort function to arrange data how you want.
• 23

  Inserting, Viewing, and Editing Comments arrow_forward_ios ✓ Learn how to use Excel's comments feature to insert, view, edit, and delete them.
• 24

  Inserting Hyperlinks arrow_forward_ios ✓ Learn how to add hyperlinks in Excel.
• 25

  Grouping Worksheets arrow_forward_ios ✓ Learn how to group worksheets in Excel.
• 26

  Applying and Modifying Cell Formats arrow_forward_ios ✓ Learn how to format cell styles, numbers, alignment, fonts, borders, and patterns in a spreadsheet.
• 27

  Creating New Workbooks from Templates arrow_forward_ios ✓ Learn how to create new workbooks from templates in Excel.