Mastering Excel VBA for the Real World
Embrace the Magic of Excel VBA Automation
4.75 (44 reviews)
151
students
9.5 hours
content
Apr 2022
last update
$44.99
regular price
What you will 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
Screenshots
Related Topics
2730098
udemy ID
12/31/2019
course created date
1/11/2020
course indexed date
Bot
course submited by