Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
9 Hour(s) 28 Minute(s)
Language
English
Taught by
Jose Sevilla
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
1 views
Course Overview
Embrace the Magic of Excel VBA Automation
By taking this course on Udemy, you will gain knowledge on the following:
How to:
1. Create dynamic code in your automations.
2. Become more efficient and get more time to focus on other assignments as you will be able to execute complex tasks in a single click.
3. Create Pivot Tables programmatically.
4. Create Pivot Charts programmatically.
5. Use methods such as: Replace, Sort, Remove Duplicates, AutoFilter and Find in Excel VBA to dynamically find columns names, rather than fixed column positions in a data set.
6. Easily Automate Microsoft Word from Excel and Integrate your Excel data into your Word Automation.
7. Use Excel VBA Dictionaries
8. Use ArrayLists to improve the efficiency of your codes.
9. Use If statements, Nested If statements, Else and ElseIf Statement in Excel VBA.
10. Use case statements and nested case statements.
11. Use Excel VBA loops, including: While Loop, Do While Loop, For Next Loop and For Each Loop.
12. Use advanced decision making logics along with Excel VBA Loops to create advanced and flexible codes in Excel VBA.
13. Master the debugging process of an Excel VBA application to understand what your code does and how it does it.
The List above contains just some of the many benefits and advantages that Excel VBA brings to the table.
Course Content
- 23 section(s)
- 65 lecture(s)
- Section 1 Introduction
- Section 2 Getting Familiar with the VBA Editor
- Section 3 Using the Macro Recorder Functionality
- Section 4 Building solid ground in Excel VBA
- Section 5 Learning about VBA Operators
- Section 6 Data Types in VBA and Variables
- Section 7 Font Object
- Section 8 With End With Statement
- Section 9 Set Statement
- Section 10 Excel VBA Built-In Functions
- Section 11 WorksheetFunction Object
- Section 12 User Defined Functions
- Section 13 Protecting your Macros
- Section 14 Excel VBA Key Methods
- Section 15 Conditional Statements for Decision Making
- Section 16 Excel VBA Loops
- Section 17 Automating Pivot Tables and Pivot Charts dynamically in VBA
- Section 18 ArrayLists in Excel VBA
- Section 19 Excel VBA Dictionaries
- Section 20 Automating Microsoft Word from Excel
- Section 21 Working with csv Files in VBA
- Section 22 Final HR File
- Section 23 Error Handling and Err Object in VBA
What You’ll Learn
- How to improve your productivity by automating repetitive tasks in a single click.
- How to Debug a code to understand what a code does, fix possible issues and make sure your code does exactly what you need it to do.
- How use Excel VBA Dictionary
- How to use ArrayList in Excel VBA with examples.
- How to programmatically create Pivot Tables and Pivot Charts in Excel VBA.
- How to use loops in Excel VBA (While Loop, do While Loop, For Loop and For Each Loop).
- How to make decisions using the If statement (else, ElseIf, nested if statements), and case statements (Case else, nested case statements).
- How to use Excel VBA user Defined Functions to avoid writing too much repetitive code.
- How to control Word from Excel (Automate MS Word from Excel using Excel VBA)
- How to use the font object.
- How to use dynamic code.
- How to work with csv files.
- How to work with multiple workbooks
Skills covered in this course
Reviews
-
SShubham Das
Nice
-
AAlex
Great course, the instructor took the time the provide very detailed information in a logical order. Great content.
-
TTCHICOU Michaël Titoh
Great! Very good course Thank You
-
WWilson Sanchez
Very good course, especially for someone like me who does not have any experience with VBA.
