كتاب What Every Engineer Should Know About Excel
منتدى هندسة الإنتاج والتصميم الميكانيكى
بسم الله الرحمن الرحيم

أهلا وسهلاً بك زائرنا الكريم
نتمنى أن تقضوا معنا أفضل الأوقات
وتسعدونا بالأراء والمساهمات
إذا كنت أحد أعضائنا يرجى تسجيل الدخول
أو وإذا كانت هذة زيارتك الأولى للمنتدى فنتشرف بإنضمامك لأسرتنا
وهذا شرح لطريقة التسجيل فى المنتدى بالفيديو :
https://www.youtube.com/watch?v=aw8GR3QlY6M
وشرح لطريقة التنزيل من المنتدى بالفيديو:
https://www.youtube.com/watch?v=Lf2hNxCN1cw
https://www.youtube.com/watch?v=PRIGVoN7CPY
إذا واجهتك مشاكل فى التسجيل أو تفعيل حسابك
وإذا نسيت بيانات الدخول للمنتدى
يرجى مراسلتنا على البريد الإلكترونى التالى :

DEABS2010@YAHOO.COM



 
الرئيسيةالبوابةاليوميةس .و .جبحـثالتسجيلدخولحملة فيد واستفيدجروب المنتدى
شاطر | .

 

 كتاب What Every Engineer Should Know About Excel

استعرض الموضوع السابق استعرض الموضوع التالي اذهب الى الأسفل 
كاتب الموضوعرسالة
Admin
مدير المنتدى
مدير المنتدى
avatar

عدد المساهمات : 14496
التقييم : 23502
تاريخ التسجيل : 01/07/2009
العمر : 29
الدولة : مصر
العمل : مدير منتدى هندسة الإنتاج والتصميم الميكانيكى
الجامعة : المنوفية

مُساهمةموضوع: كتاب What Every Engineer Should Know About Excel    الإثنين 04 سبتمبر 2017, 3:58 pm

أخوانى فى الله
أحضرت لكم كتاب
سلسلة مايجب على كل مهندس معرفته عن الأكسل
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

استعرض الموضوع السابق استعرض الموضوع التالي الرجوع الى أعلى الصفحة 
صفحة 1 من اصل 1

خدمات الموضوع
 KonuEtiketleri كلمات دليليه
كتاب What Every Engineer Should Know About Excel , كتاب What Every Engineer Should Know About Excel , كتاب What Every Engineer Should Know About Excel ,كتاب What Every Engineer Should Know About Excel ,كتاب What Every Engineer Should Know About Excel , كتاب What Every Engineer Should Know About Excel
 KonuLinki رابط الموضوع
 Konu BBCode BBCode
 KonuHTML Kodu HTMLcode
إذا وجدت وصلات لاتعملفي الموضوع او أن الموضوع [ كتاب What Every Engineer Should Know About Excel ] مخالف ,, من فضلك راسل الإدارة من هنا
صلاحيات هذا المنتدى:لاتستطيع الرد على المواضيع في هذا المنتدى
منتدى هندسة الإنتاج والتصميم الميكانيكى :: المنتديات الهندسية :: منتدى الكتب والمحاضرات الهندسية :: منتدى الكتب والمحاضرات الهندسية الأجنبية-