Excel XP

Excel Basics

• 1

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

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

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

  Moving, Copying, and Deleting Cell Contents arrow_forward_ios ✓ Learn how to use the drag and drop commands, as well as the cut, copy, and paste commands.
• 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 text alignment, as well as text control and orientation.
• 13

  Formatting Numbers arrow_forward_ios ✓ Learn how to format the display of numbers, as well as the date and time.
• 14

  Applying Font, Color, and Borders to Cells arrow_forward_ios ✓ Learn how to adjust fonts, font 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 the chart title, legend, and axis.
• 19

  Defining Page Setup Options arrow_forward_ios ✓ Learn how to use Excel's page setup options to make your worksheet look more professional.
• 20

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

Extras

• 21

  What's New in Microsoft Excel XP arrow_forward_ios ✓ Learn about some of the features available in Excel XP.
• 22

  Planning your Excel XP Spreadsheet arrow_forward_ios ✓ Use these tips to plan your Excel XP spreadsheet.
• 23

  Writing Formulas in Microsoft Excel XP arrow_forward_ios ✓ Learn how to write formulas in Excel XP.
• 24

  Excel XP Quiz arrow_forward_ios ✓ Take the final quiz to see how much you've learned about Excel XP.