Home » Introduction to Excel VBA Programming
Product Image

Introduction to Excel VBA Programming

Guojun Gan
€64.99
Quantity:
Ships in 10-20 days
Delivery/Collection within 10-20 working days
Shipping & Delivery
A01=Guojun Gan
actuarial mathematics
actuarial students
actuary
advanced spreadsheet automation
Author_Guojun Gan
Business Calendar
Category=KFF
Category=PB
Category=PBT
Category=UFC
Cell C3
CSV File
database integration methods
Discount Factors
eq_bestseller
eq_business-finance-law
eq_computing
eq_isMigrated=1
eq_isMigrated=2
eq_nobargain
eq_non-fiction
Excel VBA
financial modeling techniques
Fixed Length String
Forward Rates
GMDB
GMWB
Microsoft Excel
Module Level Variables
object-oriented programming
payment schedule calculation in insurance
quantitative risk analysis
Range Object
Recordset Object
Runtime Errors
SQL Expression
stochastic scenario generation
Swap Rates
Variable Annuity
Variable Annuity Contracts
VBA Code
VBA Function
VBA Macro
VBA Program
Visual Basic Editor
Workbook Object
Worksheet Object
Yield Curve

Product details

  • ISBN 9780367261283
  • Weight: 440g
  • Dimensions: 156 x 234mm
  • Publication Date: 22 Mar 2019
  • Publisher: Taylor & Francis Ltd
  • Publication City/Country: GB
  • Product Form: Paperback
Secure checkout Fast Shipping Easy returns
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 Guojun Gan

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.

More from this author