Microsoft Excel VBA – Solving Complex Problems Using Basics

This course is entitled with emphasis: Solving Complex Problems Using Basics, it is designed to make you a skilled and fluent VBA programmer.

In this course, you’re going to learn Excel VBA programming concepts that will boost your coding skill and give you the ability to solve complex problems that are thrown at you. I will teach you the art of writing a complex code piece–by–piece using basic techniques.

This course aims to accomplish the following:

Sending clear commands to the application

You will learn about direct and indirect referencing of objects.

Learn how to achieve more results with indirect referencing of objects

Learn the VBA coding principle and send clear commands to the system.

Know the VBA language fluently,

understand every piece of your code.

String Manipulation

String manipulation is an important skill in solving complex problems.

With this skill, you can drastically reduce the size of your code, and target objects with precision.

I will teach you how to create dynamic strings with the objective to solve complex queries.

I will teach you how, when is it necessary, and why you should manipulate strings.

Code Management

If you want to be a fluent Excel VBA programmer, code management must rank first in your priorities.