eLearning Excel Introduction

eLearning Home

Excel Introduction

1. Unit 1: Getting Started
2. Unit 2: Entering and editing data
   1. Creating workbooks
   2. Entering labels and values
   3. Editing labels and values
   4. Entering and editing formulas
   5. Saving and updating workbooks
   6. Unit 2 Practice Activity
3. Unit 3: Modifying a Worksheet
4. Unit 4: Using Functions
5. Unit 5: Formatting Worksheets
6. Unit 6: Printing
7. Unit 7: Creating Charts

Entering labels and values

In spreadsheet terms, text is referred to as labels and numbers are referred to as values.

Labels and values should be entered into separate cells in a spreadsheet, so that the values may be used as part of formulas, or calculations.

Try it!

Open Sales report.xls from the course files folder.

On Sheet 1 enter details for Julian in row 7 as shown below.

Handy hint:

Values should be entered in without currency symbols or commas as these can be applied using number formats later on.

Using Undo/Redo

Undo can be used to reverse previous changes you have made to your spreadsheet.
To use Undo, click the button on the standard toolbar or use Ctrl + Z.

Redo can be used to reverse changes made by pressing the Undo button.
To use Redo, click the button on the standard toolbar or use Ctrl + Y.

Try it!

Using Sales report.xls, use Undo several times to reverse typing labels into row 7.

Then use Redo to re-enter labels.