Atnaujinkite slapukų nuostatas

El. knyga: What Every Engineer Should Know About Excel

3.50/5 (2 ratings by Goodreads)
(Southern Methodist University, Dallas, Texas, USA),
Kitos knygos pagal šią temą:
What Every Engineer Should Know About ExcelDidesnis paveikslėlis
Kitos knygos pagal šią temą:

DRM apribojimai

  • Kopijuoti:

    neleidžiama

  • Spausdinti:

    neleidžiama

  • El. knygos naudojimas:

    Skaitmeninių teisių valdymas (DRM)
    Leidykla pateikė šią knygą šifruota forma, o tai reiškia, kad norint ją atrakinti ir perskaityti reikia įdiegti nemokamą programinę įrangą. Norint skaityti šią el. knygą, turite susikurti Adobe ID . Daugiau informacijos  čia. El. knygą galima atsisiųsti į 6 įrenginius (vienas vartotojas su tuo pačiu Adobe ID).

    Reikalinga programinė įranga
    Norint skaityti šią el. knygą mobiliajame įrenginyje (telefone ar planšetiniame kompiuteryje), turite įdiegti šią nemokamą programėlę: PocketBook Reader (iOS / Android)

    Norint skaityti šią el. knygą asmeniniame arba „Mac“ kompiuteryje, Jums reikalinga  Adobe Digital Editions “ (tai nemokama programa, specialiai sukurta el. knygoms. Tai nėra tas pats, kas „Adobe Reader“, kurią tikriausiai jau turite savo kompiuteryje.)

    Negalite skaityti šios el. knygos naudodami „Amazon Kindle“.

Understanding the powerful computational and graphics capabilities of Microsoft Excel is an enormous benefit to engineers and technical professionals in almost any field and at all levels of experience. What Every Engineer Should Know About Excel is a practical guide to unlocking the features and functions of this program, using examples and screenshots to walk readers through the steps to build a strong understanding of the material. This second edition is updated to reflect the latest version of Excel (2016) and expands its scope to include data management, connectivity to external data sources, and integration with "the cloud" for optimal use of the Excel product. It also introduces the ribbon bar navigation prevalent in Microsoft products beginning with the 2007 version of MS Office. Covering a variety of topics in self-contained chapters, this handy guide will also prove useful for professionals in IT, finance, and real estate.

Recenzijos

"What Every Engineer Should Know About Excel is a valuable reference material that can be readily utilized by Engineers, Financial Comptrollers, Investors and Technology professionals in all industries. This second edition to Dr. Holmans original collection of materials allows todays Excel users to sharpen their current Excel skills, and take them to the next level, even integrating with cloud resources." David A. Schmidt, SCHMIDT & STACY® Consulting Engineers, Inc., Dallas, Texas, USA

"This book unleashes the incredible power Excel offers for engineers and scientists. Reviewing the book, I found myself simply browsing the many features of Excel that I had previously not explored. Every engineer and scientist will benefit from this book at some level and I only regret that I didnt have access to a guide such as this earlier in my career. This book is extraordinarily well-organized. Any topic of interest can be quickly and easily accessed simply by referring to the Table of Contents. Once located, the topic is clearly and concisely presented with helpful illustrations and examples." Stephen M. Collard, St. David's Foundation, Austin, Texas, USA

"What Every Engineer Should Know About Excel is a timely, practical, thorough, and well-written book. It provides clear step-by-step directions on how to utilize Excel to solve simple and complex engineering-related tasks. The book displays excellent insight into the guts of Excels presuppositions (i.e., how Excel defines terms and formulas) and its powerful built-in functions. It demonstrates concepts in such a manner that a reader is enticed to explore Excels virtues. The book serves the needs of both the novice and the expert. It can be used as either a university textbook or as a practical reference guide." Mark A. Stone, Business Associate, Bryan, Texas, USA

