Introduction to Excel Day 2

1. Seminar for Top Engineering Prospects Introduction to ExcelDay 2

2. http://fairway.ecn.purdue.edu/~step/class_material

3. Addressing Review • A1 = 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

4. Velocity Exercise -- IndividualTime: 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 + t2 m/s. • The black car takes off at v = (8 + t)t + t2 m/s. • Which car wins?

5. Graphing -- Step 1 Select all Data

6. Graphing – Step 2 Click the Insert tab Click the Scatter button

7. Graphing – Step 3 Choose whichever one you like

8. Graphing Complete!

9. Adding A Title Click on the Layout tab (the chart must be selected) Click the Chart Title button

10. 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.

11. Adding Axis Labels Click on the Layout tab (the chart must be selected) Click the Axis Titles button

12. 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.

13. Adding Axis Labels, Cont. To add a y-axis title, select Primary Vertical Axis Title instead Select any of these options

14. Axis Labels And A Title • Then just click inside the text box that appears saying “Axis Title” to edit the text.

15. Graphing Exercise – TeamTime: 7 min • Now create a graph for just the red car or just the black car.

16. Solution – General Graphing Technique Click the Insert tab Choose whichever one you like

17. Solution, Cont. Right click anywhere in the box

18. Solution, Cont. Click Select Data

19. Solution, Cont. Click Add Name your series appropriately Then click the box next to Select Range

20. Solution, Cont. When you see this box, select the appropriate cells, and then click this button.

21. Solution, Cont. Click the button under Series Y values When you see this box, select the appropriate cells, and then click this button.

22. Solution, Cont. Click OK

23. Solution!!!

24. 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)

25. Goal Seek – How to Find it Click the Data tab Click on What-If Analysis And then Goal Seek

26. 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

27. Goal Seek • In the case of multiple valid answers, you must provide Goal Seek with an initial guess.

28. Goal Seek Uses • Find Roots of an equation • Find a break even point in economic forecast

29. Team Exercise • 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 • Estimated Time Needed : 10 minutes