| This extensive book thoroughly covering the application of Excel to engineering, includes many engineering-oriented examples and problems from a variety of disciplines. Covers Excel from the basics to its relation to financial calculation; matrix math; statistics; data fitting and interpolation; iterative methods; programming; integration and differentiation; and working with other programs.
Table of Contents
1. Introduction to Excel.
Introduction. Starting Excel. A Little Windows. Spreadsheet Basics. Printing the Spreadsheet. Saving, Opening Workbooks, and Exiting.
2. Graphing with Excel.
Introduction, Getting Ready to Graph: Importing Text Files. Creating an XY Scatter Plot. Editing an Existing Graph. Creating Graphs with Multiple Curves. Printing the Graph. Types of Graph.
3. Excel Functions.
Introduction to Excel Functions. Excel's Built-in Functions. Using the CONVERT ( ) Function to Convert Units. Simple Math Functions. Computing Sums. Trigonometric Functions. Inverse Trigonometric Functions. Advanced Math Functions. Conditional Formatting. Error Function. Bessel Functions. Working with Complex Numbers. Working with Binary, Octal, and Hexadecimal Values. Miscellaneous Functions.
4. Matrix Operations in Excel.
Matrix Manipulations: Vectors, Matrices, and Arrays. How Excel Handles Matrix Math. Basic Matrix Operations. Solving Systems of Linear Equations.
5. Linear Regression in Excel
Introduction. Linear Regression Using Excel Functions. Linear Regression Using Excel's Trend Line Capability. Other Two-Coefficient Linear Regression Models. Polynomial Regression. Linear Regression Using Excel's Regression Analysis Package.
6. Iterative Solutions Using Excel.
Introduction. Iterative Solutions. Introduction to Excel's Solver. Optimization Using the Solver. Nonlinear Regression. Testing the Regression Result.
7. Using Macros in Excel.
Introduction. Macros and Viruses. Recorded Macros. Programmed Macros (VBA)
8. Programming in Excel with VBA.
Introduction. Visual Basic for Applications (VBA) Overview. Forms and Modules. Working with Forms. Using the Form from the Spreadsheet.
9. Sharing Excel Information with Other Programs.
Introduction to Sharing Excel Information with Other Programs. Using Copy and Paste to Move Information. Embedded and Linked Objects. External Data Sources.
10. Time Value of Money with Excel.
Time, Money, and Cash Flows. Interest Rates and Compounding. Moving Amounts through Time. Economic Alternatives: Making Decisions.
11. Financial Calculations with Excel.
Introduction. Internal Rate of Return and Net Present Value. Depreciation of Assets.
12. Excel's Statistics Functions.
Overview. Populations and Samples. Standard Deviations and Variances. Errors, Deviations, and Distributions. Confidence Intervals.
13. Numerical Differentiation Using Excel.
Finite Differences. Filtering Data. Curve-Fitting and Differentiation.
14. Numerical Integration Using Excel.
Integrating for Area under a Curve. Integrating for Area Between Two Curves. Numerical Integration Methods. Using Regression Equations for Integration.
15. Numerical Integration Techniques for Differential Equations Using Excel.
Euler's Method. Fourth-Order Runge-Kutta Method. Integrating Two Simultaneous ODEs Using the Runge-Kutta Method. Implicit Methods.
Index. |
