Microsoft Excel Lesson 2

1
Microsoft Excel Lesson 2

• Lexington Technology Center
• February 2008
• Lori Riddle

2
Excel Lesson 2
Review of Lesson 1

• Starting and Quitting Excel
• Worksheets
• Menus and Toolbars
• Worksheet Cells
• How to Enter and Edit Text and Numbers
• Saving an Excel Workbook

2
3
Excel Lesson 2
Formulas

• Start with some data ...

Click the Equals Sign in the Formula Bar
Data
3
4
Excel Lesson 2
Formulas

• Insert a formula ...

Type Desired Formula
Formula Appears in Cell
Formula Result Bar is Detachable Click and Drag
4
5
Excel Lesson 2
Formulas

• Apply formulas to obtain results

Formula Shown in Formula Bar
Result Appears in Cell
5
6
Excel Lesson 2
Copying Cells

• Copy cells extend ranges with the Fill Handle
• Cursor changes to plus sign ( )
• Click and drag with the left mouse button

Fill Handle
6
7
Excel Lesson 2
Copying Pasting Formulas

• A copied formula will automatically apply
  itself to its new location

Select Cell and Click Copy
Select Cell and Click Paste
7
8
Excel Lesson 2
Changing Fonts Text Location

• Text can be altered and positioned to improve
  its appearance

Select Font Size Dropdown
Select Cell
8
9
Excel Lesson 2
Changing Fonts Text Location

• Bold text by selecting text or cell click the
  bold button
• Center text by selecting the center control

Font Size Set to 18
Bold and Center Text Controls
9
10
Excel Lesson 2
More Cell Formatting

• Change text color with the Font Color tool
• Fill cells with the Fill tool

Font Color
Fill
10
11
Excel Lesson 2
Formatting Rows Columns

• Select Format, then choose Row (or Column)
• Adjust the Height (Width), or Hide/Unhide

Row Height
11
12
Excel Lesson 2
Inserting Rows Columns

• Select Insert, then choose Row (or Column)
• New rows appear above new columns to the left

12
13
Excel Lesson 2
Deleting Rows Columns

• Select the row/column by clicking on the
  number/letter
• Select Edit, then choose Delete

13
14
Excel Lesson 2
Naming a Worksheet

• Right-click the Sheet Tab
• Select Rename, then type the new name

Rename
14
15
Excel Lesson 2
Copying a Worksheet

• Right-click the Sheet Tab select Move or Copy
• Check the Create a copy box and select the
  sheets new location

Select Move to End
Check the Copy box
Move or Copy
15
16
Excel Lesson 2
Viewing Worksheet Tabs

• Sheet Tabs are controlled by buttons at the
  bottom left corner of the document window
• Use the buttons to make all tabs visible

Show First Tab
Show Last Tab
Move Left
Move Right
16
17
Excel Lesson 2
Using the Calculator

• Excel includes a calculator
• Highlight the numbers you want to add and the
  sum appears in the status bar
• Calculator can also average, count, and find
  min/max
• To change operations, right-click in the status
  bar

Highlight a group of Numbers
Sum Appears in Status Bar
Right-Click to get the Operation Popup
17
18
Excel Lesson 2
Centering Across Columns

• Select the cell in which the text begins

Text to be Centered
18
19
Excel Lesson 2
Centering Across Columns

• Highlight the cells in the columns the label
  will span
• Select the Merge and Center Tool

Merge and Center Tool
Columns Highlighted
19
20
Excel Lesson 2
Centering Across Columns

• Text is now centered in a merged cell
• Wait to center until presentation is almost
  complete
• merged cells behave differently from unmerged ones

Centered Text
20
21
Excel Lesson 2
Using AutoFormat

• Click Format on the Menu Bar select
  AutoFormat
• Choose a format from the choices on the left
  see example on right

21
22
Excel Lesson 2
Using the Name Box

• Cells and ranges can be named
• To go to a named cell, type it in the name box,
  or select the dropdown

Click on dropdown to select defined names
Type a Name and press Enter to go to the Cell
22
23
Excel Lesson 2
Using the Name Box

• To name, Click Insert on the Menu Bar and
  select Name, then Define

Type the name here
Insert
Name
Define
23
24
Excel Lesson 2
Using Names in Formulas

• Enter the table shown below. (Use the Fill
  Handle)
• Use a formula to calculate the profit ( B2-B3 )
• Name cell B3 Jan, C3 Feb, D3 Mar, etc

Name the cells in this row
Use the names to calculate quarter totals
JanFebMar
24
25
Excel Lesson 2
Adding Row and Column Tools to the Toolbar

• Select Tools, then Customize choose Commands
  tab
• Select Insert, then choose Rows
• Left-click on desired icon pull to toolbar

Tools
Customize
Commands
25
26
Excel Lesson 2
Deleting Tools from the Toolbar

• Select Tools, then Customize choose Commands
• Left-click, hold and pull the tool off the
  toolbar

Tools
Customize
Commands
26
27
Excel Lesson 2
Review

• Opening a workbook
• Basic formulas using operators (, -, , /, )
• Using the Fill Handle
• Copy and Paste formulas
• Change Font sizes, weights, appearance
• Formatting Rows and Columns
• Inserting and Deleting Rows and Columns
• Renaming and Copying Worksheets
• Built-in Calculator
• Center across columns
• Using AutoFormat
• Using the Name Box
• Adding / Deleting Tools on the Toolbar

27