[ 课程亮点 ] 0学习门槛 —— 从零基础小白到金融建模大神 4个项目实战Project —— 基金公司资产分配、二级市场股票预测、数据自动化处理、图形报表制作与展示 9大板块 —— 从关键知识点到行业常用建模分析应用 [ 课程所学技能 ] 基础及进阶类Excel函数 批量处理数据，从海量报表中解放 创建金融模型实现自动化数据处经理 统计类工具：Pivot Table 可视化工具：Charts 决策类工具：Solver 自动化编程工具：VBA [ 课程大纲 ] Chapter 1: Excel Basic Basic Math/Date/Time in Excel Excel Basic Function and Chart Chapter 2: Excel Advanced Excel Advanced Function I: Logic and Aggregate Function Excel Advanced Function II: Financial Function Excel Advanced Function III: Vlookup/Search/Index/Match Chapter 3: Reporting Pivot Table Data Visualization and Regression Models Chapter 4: Problem Solving Project I: Optimization Solver Model:Asset Allocation Project ll: Stock Price Simulation Case Study: Spreadsheet Design Chapter 5: Introduction to Excel VBA What is VBA？ "Hello, World!" Program Excel Macro Recorder Chapter 6: VBA Basic If Logic in VBA While Loop in VBA Dictionary in VBA Chapter 7: VBA Advanced Project 1: Business Process Automation Project 2: Data Visualization in VBA Other Common VBA Uses in Business
