Spreadsheet Problem Solving and Programming for Engineers and Scientists /
Clough, David E,
Spreadsheet Problem Solving and Programming for Engineers and Scientists / David E. Clough and Steven C. Chapra. - First edition. - 431 pages : illustrations ; 23 cm.
Includes bibliographical references and index.
Chapter 1: Spreadsheet Basics -- Chapter 2: Charts and Graphs -- Chapter 3: Engineering and Scientific Formulas -- Chapter 4: Table‑based Calculations -- Chapter 5: Case Studies and Targeting -- Chapter 6: Financial Calculations -- Chapter 7: Numerical Methods -- Chapter 8: Applied Statistics -- Chapter 9: Introduction to VBA and Macros -- Chapter 10: User‑defined Functions -- Chapter 11: VBA Programming -- Chapter 12: User Interfaces -- Appendix A: Matrix Algebra Review -- Appendix B: Shortcut Keys and Key Combinations.
This book provides a comprehensive resource essential to mastering modern spreadsheet skills needed for engineering and scientific computations. It begins with fundamentals of spreadsheets and programming, then covers engineering economics, numerical methods, applied statistics, and includes detailed instruction on Visual Basic for Applications (VBA) within Excel, supported by case studies, exercises, and real‑world applications.
9781032420530
Spreadsheets--Data processing.
Engineering--Data processing.
Science--Data processing.
Microsoft Excel (Computer file).
Visual Basic for Applications (Computer program language).
005.54 / C.D.S
Spreadsheet Problem Solving and Programming for Engineers and Scientists / David E. Clough and Steven C. Chapra. - First edition. - 431 pages : illustrations ; 23 cm.
Includes bibliographical references and index.
Chapter 1: Spreadsheet Basics -- Chapter 2: Charts and Graphs -- Chapter 3: Engineering and Scientific Formulas -- Chapter 4: Table‑based Calculations -- Chapter 5: Case Studies and Targeting -- Chapter 6: Financial Calculations -- Chapter 7: Numerical Methods -- Chapter 8: Applied Statistics -- Chapter 9: Introduction to VBA and Macros -- Chapter 10: User‑defined Functions -- Chapter 11: VBA Programming -- Chapter 12: User Interfaces -- Appendix A: Matrix Algebra Review -- Appendix B: Shortcut Keys and Key Combinations.
This book provides a comprehensive resource essential to mastering modern spreadsheet skills needed for engineering and scientific computations. It begins with fundamentals of spreadsheets and programming, then covers engineering economics, numerical methods, applied statistics, and includes detailed instruction on Visual Basic for Applications (VBA) within Excel, supported by case studies, exercises, and real‑world applications.
9781032420530
Spreadsheets--Data processing.
Engineering--Data processing.
Science--Data processing.
Microsoft Excel (Computer file).
Visual Basic for Applications (Computer program language).
005.54 / C.D.S