Microsoft Excel VBA - Solving Complex Problems Using Basics

About this course

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 applicationYou will learn about direct and indirect referencing of objects.Learn how to achieve more results with indirect referencing of objectsLearn 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 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 ManagementIf 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 codeComplex pr

Course objectives

• Teach the principles of VBA coding and code management
• Reduce redundancy and improve code clarity