Learn Excel VBA Macro APK

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