Spreadsheet Problem Solving and Programming for Engineers and Scientists

 
Edition number: 1
Publisher: CRC Press
Date of Publication:
 
Normal price:

Publisher's listprice:
GBP 91.99
Estimated price in HUF:
44 431 HUF (42 315 HUF + 5% VAT)
Why estimated?
 
Your price:

35 545 (33 852 HUF + 5% VAT )
discount is: 20% (approx 8 886 HUF off)
Discount is valid until: 30 June 2024
The discount is only available for 'Alert of Favourite Topics' newsletter recipients.
Click here to subscribe.
 
Availability:

Estimated delivery time: In stock at the publisher, but not at Prospero's office. Delivery time approx. 3-5 weeks.
Not in stock at Prospero.
Can't you provide more accurate information?
 
  Piece(s)

 
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