Short description:

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.

Long description:

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 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 numerous case studies, this book will be of interest to students and professionals working in all areas of engineering and science.

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