2024 | Excel VBA
2024 | Excel VBA
Regular price
$169.00 CAD
Regular price
$247.00 CAD
Sale price
$169.00 CAD
Unit price
/
per
[ 课程亮点 ]
- 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