Excel Lesson 2 2e256y

Microsoft Excel Lesson 2 Lexington Technology Center April 2007 Bob Herring

Excel Lesson 2 Review of the Previous Lesson • • • • • •

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

2

Excel Lesson 2 Formulas • Start with some data ... Click the Equals Sign in the Formula Bar

Data

3

Excel Lesson 2 Formulas, continued • Insert a formula ... Type Desired Formula Formula Result Bar is Detachable; Click and Drag

Formula Appears in Cell

4

Excel Lesson 2 Formulas, continued • Apply formulas to obtain results Formula Shown in Formula Bar

Result Appears in Cell

5

Excel Lesson 2 Copying Cells

• Cells can be copied and ranges extended with the Fill Handle • Cursor changes to plus sign ( + ) • Click and drag with the left mouse button

Fill Handle

6

Excel Lesson 2 Copying and Pasting Formulas

• A copied formula will automatically apply itself to its new location Select Cell and Click Copy Select Cell and Click Paste

7

Excel Lesson 2 Changing Fonts and Text Location

• Text can be altered and positioned to improve its appearance

Select Font Size Dropdown

Select Cell

8

Excel Lesson 2 Changing Fonts and Text Location

• Make text bold by selecting text (or its cell) and click the bold button • Center text by selecting the center control

Font Size Set to 18

Bold and Center Text Controls

9

Excel Lesson 2 More Cell Formatting

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

Font Color

10

Excel Lesson 2 Formatting Rows and Columns • Select Format, then choose Row (or Column) • Adjust the Height (Width), or Hide/Unhide

Row Height

11

Excel Lesson 2 Inserting Rows and Columns • Select Insert, then choose Row (or Column) • The new row appears above selected row; new column to the left

12

Excel Lesson 2 Deleting Rows and Columns • Select the row or column by clicking on the number or letter • Select Edit, then choose Delete

13

Excel Lesson 2 Naming a Worksheet • Right-click the Sheet Tab • Select Rename, then type the new name

Rename 14

Excel Lesson 2 Copying a Worksheet • Right-click the Sheet Tab • Select Move or Copy… • Check the “Create a copy” box and select the sheet’s new location

Select Move to End Move or Copy

Check the Copy box 15

Excel Lesson 2 Viewing Worksheet Tabs

• Sheet Tabs are controlled by buttons at the bottom left corner of the document window • If not all tabs are in view, use the buttons to make them visible

Show First Tab Move Left

Move Right

Show Last Tab 16

Excel Lesson 2 • • • •

Using the Calculator Excel has a built-in calculator that you can use Highlight the numbers that you want to add, and the sum appears in the status bar Calculator can also average, count, and find the min or max To change operations, right-click in the status bar

Highlight a group of Numbers Right-Click to get the Operation Popup

Sum Appears in Status Bar 17

Excel Lesson 2 Centering Across Columns • Select the cell in which the text begins

Text to be Centered

18

Excel Lesson 2 Centering Across Columns

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

Columns Highlighted

Merge and Center Tool

19

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

Excel Lesson 2 Using AutoFormat

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

21

Excel Lesson 2 Using the Name Box

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

Type a Name and press Enter to go to the Cell

Click on dropdown to select defined names

22

Excel Lesson 2 Using the Name Box

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

Type the name here

Name

Define

23

Excel Lesson 2 Using Names in Formulas • Enter the table shown in the picture below. (Use the Fill Handle to help) • Use a formula to calculate the profit ( =B2-B3 ) • Name cell B3 “Jan”, C3 “Feb”, D3 “Mar”, etc

Name the cells in this row

=Jan+Feb+Mar

Use the names to calculate quarter totals 24

Excel Lesson 2 Adding Row and Column Tools to the Toolbar • Select Tools, then Customize; choose the Commands tab • Select Insert, then choose Rows • Left-click and hold the desired icon; pull to desired spot on toolbar Tools

Customize

Commands 25

Excel Lesson 2 Deleting Tools from the Toolbar

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

Customize

Commands 26

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