投资银行面试必备资料-基于excel和vba的高级金融建模.doc

目 录 前言 .............................................................................................6 致谢 .............................................................................................7 第 1 章 介绍 ...............................................................................8 1.1 金融学概览.........................................................................................................................8 1.2 收益分布假设.....................................................................................................................9 1.3 数学和统计方法.................................................................................................................9 1.4 数值方法.............................................................................................................................9 1.5 Excel 解决方案 ..................................................................................................................9 1.6 本书主题...........................................................................................................................10 1.7 有关 Excel 工作簿 ...........................................................................................................11 1.8 意见和建议.......................................................................................................................11 第 2 章 高级 Excel 函数和过程..............................................12 2.1 访问 Excel 函数 ...............................................................................................................12 2.2 数学类函数.......................................................................................................................13 2.3 统计类函数.......................................................................................................................14 2.3.1 使用频率函数 Frequency......................................................................................15 2.3.2 使用分位数函数 Quartile .....................................................................................16 2.3.3 使用正态函数 Norm .............................................................................................17 2.4 查找类函数.......................................................................................................................18 2.5 其他类型函数...................................................................................................................19 2.6 审核工具...........................................................................................................................20 2.7 模拟运算表（Data Tables） ...........................................................................................21 2.7.1 建立单变量模拟运算表........................................................................................21 2.7.2 建立双变量模拟运算表........................................................................................22 2.8 XY 图.................................................................................................................................24 2.9