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

Name: An Introduction to Excel VBA Programming: With Applications in Finance and Insurance
Price: 2280 TWD
Availability: OnlineOnly
Author: Gan, Guojun
ISBN: 0367261286

Gan, Guojun

出版商: CRC
出版日期: 2019-03-22
售價: $2,400
貴賓價: 9.5 折 $2,280
語言: 英文
頁數: 284
裝訂: Quality Paper - also called trade paper
ISBN: 0367261286
ISBN-13: 9780367261283
相關分類: Excel
其他版本: 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 程式碼和數據，以重現書中的結果
- 為合格的講師提供解答手冊

作者簡介

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.