1

Introduction to Excel

Chapter 2

2

Wrapping Text

• Steps to wrap text in one cell:

• Type the amount of text that will fit within a cell

• [alt] + [enter]

3

Wrapping Text:

• Steps to “unwrap” text in one cell:

• Select cells

• Format menu

• Cells

• Alignment tab

• Remove check from “wrap text”

4

Formulas:

• Rules to write formulas:– Always start with [=] [+] or [-]– Always use the cell references within the

formulas when possible– Separate cell reference with a mathematical

operator

Why use cell references? If you change a value within the worksheet, the formulas using cell references will “automatically recalculate.”

5

Mathematical Operators:

• - negation or subtraction

• % percentage

• ^ exponentiation

• * multiplication

• / division

• + addition

6

Selecting non-adjacent cells/ranges:

• Select first cell/range

• [ctrl]

• Select next cell/range

• In other words, just like you did in Microsoft Word!

7

More Functions:

• Methods to enter a function:

• Keyboard or mouse

• “insert function” box on formula bar

• “autosum”

• “function” command on insert menu

• Type = then choose from name box

• Voice command mode

8

More Functions:

• =sum…adds the numbers in the specified range.• =average…sums the numbers in the specified

range and then divides the sum by the number of non-zero cells in the range.

• =max…displays the highest value in a range• =min…displays the lowest value in a range

9

Range Finder:

• Used to check which cells are being referenced in the formula assigned to the active cell by highlighting cells referenced in the formula.

• Double-click on cell containing a formula to activate the range finder.

10

Formatting:

• Steps to change vertical alignment:– Select cells– Format menu– Cells command– Alignment tab

Or

Select cells

Right-click within selection

Format cells command

Alignment tab

11

Formatting:

• Steps to add a fill color:– Select cells– Choose color from “fill color” button on

formatting toolbarOrSelect cellsFormat menuCells commandPatterns tab

12

Formatting:

• Steps to add a border:• Select cells• Choose border from “borders” button on

formatting toolbarOr Select cellsFormat menuCells commandBorders tabChoose: style, color, setting

13

Formatting:

• Steps to change number formatting:– Select cells– Choose on of the “style” buttons from the

formatting toolbarOr Select cellsFormat menuCells commandNumber tab

14

Formatting:

• Steps to increase/decrease decimal places:– Click Increase or Decrease Decimal button on

the formatting toolbar

15

Formatting:

• Steps to Conditional Format:• Select cells• Format menu• Conditional formatting command• Set conditions• Format button• Add Button allows you to add up to 2 additional

conditions• Delete Button allows you to delete one or more

active conditions

16

Column Widths/Row Heights:

• Steps to change column widths:• Select columns using column heading• Format menu• Column command• Width OrSelect columns using column headingPlace resize arrow on column boundaryDrag to new width

17

Column Widths/Row Heights:

• Steps to Autofit column Widths:• Select columns using column heading• Format menu• Column command• AutofitOr Select columns using column headingsPlace resize arrow on column boundaryDouble click

18

Column Widths/Row Heights:

• Steps to change row height (same as double spacing in Word):

• Select rows using row heading• Format menu• Row command• HeightOrSelect rows using row headingPlace resize arrow on row boundary Drag to new height.

19

Column Widths/Row Heights:

• Steps to autofit row height:• Select rows using row heading • Format menu• Row command• AutofitOrSelect rows using row headingPlace resize arrow on row boundaryDouble click

20

DISPLAY FORMULAS:

• This allows you to see the formulas in the cells instead of the numbers.

• [ctrl] +[`] ← is above the tab key.

21

THE END!