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, the book builds on the authors’ decades of experience teaching spreadsheets and programming to both university students and professional engineers. Following on from this, it covers engineering economics, key numerical methods, and applied statistics. Finally, the book details the Visual Basic for Applications (VBA) programming system that accompanies Excel. With each chapter including examples and a set of exercises, the 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, Version 2201), it is also compatible with earlier versions of Excel dating back to Version 2013. Including numerous case studies, the book will be of interest to students and professionals working in all areas of engineering.

1) Provides a levelling approach, bringing students at all stages of programming experience to the same point 2) Focuses Python, a general language, to an engineering and scientific context 3) Uses a classroom tested, practical approach to teaching programming 4) Teaches students and professionals how to use Python to solve engineering calculations such as differential and algebraic equations