An Introduction to Excel VBA Programming: with Applications in Finance and Insurance
暫譯: Excel VBA 程式設計入門：金融與保險應用實例

Guojun Gan

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

相關主題

商品描述

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

商品描述(中文翻譯)

Excel 的 Visual Basic for Applications (VBA) 可用於自動化 Excel 中的操作，是銀行和保險公司中最常用的數據處理和模型建立軟體之一。《Excel VBA 程式設計入門：金融與保險應用》向讀者介紹了 VBA 程式設計的基本原理，同時展示了 VBA 在解決金融和保險領域實際問題中的應用。本書假設讀者沒有先前的程式設計經驗，並提供可重現的範例，包括程式碼和數據，適合希望學習 VBA 的高年級本科生、研究生、精算師和金融分析師。

特點：
- 詳細介紹算法背後的理論
- 包含超過 100 道練習題及其選擇解答
- 提供 Excel 檔案中的 VBA 程式碼和數據，以重現書中的結果
- 為合格的講師提供解答手冊

類似商品