Microsoft Excel VBA - Solving Complex Problems Using Basics

Become a fluent Excel VBA coder. Get a step-by-step guide, learn as you build an intelligent Excel VBA programme.

What you'll learn:

• VBA (Visual Basic for Applications) programming language
• System Functions and User Defined Functions
• Get a profound knowledge about Event Procedures
• Named Memory - Variables and Constants
• Learn the technique of looping through arrays
• Learn how to work with conditional statements (the If Statement)
• Separation of concerns
• Learn how to write a clean and easy to maintain code
• Perfect your debugging skills
• Learn the strategy of breaking down a complex problem into solvable pieces

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.

  • Without this skill, your code is likely to be a heavyweight, too long, with too many duplicates, clustered and confusing

    • Therefore, I will teach you:

      • several ways of debugging your code,

      • the principle of separation of concerns,

      • and how to search and eliminate redundancy.

• Strategies of writing an intelligent VBA code

  • Complex problems are won through strategy and not through sophisticated coding.

    • This means you win before you write the code. Yes, you win before you start.

  • In this course, I will teach you how-to strategies. This includes:

    • the naming conversation used in the programme.

    • Studying the programme and anticipating its move as if it's your opponent.

    • Choosing the best move because, in VBA, there are many solutions to a single problem. However, not every solution is perfect in all circumstances; some come with consequences.

• System Function

  • We will dive into numerous built-in system functions and learn how to use them to achieve the task at hand.

• User-defined Functions

  • You will learn why, when, and how to create your own functions

  • You will learn the difference between sub procedures and functions

  • Learn how to lighten your code by teaming a variable with a function and learn why is that important.

  • Avoid common coder mistakes; use of functions where variables are the best choice.

  • Understand that not everything that works is as efficient as it seems.

• Solving conditional based problems

  • Conditional problems are solved by manipulating the execution of the code itself.

    • Learn code manipulation techniques like looping and various kinds of if statements.

    • Learn how, why, and when to use each or a combination of both.

• System memory

  • Learn how to create system memories e.g., Variables, Constants

  • Learn the difference and understand when to use a variable and a constant.

  • Learn how to group related constants using an Enum

• Events and Sub procedures

  • You will learn what event procedures are, and how are they different from user-defined sub-procedure.

  • You will get an in-depth understanding of the Initialize event and the click event.

I put a lot of planning into this course so that you will learn with understanding, and without overwhelming yourself. Your learning will be practical, and there is a clear step-by-step guide.

Check out the reviews and listen to what those who have finished the course are saying.

If you have tried Microsoft Excel VBA before and it seemed too complicated for you, you can try it with me. Learn the skills of writing a clean Excel VBA code, sending clear commands that can be easily decoded by the system and executed to your expectations.

So, what are you waiting for? Signup now and I will gracefully guide you, and you will become a fluent coder in no time.

Thank you