كتاب What Every Engineer Should Know About Excel

أخوانى فى الله
أحضرت لكم كتاب
سلسلة مايجب على كل مهندس معرفته عن الأكسل
What Every Engineer Should Know About Excel
J. P. Holman
Southern Methodist University

ويتناول الموضوعات الأتية :

Contents
1 Introduction 1
1.1 Getting the Most from Excel 1
1.2 Conventions 2
1.3 Outline of Contents .3
2 Miscellaneous Operations in Excel and Word 5
2.1 Introduction .5
2.2 Print Screen or Screen Dump .5
2.3 Custom Keyboard Setup for Symbols in Word 7
2.4 Viewing or Printing Column and Row Headings and Gridlines in Excel .8
2.5 Assorted Instructions .8
2.6 Moving Objects in Small Increments (Nudging) 10
2.7 Formatting Objects in Word, Including Wrapping 11
2.8 Formatting Objects in Excel .11
2.9 Use of Photo-Editing Software in Word, Including Wrapping 11
2.10 Copying Cell Formulas: Effect of Relative and Absolute Addresses 14
2.11 Copying Formulas by Dragging the Fill Handle .15
2.12 Shortcut for Changing the Status of Cell Addresses .17
2.13 Switching and Copying Columns or Rows, and Changing Rows to
Columns or Columns to Rows 17
2.14 Built-In Functions in Excel .18
2.15 Creating Single-Variable Tables Using the DATA/TABLE Command .19
2.16 Creating Two-Variable Tables Using the DATA/TABLE Command 21
Problems .24
3 Charts and Graphs .27
3.1 Introduction .27
3.2 Moving Dialog Windows 27
3.3 Excel Chart Wizard Window Showing Choice of x-y Scatter Charts .28
3.4 Selecting and Adding Data for x-y Scatter Charts .29
3.5 Changing and Adding Data for Charts Using the SOURCE DATA Command .30
3.6 Adding Data to Charts Using the ADD DATA Command 30
3.7 Adding Trendlines and Correlation Equations to Scatter Charts 31
3.8 Equation for R2 .31
3.9 Correlation of Experimental Data with Power Relation .32
3.10 Use of Logarithmic Scales 34
3.11 Correlation with Exponential Functions 35
3.12 Use of Different Scatter Graphs for the Same Data .36
3.12.1 Observations .41
3.13 Plot of a Function of Two Variables with Different Chart Types 41
3.13.1 Changes in Gap Width and Chart Depth on 3-D Displays 44
3.14 Plots of Two Variables with and without Separate Scales 44
3.15 Charts Used for Calculation Purposes or G&A Format 453.15.1 G&A Chart 48
3.16 Stretching Out a Chart from a Single Chart Page 48
3.17 Alternate Chart Sizing Procedure Using MS Word .49
3.18 Calculation and Graphing of Moving Averages .50
3.18.1 Standard Error 54
3.19 Bar and Column Charts 55
3.20 Chart Format and Cosmetics .56
3.21 Surface Charts .58
3.22 Suggested Scatter Graph Setting as Default Chart 59
3.23 An Exercise in 3-D Visualization .63
3.24 Editing Excel Charts Using Word .63
3.25 Editing Excel Tables Using Word 65
3.26 Alternate Procedure .67
3.27 Editing Excel Charts Directly in Word by Using Grouping .69
Problems .72
4 Line Drawings and Embedded Objects in Excel 77
4.1 Introduction .77
4.2 Constructing, Moving, and Inserting Straight Line Drawings 77
4.2.1 Drawing Line Segments in Precise Angular Increments 78
4.3 Inserting Items in Excel with Symbols, Subscripts, and Superscripts 83
4.4 Inserting Equations or Symbols in Word Using Equation Editor .85
4.5 Inserting Equations and Symbols in Excel Using Equation Editor .86
4.6 Construction of Line Drawings from Plotted Coordinates .88
Problems .92
5 Solution of Equations 93
5.1 Introduction .93
5.2 Solutions to Single Nonlinear Equations Using Goal Seek 93
5.3 Solutions to Single Nonlinear Equations Using Solver .95
5.4 Iterative Solutions to Simultaneous Linear Equations 98
5.5 Solutions of Simultaneous Linear Equations Using Matrix Inversion .99
5.5.1 Error Messages .103
5.6 Solutions of Simultaneous Nonlinear Equations Using Solver 103
5.7 Solver Results Dialog Box 110
5.8 Comparison of Methods for Solution of Simultaneous
Linear Equations 111
5.9 Copying Cell Equations for Repetitive Calculations .112
5.10 Creating and Running Macros .113
Problems .118
6 Other Operations 121
6.1 Introduction .121
6.2 Numerical Evaluation of Integrals 121
6.3 Use of Logical IF Statement .125
6.4 Histograms and Cumulative Frequency Distributions 128
6.5 Normal Error Distributions 132
6.6 Calculation of Uncertainty Propagation in Experimental Results .138
6.7 Fractional Uncertainties for Product Functions of Primary Variables 142
6.8 Multivariable Linear Regression .1456.9 Multivariable Exponential Regression 150
Problems .158
7 Financial Functions and Calculations 161
7.1 Introduction .161
7.2 Nomenclature .161
7.3 Compound Interest Formulas 162
7.4 Investment Accumulation with Increasing Annual Payments .168
7.5 Payout at Variable Rates from an Initial Investment .168
Problems .171
8 Optimization Problems 175
8.1 Introduction .175
8.2 Graphical Examples of Linear and Nonlinear Optimization Problems .176
8.3 Solutions Using Solver 179
8.4 Solver Answer Reports for Examples .182
8.5 Nomenclature for Sensitivity Reports 185
8.6 Nomenclature for Answer Reports .186
8.7 Nomenclature for Limits Reports 186
Problems .186
9 Pivot Tables .191
9.1 Introduction .191
9.2 Other Summary Functions for Data Fields .204
9.3 Restrictions on Pivot Table Formulas .207
9.3.1 Ordering of Data Fields and Resultant Graphs .208
9.4 Calculating and Charting Single or Multiple Functions
f(x) vs. x Using Pivot Tables .212
9.5 Calculating and Plotting Functions of Two Variables .216
9.5.1 Display of Formulas and Solve Order .219
Problems .220
References 223
Index

