
Spreadsheet Problem Solving and Programming for Engineers and Scientists
- 432 pages
- English
- ePUB (mobile friendly)
- Available on iOS & Android
Spreadsheet Problem Solving and Programming for Engineers and Scientists
About this book
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.
Frequently asked questions
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Information
Table of contents
- Cover Page
- Half-Title Page
- Title Page
- Copyright Page
- Dedication Page
- Contents
- List of Examples
- Preface
- About the Authors
- 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
- References
- Index
- Index of Excel-VBA Terminology