Some error occured while loading the Quick View. Please close the Quick View and try reloading the page.
This book is both an introduction and a demonstration of how Visual Basic for Applications (VBA) can greatly enhance Microsoft Excel® by giving users the ability to create their own functions within a worksheet and to create subroutines to perform repetitive actions. The book is written so readers are encouraged to experiment with VBA programming with examples using fairly simple physics or non-complicated mathematics such as root finding and numerical integration. Tested Excel® workbooks are available for each chapter and there is nothing to buy or install.
Price: £25.60
Publisher: Morgan & Claypool Publishers
Imprint: Morgan & Claypool Publishers
Publication Date:
07 December 2016
ISBN: 9781681744629
Format: eBook
BISACs:
Bernard V Liengme is a Retired Professor of Chemistry and Lecturer in Information Systems of St Francis Xavier University in Nova Scotia, Canada. He is the author of A Guide to Microsoft Excel® for Business and Management (two editions), and A Guide to Microsoft Excel® for Scientists and Engineers (six editions). More recently published is Modelling Physics with Microsoft Excel® and SMath for Physics: A primer, both IOP ebooks. Bernard has been awarded the Microsoft Most Valued Professional award in Excel® in eight consecutive years.
Table of Contents: Preface / Acknowledgements / Author biography / Ch1. Introduction / Ch2. Variables, Dim statements, and data types / Ch3. Structured programming / Ch4. The Excel object model / Ch5. Working with add-ins / Ch6. Numerical integration / Ch7. Numerical methods for differential equations / Ch8. Finding roots