"What Every Engineer Should Know About Excel is a book that every engineer will find valuable for his or her work. The book begins with an overview of commonly used spreadsheet functions in Excel, including writing and copying formulas, built-in functions, and creating visually appealing charts, graphs, and drawings. Advanced calculation methods are clearly described, with explanations of how to solve nonlinear problems, iterative solution methods, matrix methods, and optimization problems. Practicing engineers will also find the overview of financial functions valuable for engineering financial analysis. The second edition includes new chapters on data management and integrating Excel with the Cloud. The book presents material in a practical step-by-step approach using examples from engineering practice." David A. Willis, Southern Methodist University, Dallas, Texas, USA "What Every Engineer Should Know About Excel is a valuable reference material that can be readily utilized by Engineers, Financial Comptrollers, Investors and Technology professionals in all industries. This second edition to Dr. Holmans original collection of materials allows todays Excel users to sharpen their current Excel skills, and take them to the next level, even integrating with cloud resources." David A. Schmidt, SCHMIDT & STACY® Consulting Engineers, Inc., Dallas, Texas, USA

"This book unleashes the incredible power Excel offers for engineers and scientists. Reviewing the book, I found myself simply browsing the many features of Excel that I had previously not explored. Every engineer and scientist will benefit from this book at some level and I only regret that I didnt have access to a guide such as this earlier in my career. This book is extraordinarily well-organized. Any topic of interest can be quickly and easily accessed simply by referring to the Table of Contents. Once located, the topic is clearly and concisely presented with helpful illustrations and examples." Stephen M. Collard, St. David's Foundation, Austin, Texas, USA

"What Every Engineer Should Know About Excel is a timely, practical, thorough, and well-written book. It provides clear step-by-step directions on how to utilize Excel to solve simple and complex engineering-related tasks. The book displays excellent insight into the guts of Excels presuppositions (i.e., how Excel defines terms and formulas) and its powerful built-in functions. It demonstrates concepts in such a manner that a reader is enticed to explore Excels virtues. The book serves the needs of both the novice and the expert. It can be used as either a university textbook or as a practical reference guide." Mark A. Stone, Business Associate, Bryan, Texas, USA

"What Every Engineer Should Know About Excel is a book that every engineer will find valuable for his or her work. The book begins with an overview of commonly used spreadsheet functions in Excel, including writing and copying formulas, built-in functions, and creating visually appealing charts, graphs, and drawings. Advanced calculation methods are clearly described, with explanations of how to solve nonlinear problems, iterative solution methods, matrix methods, and optimization problems. Practicing engineers will also find the overview of financial functions valuable for engineering financial analysis. The second edition includes new chapters on data management and integrating Excel with the Cloud. The book presents material in a practical step-by-step approach using examples from engineering practice." David A. Willis, Southern Methodist University, Dallas, Texas, USA

"This book is written for the person who is familiar with Excel but is unaware of its broad potential. he readers who will benefit most from this book are those who have a basic knowl­edge of both Excel and Word, differential and integral calculus, and basic statistics, including standard deviation and prob­ability, and some familiarity with solving single and simultaneous equations....Engineers or anyone wanting to learn more about the capabilities of Excel will find this book an invaluable resource."

IEEE Electrical Insulation Magazine, Vol. 34, No. 3

