Excel VBA

Join 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.

As you engage and participate in this course, you will be introduced to the wonders of creating simple Macros through the Macro Recorder and then quickly take you into the world of Excel VBA where you will experience building a more dynamic, robust experience for yourself and your peers.

So, don`t lose another moment performing Excel tasks manually. Enroll now and learn how you can get Microsoft Excel to your work for you.

Curriculum:

• Overview of Advanced VBA
• Loops, Conditional Statements, and Data Handling in VBA
• Working with Charts and Shapes
• Application Interaction using VBA
• User Forms in Excel
• Assignments and Projects