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

  Sorting Lists ✓

  Learn how to use Excel's sort function to arrange data how you want.

• 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.