Preface to the First Edition xiii
Preface to the Second Edition xv
About the Authors xvii
1 Introduction
1(4)
1.1 Getting the Most from Microsoft Excel
1(1)
1.2 Conventions
2(1)
1.3 Introduction to the Microsoft Office Ribbon Bar
3(1)
1.4 Outline of Contents
3(2)
2 Miscellaneous Operations in Excel and Word
5(22)
2.1 Introduction
5(1)
2.2 Generating a Screenshot
5(1)
2.3 Custom Keyboard Setup for Symbols in Word or Excel
6(1)
2.4 Viewing or Printing Column and Row Headings and Gridlines in Excel
7(1)
2.5 Miscellaneous Useful Tips and Shortcuts
7(3)
2.6 Moving Objects in Small Increments (Nudging)
10(1)
2.7 Formatting Objects in Word, Including Wrapping
10(1)
2.8 Formatting Objects in Excel
10(2)
2.9 Copying Formulas by Dragging the Fill Handle
12(1)
2.10 Copying Cell Formulas: Effect of Relative and Absolute Addresses
13(2)
2.11 Shortcut for Changing the Status of Cell Addresses
15(1)
2.12 Switching and Copying Columns or Rows, and Changing Rows to Columns or Columns to Rows
16(1)
2.13 Built-in Functions in Excel
17(1)
2.14 Creating Single-Variable Tables
17(3)
2.15 Creating Two-Variable Tables
20(7)
Problems
24(3)
3 Charts and Graphs
27(32)
3.1 Introduction
27(1)
3.2 Moving Dialog Windows
27(1)
3.3 Excel Choices of x--y Scatter Charts
28(1)
3.4 Selecting and Adding Data for x--y Scatter Charts
29(1)
3.5 Changing/Replacing Data for Charts
30(1)
3.6 Adding Data to Charts
31(1)
3.7 Adding Trend Lines and Correlation Equations to Scatter Charts
32(1)
3.8 Equation for R2
33(1)
3.9 Correlation of Experimental Data with Power Relation
33(3)
3.10 Use of Logarithmic Scales
36(1)
3.11 Correlation with Exponential Functions
37(1)
3.12 Use of Different Scatter Graphs for the Same Data
38(2)
3.12.1 Observations
39(1)
3.13 Plot of a Function of Two Variables with Different Chart Types
40(4)
3.13.1 Changes in Gap Width on 3-D Displays
42(2)
3.14 Plots of Two Variables with and without Separate Scales
44(1)
3.15 Charts Used for Calculation Purposes or G&A Format
45(1)
3.15.1 G&A Chart
45(1)
3.16 Stretching Out a Chart
46(1)
3.17 Calculation and Graphing of Moving Averages
46(3)
3.17.1 Standard Error
49(1)
3.18 Bar and Column Charts
49(1)
3.19 Chart Format and Cosmetics
50(3)
3.20 Surf ace Charts
53(1)
3.21 An Exercise in 3-D Visualization
53(6)
Problems
54(5)
4 Line Drawings, Embedded Objects, Equations, and Symbols in Excel
59(16)
4.1 Introduction
59(1)
4.2 Constructing, Moving, and Inserting Straight Line Drawings
59(6)
4.2.1 Drawing Line Segments in Precise Angular Increments
60(5)
4.3 Inserting Equation Templates and Symbols Using Excel and Word
65(1)
4.3.1 Symbol Insertion
65(1)
4.3.2 Equation Template Insertion
65(1)
4.4 Inserting Equations and Symbols in Excel Using Equation Editor
66(5)
4.5 Construction of Line Drawings from Plotted Coordinates
71(4)
Problems
74(1)
5 Solution of Equations
75(30)
5.1 Introduction
75(1)
5.2 Solutions to Nonlinear Equations Using Goal Seek
75(4)
5.3 Solutions to Nonlinear Equations Using Solver
79(2)
5.4 Iterative Solutions to Simultaneous Linear Equations
81(3)
5.5 Solutions of Simultaneous Linear Equations Using Matrix Inversion
84(3)
5.5.1 Error Messages
86(1)
5.6 Solutions of Simultaneous Nonlinear Equations Using Solver
87(5)
5.7 Solver Results Dialog Box
92(1)
5.8 Comparison of Methods for Solution of Simultaneous Linear Equations
93(2)
5.9 Copying Cell Equations for Repetitive Calculations
95(2)
5.10 Creating and Running Macros
97(8)
Problems
101(4)
6 Other Operations
105(42)
6.1 Introduction
105(1)
6.2 Numerical Evaluation of Integrals
105(5)
6.3 Use of Logical IF Statement
110(3)
6.4 Histograms and Cumulative Frequency Distributions
113(4)
6.5 Normal Error Distributions
117(3)
6.6 Calculation of Uncertainty Propagation in Experimental Results
120(7)
6.7 Fractional Uncertainties for Product Functions of Primary Variables
127(2)
6.8 Multivariable Linear Regression
129(5)
6.9 Multivariable Exponential Regression
134(13)
Problems
144(3)
7 Financial Functions and Calculations
147(12)
7.1 Introduction
147(1)
7.2 Nomenclature
147(1)
7.3 Compound Interest Formulas
148(5)
7.4 Investment Accumulation with Increasing Annual Payments
153(1)
7.5 Payout at Variable Rates from an Initial Investment
154(5)
Problems
156(3)
8 Optimization Problems
159(16)
8.1 Introduction
159(1)
8.2 Graphical Examples of Linear and Nonlinear Optimization Problems
160(2)
8.3 Solutions Using Solver
162(4)
8.4 Solver Answer Reports for Examples
166(3)
8.5 Nomenclature for Sensitivity Reports
169(1)
8.6 Nomenclature for Answer Reports
170(1)
8.7 Nomenclature for Limits Reports
170(5)
Problems
170(5)
9 Pivot Tables
175(24)
9.1 Introduction
175(9)
9.2 Other Summary Functions for Data Fields
184(5)
9.3 Restrictions on Pivot Table Formulas
189(1)
9.4 Calculating and Charting Single or Multiple Functions δ(x) vs. x Using Pivot Tables
189(4)
9.4.1 Working around Charting Limitations of Excel 2016---Scatter Charts
191(2)
9.5 Calculating and Plotting Functions of Two Variables
193(6)
Problems
195(4)
10 Data Management Resources in Excel
199(20)
10.1 Introduction
199(1)
10.2 Organizing Data in Excel Worksheets and Tables
199(2)
10.3 Filtering, Sorting, and Using Subtotals
201(6)
10.3.1 Filtering
201(2)
10.3.2 Sorting
203(1)
10.3.3 Subtotals
204(3)
10.4 Useful Data Functions in Excel
207(2)
10.5 Connecting Excel to External Data
209(7)
10.5.1 General Concepts
210(1)
10.5.2 Connecting to MS Access
210(1)
10.5.3 Connecting to MS SQL Server
211(1)
10.5.4 Connecting to MySQL
212(3)
10.5.5 Connecting to Other Data Sources
215(1)
10.6 Microsoft Power Query
216(3)
Problems
217(2)
11 Office 365 and Integration with Cloud Resources
219(4)
11.1 Introduction
219(1)
11.2 What Is Office 365?
219(1)
11.3 Leveraging MS Excel on Premise and in the Cloud
219(1)
11.4 Integrating MS Excel with Cloud Resources
220(1)
11.4.1 Microsoft Azure
220(1)
11.4.2 Amazon Web Services
220(1)
11.5 Excel and Microsoft Power BI
220(3)
References 223(2)
Index 225
Blake Holman is Chief Information Officer at St. Davids Foundation in Austin, TX. Blake joined the Foundation in 2015 and is responsible for strategic and operational Information Technology (IT) activities, enhancing the Foundations ability to be efficient and effective in fulfilling its mission. Prior to St. Davids Foundation, Blake spent 10 years as the Chief Information Officer of Ryan, LLC, the largest independent Tax Consulting Firm in the world. Blake has over 25 years of experience leading Information Technology Strategy, Development and Operations for several public and private companies in the Consulting, Telecommunications and Financial Services industries.





Blake holds a Bachelor of Science degree in Mechanical Engineering from Southern Methodist University, and a Strategic IT Management Certificate from the Scandinavian International Management Institute in Copenhagen, Denmark. Blake is currently working on a Master of Science degree in Information Security and Assurance at Western Governors University.





In 2011 and 2012, under Blake's leadership, Ryan, LLC was ranked in the InformationWeek 500 listing of the most innovative business technology companies in the United States. In 2011, Ryan was ranked 130th, and in 2012, Ryan's ranking rose to 98th. In both cases, Ryan was the highest ranked corporate tax services firm on the list. In December 2012, Blake was named by Computerworld magazine as one of its 2013 "Premier 100 IT Leaders." The Computerworld Premier 100 IT recognition is an international lifetime award that shines a spotlight on technology.
Daugiau apie elektronines knygas Daugiau apie elektronines knygas
Pastovi nuoroda: https://www.kriso.lt/db/97813519764802e.html
Raktažodžiai: