search for books and compare prices
Tables of Contents for Microsoft Excel for Engineers
Chapter/Section Title
Page #
Page Count
Problem-Solving with Microsoft Excel
1
8
Introduction
2
1
Solving Problems with Microsoft Excel
2
1
Using a Five-Step Problem-Solving Process
3
6
Summary
6
1
References
6
3
An Introduction to Microsoft Excel
9
20
Introduction
10
1
Using Worksheets
10
6
Exploring the Excel Window
11
2
Moving Within the Worksheet
13
1
Entering Values in the Worksheet
14
1
Entering Text in the Worksheet
15
1
Editing Data
15
1
Working with Commands
16
3
The Menu System
16
1
Dialog Boxes
17
1
Toolbar Buttons
17
2
Performing Common Worksheet Operations
19
5
Selecting a Range of Cells
19
1
Formatting the Worksheet
20
1
Manipulating Columns and Rows
21
1
Copying and Moving Information
22
1
Formatting with Toolbar Buttons
22
1
Printing a Worksheet
22
1
Saving and Opening a Worksheet
23
1
Accessing Online Help
24
5
Sounding Rocket Trajectory-Aerospace Engineering
25
1
Rocket Stages
25
1
Worksheet Containing Altitude Data
25
1
Summary
26
1
Exercises
27
2
Engineering and Scientific Computations
29
30
Introduction
30
1
Creating Mathematical Formulas
30
5
Cell References
30
1
The Formula Bar
31
1
Formula Operations
31
2
Copying Formulas
33
1
Recalculation and Iteration
33
1
Circular References
34
1
Using Mathematical Functions
35
3
Common Functions
35
1
Trigonometric Functions
36
1
Exponential and Logarithmic Functions
37
1
Rounding and Truncating Functions
38
1
Including Statistical Computations
38
5
Statistical Functions
39
1
Range Names
40
1
Random Number Generation-Electrical/Computer Engineering
41
1
Bounds for Random Numbers
41
1
Worksheet for Generating Uniform Random Numbers
41
2
Using Special Functions
43
11
IF Function
43
1
LOOKUP Functions
44
2
DATE and TIME Functions
46
1
Cable Car Velocity-Mechanical Engineering
47
1
Cable Car Velocity Equations
47
1
Worksheet for Generating Cable Car Velocity Values
47
3
Temperature Distribution---Mechanical Engineering
50
1
Thermal Equilibrium
50
1
Worksheet for Computing Temperature Distribution
51
3
Creating Macro Commands
54
5
Summary
55
1
Exercises
56
3
Engineering Graphs
59
24
Introduction
60
1
Creating XY Charts
60
11
Creating a Simple Chart
61
3
Changing the Range
64
1
Enhancing a Chart
64
2
Naming, Saving, and Printing a Chart
66
1
1 Quality Control-Manufacturing Engineering
66
1
Circuit Board Defects
66
1
Worksheet for a Quality Analysis Report
67
4
Creating Other Types of Charts
71
6
Pie Charts
71
2
Column Charts
73
2
Line Charts
75
2
Importing Data Files
77
6
Importing Files
78
2
Parsing Imported Data
80
1
Summary
80
1
Exercises
80
3
Scientific Databases
83
28
Introduction
84
1
Creating a Database Using an Excel List
84
8
Specifying Fields and Records
84
2
Viewing Titles
86
1
Displaying Record Numbers
86
1
Climatology Data---Environmental Engineering
87
1
Creating a Worksheet for a Climatology Database
88
1
Descriptive Information
88
1
Number of Fields
89
1
Types of Data
89
2
Field Names
91
1
Sorting a List
92
3
Sort Keys
92
1
Sorting Orders
93
2
Updating a List
95
8
Inserting New Fields and New Records
96
1
Filtering Lists
96
6
Modifying List Records
102
1
Performing Statistical Computations
103
8
Database Functions
104
2
The Histogram Tool
106
2
Summary
108
1
Exercises
108
3
Index
111