This book provides a targeted and comprehensive resource essential to a full understanding of modern spreadsheet skills needed for engineering and scientific computations. Building on the authors' decades of experience teaching spreadsheets and programming, it is the ideal companion for all engineering courses and professional self-study.
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
Spreadsheet Problem Solving and Programming for Engineers and Scientists provides a comprehensive resource essential to a full understanding of modern spreadsheet skills needed for engineering and scientific computations.
Beginning with the basics of spreadsheets and programming, this book builds on the authors decades of experience teaching spreadsheets and programming to both university students and professional engineers and scientists. Following on from this, it covers engineering economics, key numerical methods, and applied statistics. Finally, this book details the Visual Basic for Aplƒ`