ENGR 179 EXCEL for Scientists and Engineers

1
ENGR 179EXCEL for Scientists and Engineers

• Lecture 1 Fall 2004
• Instructor
• Sherman Wiggin

2

• What is a spreadsheet?
• It is a computerized grid designed to do
  mathematical and statistical calculations and
  sort lists of information.
• What are some basic spreadsheet capabilities?
• In addition to calculations, they are handy for
  making quick charts and graphs, along with
  performing database operations.

3
Cells, Worksheets, Workbooks

• Worksheets are made up of cells. These cells
  have addresses by Column and Row. A cell in
  column B and row 5 is called B5.
• Worksheets can have a
• maximum of 256 columns
• and 65,536 rows.
• Workbooks are made
• Up of a maximum of
• 256 worksheets

4
Cell References

• Cell in column C and row 7 C7
• Range of cells C1 through C10 C1C10
• Range of cells B6 through K6 B6K6
• All cells in row 10 1010
• All cells in rows 1 through 10 110
• All cells in column F FF
• All cells in columns A to E AE
• Absolute cell reference C3 C3
• Paste Link Function

5
Numbers, Text, Formulas
Formula for D7 is shown in Formula Bar
6
Formula Entry

• 11 (addition)
• 2-1 (subtraction)
• 43 (multiplication)
• 12/3 (division)
• 32 (exponent)
• (B7/B9)10 (cell formula structure)
• EXCEL function (cell values)

7
Useful Worksheet Functions

• SUM(B9B20) (adds up cells in range)
• AVERAGE(A1A20)
• MEDIAN(1,4,5,6,A9)
• ROUNDDOWN(29.123,1)
• ROUNDUP(A8,0)
• INT(C29)
• SIN(45PI()/180)
• COS(30PI()/180)
• CONVERT(number,from_unit,to_unit)
• exp(1) ( )

8
Worksheet Set Up

• Use separate worksheets for data files and
  calculations
• Use either embedded charts or separate chart
  sheets
• Use descriptive tabs for worksheets
• Use comments on cells
• Use cell inputs at the top of the worksheet

9
Importing Data Files

• Delimited (Character separation tab, space,
  comma)
• Data type (text, date, number)
• Cut and paste operations
• Data Sort Function

10
Graphing Results

• XY scatter charts
• Line charts
• Column and bar charts
• Pie charts
• Trend line
• Curve fitting (polynomial fit)
• Formatting Charts

11
Next

• Next meeting we will look at how to use Excel to
  solve simple integral and derivative problems.
• Then moving into the basic problem solving
  applications (Physics, Statics, etc)