What Every Engineer Should Know About Excel
With the many software packages available today, it's easy to overlook the computational and graphics capabilities offered by Microsoft® ExcelTM. The software is nearly ubiquitous and understanding its capabilities is an enormous benefit to engineers in almost any field and at all levels of experience. What Every Engineer Should Know About Excel offers in nine self-contained chapters a practical guide to the features and functions that can be used, for example, to solve equations and systems of equations, build charts and graphs, create line drawings, and perform optimizations. The author uses examples and screenshots to walk you through the steps and build a strong understanding of the material.
With this book, you will learn how to...
What people are saying - Write a review
We haven't found any reviews in the usual places.
Other editions - View all
adjustments appear as shown arithmetic mean array button calculation cell B4 Cell Name changing cells Click OK coefficient column constraints copied correlation Ctrl cumulative frequency data fields data markers data points data series data table described in Section desired dialog box display drag-copied dragging Drawing toolbar editing Engineer Should Know Enhanced Metafile entered in cell Example Excel worksheet feasible region final financial functions format formula g function Goal Seek graphical gridlines Histogram icon increments initial guess insert investment iterative labels linear regression macro matrix moving average nomenclature nonlinear equations normal distribution obtained parameters payments period pivot table plot present value problem procedure rate of return regression analysis scatter chart scatter graph scores selected shown in Figure solution Solver standard deviation surface chart symbols target cell temperature text box trapezoidal rule trendline uncertainty variables Word document worksheet function zero