你的困惑

你是否每天，每周，每月都花费好多个小时完成Excel的数据统计？

你是否每次觉得重复性手工生成图标太过于繁琐？

又是否觉得效率太过低下？敲下无数公式后还要另外制作PPT和图表，每个月又要用元数据生成一次？

反观隔壁桌的同事，运用起Excel如行云流水，工作效率得到上司的青睐，走上人生的巅峰。

而自己坐在电脑前发愁，夜晚辗转反侧，听到屋外夜夜笙歌可是自己却愁眉不展。

如果说这是一场LOL,其他人带了疾跑能快速到达终点，那么Terry老师的课如同开了全地图传送，顺便自带双buff，带你carry全场。

“职场需要一步一个台阶，而Terry老师带你闪送进巅峰”

什么是VBA?

Visual Basic for Applications（VBA）是Visual Basic的一种宏语言，由微软开发并在其桌面应用程序中执行通用的自动化(OLE)任务的编程语言。主要能用来扩展Windows的应用程序功能，特别是Microsoft Office软件。

换句人话来说就是：

想在Excel中想实现什么功能，就可以用VBA语言编写一段程序去完成。

1. VBA Introduction

Introduction of Excel VBA Editor

Project Explorer & Properties Window

Code Modules

Use Edit Toolbar

How to create a VBA subroutine & function

2. learn the logic behind VBA codes

Data types in Excel VBA

How to declare and use variables and object variables

How to Define constants value

How to use For…Next Statement

How to use For Each Loop Statement

How to use If…Then…Else Statement

How to use Multi-Ifs Statement

How to use Do While… Loop Statement

How to use Do Until… Loop Statement

How to use the Nested Loop Statement

Case: Show reporting currency amount for FX assets & liabilities

Case: Change report unit for P&L

3. Control Excel Objects by using VBA codes

Excel objects in VBA: Application & Workbook

Excel objects in VBA: Worksheets & Rang & Cells

How to Find the Object, Property & Method

How to use With Statements

Use offset statement to change range reference

How to find the Last Row of your Range in VBA

Referring to Ranges & Writing to Cells in VBA

Case: Calculate and highlight the overdue interest

Case: Sales for each salesperson

4. Using functions in VBA

What are Function Procedures in VBA

Use functions to control string data

Use functions to control numerical data

Use functions to control date

How to write User Defined Function (UDF)

Use Functions in Sub Procedures

5. Event-Driven Programming

 Run a Sub Procedures when you open, close, or save a workbook

Use Worksheet Selection Change Event to control VBA code

 Trigger a procedure by using a specific key

Case: Highlight items in the sales report

6. Debugging & Error Handling

Use Debug Toolbar

How to set Break Point to step through a subprocedure

Watch a value in a subprocedure

Use Immediate Windows to check the output

How to use Error Handling Statements (On Error, Resume, Goto, etc)