Excel XP
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