Excel VBA for Physicists

Excel VBA for Physicists

A Primer

Bernard V Liengme
ISBN: 9781681744605 | PDF ISBN: 9781681744612
Copyright © 2017 | 92 Pages | Publication Date: December, 2016

BEFORE YOU ORDER: You may have Academic or Corporate access to this title. Click here to find out: 10.1088/978-1-6817-4461-2


Ordering Options: Paperback $40.00   E-book $32.00   Paperback & E-book Combo $50.00

Why pay full price? Members receive 15% off all orders.
Learn More Here

Read Our Digital Content License Agreement (pop-up)

Purchasing Options:

This book is both introduction and 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.

Visual Basic (VB, the parent of VBA) has evolved to become a high-powered object-orientated language which is no longer denigrated by aficionados of language such as C++ and C#. The text is suitable not just for physicists but for other scientists and engineers, including students.

Table of Contents

1. Introduction
2. Variables, Dim statements, and data-types
3. Structured programming
4. The Excel object model
5. Working with add-ins
6. Numerical integration
7. Numerical methods for differential equations
8. Finding roots

About the Author(s)

Bernard V Liengme, St Francis Xavier University, Nova Scotia, Canada
Bernard Liengme is a retired Professor of Chemistry and Lecturer in Information Systems of St. Francis Xavier University in Nova Scotia, Canada where he taught for over 36 years. He is the author of: A Guide to Microsoft Excel for Business and Management (2 editions), and A Guide to Microsoft Excel for Scientists and Engineers (6 editions). The later has been adopted by various engineering schools worldwide. Both books have been translated into a number of languages. Bernard has been awarded the Microsoft Most Valued Professional award in Excel in each of the last eight years.

Related Series

IOP Concise Physics


Customers who bought this product also purchased
Modelling Physics with Microsoft Excel
Modelling Physics with Microsoft Excel
SMath for Physics
SMath for Physics
Browse by Subject
Case Studies in Engineering
ACM Books
SEM Books
0 items

Note: Registered customers go to: Your Account to subscribe.

E-Mail Address:

Your Name: