Excel® VBA for Physicists
- A primer
- Bernard V Liengme
- December 2016
Description
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.About Editors
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
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 rootsBibliographic
Paperback ISBN: 9780750328463
Ebook ISBN: 9781681744629
DOI: 10.1088/978-1-6817-4461-2
Publisher: Morgan & Claypool Publishers