| Description |
1 online resource (248 pages) |
| Series |
What Every Engineer Should Know |
|
What every engineer should know.
|
| Contents |
Cover -- Half Title -- Title Page -- Copyright Page -- Contents -- Preface to the First Edition -- Preface to the Second Edition -- About the Authors -- 1. Introduction -- 1.1 Getting the Most from Microsoft Excel -- 1.2 Conventions -- 1.3 Introduction to the Microsoft Office Ribbon Bar -- 1.4 Outline of Contents -- 2. Miscellaneous Operations in Excel and Word -- 2.1 Introduction -- 2.2 Generating a Screenshot -- 2.3 Custom Keyboard Setup for Symbols in Word or Excel -- 2.4 Viewing or Printing Column and Row Headings and Gridlines in Excel |
|
2.5 Miscellaneous Useful Tips and Shortcuts2.6 Moving Objects in Small Increments (Nudging) -- 2.7 Formatting Objects in Word, Including Wrapping -- 2.8 Formatting Objects in Excel -- 2.9 Copying Formulas by Dragging the Fill Handle -- 2.10 Copying Cell Formulas: Effect of Relative and Absolute Addresses -- 2.11 Shortcut for Changing the Status of Cell Addresses -- 2.12 Switching and Copying Columns or Rows, and Changing Rows to Columns or Columns to Rows -- 2.13 Built-In Functions in Excel -- 2.14 Creating Single-Variable Tables -- 2.15 Creating Two-Variable Tables |
|
Problems3. Charts and Graphs -- 3.1 Introduction -- 3.2 Moving Dialog Windows -- 3.3 Excel Choices of xâ#x80;#x93;y Scatter Charts -- 3.4 Selecting and Adding Data for xâ#x80;#x93;y Scatter Charts -- 3.5 Changing/Replacing Data for Charts -- 3.6 Adding Data to Charts -- 3.7 Adding Trend Lines and Correlation Equations to Scatter Charts -- 3.8 Equation for R[sup(2)] -- 3.9 Correlation of Experimental Data with Power Relation -- 3.10 Use of Logarithmic Scales -- 3.11 Correlation with Exponential Functions -- 3.12 Use of Different Scatter Graphs for the Same Data |
|
3.12.1 Observations3.13 Plot of a Function of Two Variables with Different Chart Types -- 3.13.1 Changes in Gap Width on 3-D Displays -- 3.14 Plots of Two Variables with and without Separate Scales -- 3.15 Charts Used for Calculation Purposes or G & A Format -- 3.15.1 G & A Chart -- 3.16 Stretching Out a Chart -- 3.17 Calculation and Graphing of Moving Averages -- 3.17.1 Standard Error -- 3.18 Bar and Column Charts -- 3.19 Chart Format and Cosmetics -- 3.20 Surface Charts -- 3.21 An Exercise in 3-D Visualization -- Problems |
|
4. Line Drawings, Embedded Objects, Equations, and Symbols in Excel4.1 Introduction -- 4.2 Constructing, Moving, and Inserting Straight Line Drawings -- 4.2.1 Drawing Line Segments in Precise Angular Increments -- 4.3 Inserting Equation Templates and Symbols Using Excel and Word -- 4.3.1 Symbol Insertion -- 4.3.2 Equation Template Insertion -- 4.4 Inserting Equations and Symbols in Excel Using Equation Editor -- 4.5 Construction of Line Drawings from Plotted Coordinates -- Problems -- 5. Solution of Equations -- 5.1 Introduction |
| Notes |
""5.2 Solutions to Nonlinear Equations Using Goal Seek"" |
|
Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force. WlAbNL |
|
Print version record |
| SUBJECT |
Microsoft Excel (Computer file) http://id.loc.gov/authorities/names/n86025775
|
|
Microsoft Excel (Computer file) fast (OCoLC)fst01366659 |
| Subject |
Engineering -- Computer programs.
|
|
Engineering -- Computer programs
|
| Form |
Electronic book
|
| Author |
Holman, Blake K
|
| ISBN |
9781351976480 |
|
1351976486 |
|
1351976478 |
|
9781351976473 |
|
