This best-selling "Spreadsheet" book provides excellent coverage of all versions of Excel, including the latest version, Excel 2002. It discusses how to use Excel to solve a variety of problems in introductory engineering analysis, such as graphing data, unit conversions, simple statistical analysis, sorting, searching and analyzing data, curve fitting, interpolation, solving algebraic equations, logical decisions, evaluating integrals, comparing economic alternatives, and finding optimum solutions. Numerous examples are included illustrating both traditional and spreadsheet solutions to a variety of problems. The underlying mathematical solution procedures are also discussed, so that the reader is provided with an understanding of what the spreadsheet does and how it does it.
1 Engineering Analysis and Spreadsheets2 Excel Fundamentals3 Graphing Data4 Converting Units5 Transferring Data6 Analyzing Data7 Organizing Data8 Fitting Equations to Data9 Interpolating between Data Points10 Solving Simple Equations11 Solving Simultaneous Equations12 Making Logical Decisions (IF-THEN-ELSE)13 Evaluating Integrals14 Comparing Economic Alternatives15 Finding Optimum Solutions