Learn Excel VBA Macro

加入课程，掌握使用Excel宏自动化的过程

Join me in this course and take control of Microsoft Excel and master the process of automating routine tasks through the use of Excel Macros and Excel VBA.

During this course you will build a foundation of working with Excel Macros and VBA. This foundation will be built as you engage and participate in project based Excel Macro/VBA exercises, detailed throughout the lectures within this course. Each of the projects will build upon one another, introducing a new concept each time, starting with the basic building blocks of automating any task within Excel and ending with a fully customized Excel VBA project that will automate a series of Excel tasks.

Course Content:

1 Macro Recording part 1

2 Macro Recording part 2

3 Macro Recording part 3

4 Types of ways to run macros

5 Introduction to Macro

6 Start Macro Programming

7 Macro Task Basic

8 Methods to Refer Range

9 Selection of multiple cell

10 Formatting through VBA

11 End Command in VBA

12 Offset in VBA

13 Task on Data Entry Automate

14 Solution for the task

15 Methods to refer to sheets

16 Methods related to sheets

17 Sheet related task

18 Sheet Related Task Solution

19 Methods to Refer to Workbooks

20 Methods related to workbook

21 Workbook related project

22 Declared Vaiable

23 Data Types in Variable

24 Object variable related task

25 Solution of task 2

26 Variable Project

27 Apply IF in VBA

28 AND OR in VBA

29 Task for IF

30 Solution of IF task

31 Select Case

32 Select Case 2nd Scenerio

33 Select Case 3rd Scenario

34 Understanding Loop

35 Loop Practical example

36 Loop Related Task Solution

37 Do While Loop