An Introduction to Excel VBA Programming: with Applications in Finance and Insurance

An Introduction to Excel VBA Programming: with Applications in Finance and Insurance

by Guojun Gan (Author)

Synopsis

Excel Visual Basic for Applications (VBA) can be used to automate operations in Excel and is one of the most frequently used software programs for manipulating data and building models in banks and insurance companies. An Introduction to Excel VBA Programming: with Applications in Finance and Insurance introduces readers to the basic fundamentals of VBA Programming while demonstrating applications of VBA to solve real-world problems in finance and insurance. Assuming no prior programming experience and with reproducible examples using code and data, this text is suitable for advanced undergraduate students, graduate students, actuaries, and financial analysts who wish to learn VBA.

Features:

  • Presents the theory behind the algorithms in detail
  • Includes more than 100 exercises with selected solutions
  • Provides VBA code in Excel files and data to reproduce the results in the book
  • Offers a solutions manual for qualified instructors

$94.96

Quantity

1 in stock

More Information

Format: Hardcover
Pages: 300
Edition: 1
Publisher: Chapman and Hall/CRC
Published: 02 May 2017

ISBN 10: 1138197157
ISBN 13: 9781138197152

Author Bio
Guojun Gan is an Assistant Professor in the Department of Mathematics at the University of Connecticut, where he has been since August 2014. Prior to that, he worked at Manulife Financial, a large life insurance company in Toronto, Canada, for six years. His research focuses on data mining and actuarial science. He has published four books and several papers related to data mining, actuarial science, and mathematical finance.