كلمة سر فك الضغط : books-world.net
The Unzip Password : books-world.net
أتمنى أن تستفيدوا من محتوى الموضوع وأن ينال إعجابكم
رابط من موقع عالم الكتب لتنزيل كتاب What Every Engineer Should Know About Excel
رابط مباشر لتنزيل كتاب What Every Engineer Should Know About Excel

كيفية التسجيل فى منتدى هندسة الإنتاج والتصميم الميكانيكى

طريقة التنزيل من المنتدى خطوة بخطوة

الهارد الشامل والمتكامل لقسم ميكانيكا

******************************************************

كتاب What Every Engineer Should Know About Excel 761752

Good book

كيفية التسجيل فى منتدى هندسة الإنتاج والتصميم الميكانيكى

طريقة التنزيل من المنتدى خطوة بخطوة

الهارد الشامل والمتكامل لقسم ميكانيكا

Mohamed Abdelnasser كتب:: Good book

لاتنسى المساهمة معنا بعمل اللايك والشير للمنشورات والفيديوهات والإشتراك فى القناة
https://www.youtube.com/c/Eng2010?sub_confirmation=1
وزيارة الموقع
https://www.eng2010.com
والاعجاب بصفحة المنتدى على الفيس بوك
https://www.facebook.com/eng2010com
وجروب المنتدى على الفيس بوك
https://www.facebook.com/groups/DEABS2010/
و جروب المنتدى على الواتساب - نرجو الانضمام لجروب واحد فقط
https://chat.whatsapp.com/F7y6ThYOR2gEkSK7KtnhKx
https://chat.whatsapp.com/Dv2QvTOLGp47OaVi5UB2sT
https://chat.whatsapp.com/IC43ZxT5MzWI9ysZLMWlbx
وجروب المنتدى للنقاشات والطلبات على الواتساب
https://chat.whatsapp.com/L8B5vk9yJWnCjZ9rx0Zjxl
و قناتنا على التيليجرام
https://t.me/Eng2010Com
https://t.me/Eng2010
و متابعة حسابنا على موقع تويتر
https://twitter.com/Eng2010com
و متابعة حسابنا على الانستجرام
https://www.instagram.com/eng2010com
و متابعة حسابنا على على بنترست
https://www.pinterest.com/Eng2010Com/

كيفية التسجيل فى منتدى هندسة الإنتاج والتصميم الميكانيكى

طريقة التنزيل من المنتدى خطوة بخطوة

الهارد الشامل والمتكامل لقسم ميكانيكا

******************************************************

» كتاب 100 Excel Simulations - Using Excel to Model Risk
» كتاب Excel by Example
» كتاب Mechanical Engineer’s Handbook
» كتاب Excel for Scientists and Engineers Numerical Methods
» كتاب Mechanical Engineer’s Handbook