Spreadsheet Tools for Engineers Using Excel

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.Successfully combines an introduction to the fundamentals of Excel with a clear presentation of Engineering problem solving methodology.Abundant problems and examples.Chapters 2-14 cover the most common analytical techniques used by engineers.Material on select new features found in Excel 2002 (included in Office XP). New material including coverage of line graphs and pie charts, a discussion of the problems associated with circular references (particularly in regard to the solution of algebraic equations), a discussion of convergence problems when solving algebraic equations, and new material on pivot tables. The author has rewritten the material on semi-log graphs, log-log graphs, and curve fitting and has changed the order of the material in response to reviewer feedback. Contains a wealth of technical analysis geared toward introductory-level students and plenty of background information on what the technical terms mean or are based upon. Material on select new features found in Excel 2003. Students learn to use the most popular spreadsheet tool to solve engineering problems.Students get to practice what they learn; instructors are provided with lots of new problems from which to choose. Instructors are provided with a range of analytical techniques from which to choose when teaching; students are provided coverage of the most common techniques used by engineers.