Excel VBA and Macros - Beginners to Advanced Course
- Description
- Curriculum
- FAQ
- Reviews
Course Material Works in Microsoft Excel 2007, 2010, 2013 and 2016, Office 365
This course is going to take you by step-by-step detailed and engaging video tutorials and train you on all the Excel VBA aspects which you should learn. After completing this course, you will be able to create well defined, clean codes to automate your routine Excel Jobs to increase your productivity.
Once you start this course, you will feel engaged and confident with advanced level of Excel VBA Codes which will make yourself different from the crowd. After each lesson, you will be assigned with an assignment which will give real hands-on experience. Each assignment is connected to the next assignment, hence it will keep you engaged and will make you to create robust, dynamic VBA codes or Macros for yourself and your peers. This will make you to achieve greater productivity and ease your life with your regular Excel Jobs. You will also be able to create stunning new Excel Features which will impress all your colleagues, bosses.
Why you should Enroll in this Course:
- To get well versed with Real Life Scenarios
- To draft Clean and Standard VBA Codes
- Hands-On Experience
- Simple Explanations and Clear Videos
- On Training Support – Response within 24 hours
- Get Quick VBA Tips to create quick VBA Codes
Things you get in this Course:
- Understand how to use the right syntax in VBA
- Useful Excel VBA codes you can directly use for your work
- Use the macro recorder for simpler tasks and improve the code
- Working with the Visual Basic Editor
- Debugging tools and error handling methods
- Different ways to reference ranges and cells
- Different methods to loop
- How to work with data types
- PivotTables in Excel using VBA
- Importing data from other files and exporting data to text files
- Interacting with other applications (Word, PowerPoint, Outlook)
- User forms to enhance the Excel interface
- Basically all the knowledge you need to automate tasks in Excel
Each of these projects will direct you through key Excel VBA programming concepts and direct you to identify and use best practices in creating Excel Macros.
Hence don’t waste time, Enroll now and learn how you can get Microsoft Excel to your work for you.
-
16
Arithmetic Operators Introduction -
17
Arithmetic Operators in Excel VBA
-
18
String Operators Introduction
-
19
String Operators in Excel VBA
-
20
Comparison Operators Introduction
-
21
Comparison Operators in Excel VBA
-
22
Logical Operators Introduction
-
23
Logical Operators in Excel VBA
-
24
Operators -
25
Find Syntax and Logical Errors
-
34
Excel Object Model
-
35
Working with Cells Introduction
-
36
Working with Cells in Excel VBA
-
37
Working with Ranges Introduction
-
38
Working with Ranges in Excel VBA
-
39
Working with Worksheets Introduction
-
40
Working with Worksheets in Excel VBA
-
41
Working with Workbooks Introduction
-
42
Working with Workbooks in Excel VBA
-
43
Working with Application Object Introduction
-
44
Working with Application Object in Excel VBA
-
45
Excel Object Model
-
46
Calculate Sum and Average
-
47
If, If Else, If ElseIf Else Introduction
-
48
Practical Example of If Conditional Statement in Excel VBA
-
49
Nested If Introduction
-
50
Practical Example of Nested If Conditional Statement in Excel VBA
-
51
Select Statement Introduction
-
52
Practical Example of Select Statement in Excel VBA
-
53
Conditional Statements
-
54
Color Names
-
55
For Loop Introduction
-
56
Practical Example of For Loop in Excel VBA
-
57
For Each Loop Introduction
-
58
Practical Example of For Each Loop in Excel VBA
-
59
Exit For Loop
-
60
While Loop Introduction
-
61
Practical Example of While Loop in Excel VBA
-
62
Do While Loop Introduction
-
63
Practical Example of Do While Loop in Excel VBA
-
64
Exit Do Loop
-
65
Loops
-
66
Check Holiday
-
67
Instr Function Introduction
-
68
Practical Example of InStr Function in Excel VBA
-
69
StrReverse Function Introduction
-
70
Practical Example of StrReverse Function in Excel VBA
-
71
LCase, UCase Function Introduction
-
72
Practical Example of LCase and UCase Functions in Excel VBA
-
73
Left, Right, Mid Function Introduction
-
74
Practical Example of Left, Right and Mid Functions in Excel VBA
-
75
Trim Function Introduction
-
76
Practical Example of Using Trim Function in Excel VBA
-
77
Len Function Introduction
-
78
Practical Example of Len Function in Excel VBA
-
79
Replace Function Introduction
-
80
Practical Example of Replace Function in Excel VBA
-
81
String Functions
-
82
String VBA Functions
