Microsoft Excel VBA - Solving Complex Problems Using Basics
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
- Basic understanding of Microsoft Excel
- Completion of the course entitled Microsoft Excel VBA Fundamentals - Learn Basic Coding Skills
- You must be using Microsoft Excel 2010 to 365
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’ll learn Excel VBA programming concepts that will boost your coding skill and allow you to solve complex problems thrown at you. I will teach you the art of writing 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,
and understand every piece of your code.
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.
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 for 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.
We will dive into numerous built-in system functions and learn how to use them to achieve the task at hand.
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 it 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 using conditional statements or manipulating the execution of the code itself.
Learn code manipulation techniques like looping, arrays, select case statements, and various kinds of if-statements.
Learn how, why, and when to use each or a combination of both.
Learn how to create system memories e.g., Variables, Constants, and arrays
Learn the difference and understand when to use a variable, an array, and a constant.
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 had to say.
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.
Who this course is for:
- If you aspire to become a Microsoft Excel VBA coder, this is the right course for you
- If all you know is to record Excel macros to automate your spreadsheet
- If you have tried VBA coding before and it seemed too complicated for you
- Anyone interested in building a Microsoft Excel date picker
My name is Sihle Mhlanga and I’m an Accountant with a passion for Microsoft Excel.
I worked for companies with complex business structures. Over the years I have learnt how to adapt and conform to the challenges these businesses are facing by designing advanced Excel tools that don’t only simplify my work, but also work or do the job for me.
Recently I decided to build courses based on the real-world applications so that I can share my knowledge and help you stand out at work or acquire knowledge that will help you build tools that can simplify your business.