Excel® VBA for physicists

By Bernard V. Liengme

Subjects: Physics, Mathematical & Computational, Applied Physics, Microsoft Excel (Computer file), Microsoft visual basic (computer program), General, Mathematical Physics, SCIENCE, Data processing, Visual Basic

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.