Excel for Engineers and Scientists, 2nd Edition
January 2003, ©2003
Using an informal, conversational style, this "how to" book guides beginning students from spreadsheet basics through the robust engineering and scientific applications of EXCEL, including using EXCEL in the lab.
Students learn how to compose structured, efficient, documented workbooks with data entry cells, summary results and statistics cells, and commented cells. Throughout the book, they'll find innovative techniques for composing spreadsheets, solving problems, analyzing data, and presenting results that will help them in their courses and professional careers. End-of-Chapter problems not only show how to use EXCEL, they also relate directly to topics in engineering and the sciences. Plus, a CD, which is packaged with the text, contains sample workbooks, links to online EXCEL resources, and text updates via the book's web site.
Differentiation and Integration.
Excel's Engineering Functions.
Excel in the Lab.
The following chapters are on the CD only:
Analysis ToolPak: Fourier Analysis.
Analysis ToolPak: FFT Applications.
Appendix 1: Workbooks on the Disk.
Appendix 2: Internet Links.
Appendix 3: Trendline Equations.
Appendix 4: Goal Seek, Solver, Lookup Wizard.
Appendix 5: PivotTable, Internet Assistant Wizard.
- Covers new functions and operations in EXCEL 2002 (Microsoft Office XP).
- Accompanying CD contains more than 80 example workbooks, many of which are new to this edition. Students can explore, modify, and edit these workbooks to gain a hands-on learning experience. The CD also includes three bonus chapters: Complex Math in EXCEL, Fast Fourier Transform tutorial for EXCEL, and FFT Applications using EXCEL.
- Includes new Frequently Asked Questions and Tips for EXCEL features and applications.
- Presents more examples of matrix methods in EXCEL, and the use of Solver and Goal Seek.
- Expanded explanations of integration methods are included.
- Features extensively revised and simplified chapters on numerical calculus and differential equations.
- Documenting worksheets using Comment notes are emphasized.
- Numerous screen shots in every chapter visually reinforce the discussion.
- Offers useful pointers for constructing effective spreadsheets.
- Provides an extensive discussion and step-by-step examples of the Analysis ToolPak, one of the best-kept secrets in EXCEL.
- Demonstrates how to use EXCEL to import, export, acquire, and analyze experimental data in the lab and over the Internet.
- A Web site for the book contains updates for the text, CD, and new workbooks for download.
- Covers matrix methods, numerical differentiation, and integration using several techniques.
- Includes an extensive tutorial and applications of the Fast Fourier Transform.
- Presents the finite element method for partial differential equations in interactive workbooks.