An Introduction to Excel VBA Programming: with Applications in Finance and Insurance
Author: Guojun Gan (Author)
Edition 版本: 1st
Publication Date 出版日期: 2019-03-22
Language 语言: English
Print Length 页数: 284 pages
ISBN-10: 0367261286
ISBN-13: 9780367261283
Book Description
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
About the Author
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.
下载地址
相关推荐
Reverse Engineering Armv8-A Systems: A practical guide to kernel, firmware, and TrustZone analysis- Practical IoT using Arduino and ESP32: Interactive experiments covering sensor reads, Wi-Fi, Bluetooth, and AWS IoT Core connectivity
- Practical GPU Programming: High-performance computing with CUDA, CuPy, and Python on modern GPUs
- MySQL 9 QuickStart Pro: Administrative strategies to upgrade, migrate and optimize databases with MySQL 9
- Practical Construction Planning and Control Using Microsoft Project: An Illustrative Guide
- Becoming An AI Orchestrator: A Knowledge Worker’s Guide to Leading, Creating, and Thriving in the Age of Intelligence
