Excel Basics

• 1

  Identifying Basic Parts of the Excel Window ✓

  Learn the basic parts of the Excel XP window.

• 2

  Create, Open, and Save Workbooks ✓

  Learn how to create, save, open, and close Excel workbooks.

• 3

  Enter, Edit, and Delete Data ✓

  Learn how to enter, edit, and delete data.

• 4

  Moving, Copying, and Deleting Cell Contents ✓

  Learn how to use the drag and drop commands, as well as the cut, copy, and paste commands.

• 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 text alignment, as well as text control and orientation.

• 13

  Formatting Numbers ✓

  Learn how to format the display of numbers, as well as the date and time.

• 14

  Applying Font, Color, and Borders to Cells ✓

  Learn how to adjust fonts, font 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 the chart title, legend, and axis.

• 19

  Defining Page Setup Options ✓

  Learn how to use Excel's page setup options to make your worksheet look more professional.

• 20

  Print Management ✓

  Learn how to use Print Preview, insert and remove page breaks, and print a workbook.

Extras

• 21

  What's New in Microsoft Excel XP ✓

  Learn about some of the features available in Excel XP.

• 22

  Planning your Excel XP Spreadsheet ✓

  Use these tips to plan your Excel XP spreadsheet.

• 23

  Writing Formulas in Microsoft Excel XP ✓

  Learn how to write formulas in Excel XP.

Quiz

• Excel XP Quiz ✓

  Test your knowledge of Excel XP by taking our quiz.