Add to Cart

Excel® VBA for Physicists

A primer
Bernard V Liengme


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 roots


Paperback ISBN: 9780750328463

Ebook ISBN: 9781681744629

DOI: 10.1088/978-1-6817-4461-2

Publisher: Morgan & Claypool Publishers


« Back