Description
Book SynopsisSpreadsheet 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 Applications (VBA) programming system that accompanies Excel.
With each chapter including examples and a set of exercises, this book is an ideal companion for all engineering courses and also for self-study. Based on the latest version of Excel (Microsoft Excel for Microsoft 365), it is also compatible with earlier versions of Excel dating back to Version 2013. Including numer
Table of Contents
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
