Introduction to Excel Day 2 - PowerPoint Presentation

Slide1

Introduction to ExcelDay 2

Seminar for Top Engineering Prospects

Slide2

http://engineering.purdue.edu/step/class_material

Slide3

Addressing ReviewA1 = Relative Column, Relative Row

$A1 = Absolute Column, Relative Row

A$1 = Relative Column, Absolute Row

$A$1 = Absolute Column, Absolute Row

F4 to Toggle Through Options

Slide4

Velocity Exercise -- Individual

Time

: 10 min

Two cars sit at a red

light,

revving their engines. When the light changes, both cars floor it

.

Find the velocities of each car in .5 second increments for t = 0 to 10 seconds if:

The red car takes off at v = 12t + t

2

m/s.

The black car takes off at v = (8 + t)t + t

2

m/s.

Which

car wins?

Slide5

Graphing -- Step 1

Select all Data

Slide6

Graphing – Step 2

Click the Insert tab

Click the Scatter button

Slide7

Graphing – Step 3

Choose whichever one you like

Slide8

Graphing Complete!

Slide9

Adding A Title

Click on the Layout tab (the chart

must be selected)

Click the Chart Title button

Slide10

Adding A Title, Cont.

Click either of the

two bottom options

Then just click inside the text box that appears saying

“Chart Title” to edit the text.

Slide11

Adding Axis Labels

Click on the Layout tab (the chart

must be selected)

Click the Axis Titles button

Slide12

Adding Axis Labels, Cont.

Select Primary

Horizontal Axis Title

Select Title Below Axis

Then just click inside the text

box that appears saying

“Axis Title” to edit the text.

Slide13

Adding Axis Labels, Cont.

To add a y-axis title, select

Primary Vertical Axis Title instead

Select any of these options

Slide14

Axis Labels And A Title

Then just click inside the text box that appears saying “Axis Title” to edit the text.

Slide15

Graphing Exercise – TeamTime: 7 min

Now

create a graph for just the red car or just the black car.

Slide16

Solution – General Graphing Technique

Click the Insert tab

Choose whichever one you like

Slide17

Solution, Cont.

Right click anywhere in the box

Slide18

Solution, Cont.

Click Select Data

Slide19

Solution, Cont.

Click Add

Name your series

appropriately

Then click the box

next to Select Range

Slide20

Solution, Cont.

When you see this box, select the

appropriate cells, and then click this button.

Slide21

Solution, Cont.

Click the button under

Series

Y

values

When you see this box, select the

appropriate cells, and then click this button.

Slide22

Solution, Cont.

Click OK

Slide23

Adding a Title and Axis Labels (Alternate)

1) Click the first picture in ‘Chart Layouts’

2) Click inside each box that appears to change the text in your chart title and axis labels

Slide24

Solution!!!

Slide25

Goal Seek

Used to find a specific result in one cell (that contains a formula) by changing another cell (that contains one of the components of the formula)

Slide26

Goal Seek – How to Find it

Click the Data tab

Click on What-If

Analysis

And then Goal Seek

Slide27

Goal Seek

$B$1 Contains a formula such as

=$A$1 * 2

Goal Seek would find which value of $A$1 would set $B$1 to 4, in this case, 2

Slide28

Goal Seek

In

the case of multiple valid

answers, you must provide Goal Seek with an initial guess.

Slide29

Goal Seek Uses

Find Roots of an equation

Find a break even point in economic forecast

Slide30

Team Exercise (3 min)

When does the red car reach 100 m/s?

When does the black car reach 100 m/s?

Slide31

Team Exercise (10 min)

You are given $1000 today. What interest rate (compounded Annually) is needed in order to have $10,000 after 15 years?

F = P(1+I)

n

F = Final Amount

P = Present Amount

I = Interest Rate

N = Number of

Periods