Mastering Excel VBA for the Real World

Embrace the Magic of Excel VBA Automation

Created by: Jose Sevilla
Senior Software Engineer

What Will I 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

Requirements

• Basic Excel Knowledge
• Basic Excel VBA Knowledge
• Desire to learn the Magic of Excel VBA Automation

Target audience

• Business Analysts
• Reporting Analysts
• Data Analyst
• Any Excel user who wants to start automating complex and repetitive tasks