Skip to product information
1 of 1

EasyCareer Services

2024 | Excel VBA

2024 | Excel VBA

Regular price $169.00 CAD
Regular price $247.00 CAD Sale price $169.00 CAD
Sale Sold out
报名来源
  [ 课程亮点 ]
  • 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
    View full details